Jump to content

WatashiwaJin

Caspio Guru
  • Content Count

    116
  • Joined

  • Last visited

  • Days Won

    5

WatashiwaJin last won the day on July 24

WatashiwaJin had the most liked content!

1 Follower

About WatashiwaJin

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi @Carioca -- Just want to inform you that Caspio's SMS feature only supports US & Canada phone number for now. You can check this article and video tutorial for more details: ============ https://blog.caspio.com/tip-sms-notifications-from-caspio-apps/ https://blog.caspio.com/send-automatic-sms-alerts-using-twilio/ ~WatashiwaJin~
  2. You can also try to check this helpful documentation about dates and calculations: https://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/ https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ https://howto.caspio.com/function-reference/
  3. Hi @NeoInJS -- if that is the case then I suggest that you follow these steps: - Add a "Virtual field" that uses "Calculated value" as the form element and paste the formula: CONVERT(DATETIME, (CAST(Month(SysUTCDateTime()) AS VARCHAR) + "/01/" + CAST(Year(SysUTCDateTime()) AS VARCHAR)), 101) - You can also hide the Virtual field -> go to the advance option then check "Hide Field: - Now, we are going to create a script that will get the value form the formula. For us to do that we need to add a "Header and Footer" -> then in the footer paste this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var vrt = document.querySelector('[name*=cbParamVirtual1]'); var date = document.querySelector('[name*=InsertRecordYOURDATEFIELD]'); vrt.onchange = function() { date.value = this.value.substring(0,9); } }); </script> - Make sure that you unchecked the "Enable HTML Editor" in the advance tab of the Footer. - After this process, your date field will get the first day of the month and it still can be editable For more details, check these article: https://howto.caspio.com/function-reference/ https://howto.caspio.com/datapages/ajax-loading/ I hope this helps ~WatashiwaJin~
  4. Hello @NeoInJS, For you to be able to get the first day of the month, you should use "calculated value" as the form element then paste this formula: CONVERT(DATETIME, (CAST(Month(SysUTCDateTime()) AS VARCHAR) + "/01/" + CAST(Year(SysUTCDateTime()) AS VARCHAR)), 101) I hope this helps. ~WatashiwaJin~
  5. Hey @waltmayo as I know Caspio offers an Expert session that will help you with your issue with scripts or complex functionality. An Expert Session is a 1-hour session that is conducted via screen share by a Caspio Support Engineer. It also has a cost of $250/hr. If you want to continue, just contact Caspio support: https://www.caspio.com/support/
  6. Hi, just to update this post. Here are the new and updated links that you can use and refer: Caspio's Ready-Made-Applications: https://www.caspio.com/apps/
  7. Hi, just to update this post. Here are the new and updated links that you can use and refer: Custom Hide fields in Submission form: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
  8. Hey @oceaim have you tried to use the "responsive code" in your DataPage? This might solve your issue, check it out: https://howto.caspio.com/tech-tips-and-articles/responsive-datapages-overview/ ~WatashiwaJin~
  9. Hi @TroyPurdue, Please note that you cannot use the Aggregated functions directly in the Formula or Calculated fields: For more information, check this documentation: https://howto.caspio.com/function-reference/ ~WatashiwaJin~
  10. You can also refer to this following documentation: https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ https://howto.caspio.com/function-reference/
  11. Hi @wmclaren, For this workflow, I suggest that you use a calculated field to determine if the value is a win or loss. Example: CASE WHEN [@field:FieldName] = 'Win' THEN 1 ELSE 0 END Then use the that calculated field in the Totals and Aggregation, and use AVG() to get the percentage of that. I hope this helps. ~WatashiwaJin~
  12. WatashiwaJin

    Column Widths

    You can actually change the column width of the result DataPage in the advance tab configuration of the field itself:
  13. Hi @dmchenry, You can actually do sorting in report and use your DateTime field as the default sort. Check video tutorial for more further details:
  14. Hi @fromtheabbey, You might also want to refer to this documentation related to your inquiry: https://howto.caspio.com/parameters/parameters-as-query-string-values/ https://howto.caspio.com/parameters/passing-parameters/ https://howto.caspio.com/parameters/receiving-parameters/
  15. Hi @Chuchu -- you can check the data cell properties in the Style connected in the specific DataPage, check the screenshot below: For more information check this documentation: https://howto.caspio.com/styles/ https://howto.caspio.com/styles/creating-or-editing-style/ ~WatashiwaJin~
×
×
  • Create New...