Jump to content

WatashiwaJin

Caspio Guru
  • Content Count

    116
  • Joined

  • Last visited

  • Days Won

    5

Everything posted by WatashiwaJin

  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~
  16. Hi @NickO, For this process, I suggest that you use the Pivot DataPage to only get the summarize/group report and use the Aggregate function for the calculation and the output will depend on your configuration. You can check this documentation for more information: https://howto.caspio.com/datapages/reports/pivot-table/ I hope this helps ~WatashiwaJin~
  17. You can also refer to this article and documentation for more information: https://howto.caspio.com/function-reference/
  18. Hi @FinTheHuman, If you want the result to be editable then you will need a custom script to do that, follow this process for the step: (1) Use a Virtual field to do the calculations of the formula provided earlier and insert a DATETIME field(to store the output of the formula) (2) then make the Virtual field hidden : (3) Insert a Header & Footer -> and paste this code in the Footer part: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var src = document.querySelector('[name*=cbParamVirtual1]'); var dest = document.querySelector('[name*=InsertRecordDATE]'); src.onchange = function() { dest.value = this.value.substring(0,9); } }); </script> Important Note: - Make sure that you unchecked the "Enable HTML editor" in the advance option of the Footer. - Use the correct name value of your actual field in the script. - The "var src" is the SOURCE of the value(where the formula is located). - The "var dest" is the DESTINATION of the formula output (the editable Date field itself). - This process is working on my end. Feel free to test it out here: https://c1abv183.caspio.com/dp/482760009312d3d82a8949d4987e I hope this helps ~WatashiwaJin~
  19. Hi @FinTheHuman, You can add new Virtual field and use "Calculated value" in the form element then paste this formula to get the next day excluding the weekend: CASE WHEN ((DatePart(dw, GetUTCDate())) = 6) THEN (DateAdd(day, 3, GetUTCDate())) WHEN ((DatePart(dw, GetUTCDate())) = 7) THEN (DateAdd(day, 2, GetUTCDate())) ELSE (DateAdd(day, 1, GetUTCDate())) END I hope this helps ~WatashiwaJin~
  20. Hi @SonoftheSun, You will need to cast/convert the result of the Aggregation into a text if you want them to be concatenated. Example: 'Total: ' + CAST((SUM([@field:Income])) as NVARCHAR) + ' || Expected: ' + CAST((SUM([@field:Target])) as NVARCHAR) I hope this helps. ~WatashiwaJin~
  21. @SteveT - In addition to the recent response, you can check this documentation for further details: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ https://howto.caspio.com/parameters/passing-parameters/ https://howto.caspio.com/parameters/receiving-parameters/ You can also try to test this DataPages for process suggested: CASE 1: https://c1abv183.caspio.com/dp/482760004de745373bcd4bd48c8c CASE 2: https://c1abv183.caspio.com/dp/482760005657f390af2d4ec0b1d2 ~WatashiwaJin~
  22. Hi @SteveT, As far as I understand, you want to have second/another search within the primary search. Basically, search again after in the filtered result. If that is what you want then I suggest that you follow these process: (1) Create a Submission form with Virtual field(s) *for your first search/filter -> check "OnExit" in the advance option and change the parameter name -> then paste the next URL (the search and report DataPage): (2) Create a Search and Report DataPage then in the configuration of search field(s), received the parameter that is being passed. Then follow the 2 scenarios below: Case 1 (Search with a different field): If the first search is to filter the initial result then you will do search again with a different field then do this process: Case 2 (Search with the same field): If you will also search with the same field to get a result then do this process: Let me know if you have further questions. I hope this helps ~WatashiwaJin~
  23. You can also check this articles for further information: https://www.codeproject.com/Questions/1248034/How-to-get-the-week-number-of-a-month-in-SQL https://howto.caspio.com/function-reference/
  24. Hi @FinTheHuman - In addition for the earlier response, you can also use this formula to get the week number with the corresponding month via DataPage level: CASE WHEN (DatePart(day, DateDiff(day, 0, [@field:DATE])/7 * 7)/7 + 1) = 1 THEN 'Week 1 of ' + (DATENAME(month, [@field:DATE])) WHEN (DatePart(day, DateDiff(day, 0, [@field:DATE])/7 * 7)/7 + 1) = 2 THEN 'Week 2 of ' + (DATENAME(month, [@field:DATE])) WHEN (DatePart(day, DateDiff(day, 0, [@field:DATE])/7 * 7)/7 + 1) = 3 THEN 'Week 3 of ' + (DATENAME(month, [@field:DATE])) WHEN (DatePart(day, DateDiff(day, 0, [@field:DATE])/7 * 7)/7 + 1) = 4 THEN 'Week 4 of ' + (DATENAME(month, [@field:DATE])) ELSE 'Week 5 of ' + (DATENAME(month, [@field:DATE])) END ~WatashiwaJin~
  25. Hi @FinTheHuman - you can use this formula to get the specific number of the week for the current month selected in your DATE field: DatePart(day, DateDiff(day, 0, [@field:DATE])/7 * 7)/7 + 1 I hope this helps ~WatashiwaJin~
×
×
  • Create New...