Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


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 @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~
  2. 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/
  3. 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~
  4. WatashiwaJin

    Column Widths

    You can actually change the column width of the result DataPage in the advance tab configuration of the field itself:
  5. 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:
  6. 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/
  7. 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~
  8. 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~
  9. You can also refer to this article and documentation for more information: https://howto.caspio.com/function-reference/
  10. 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~
  11. 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~
  12. 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~
  13. @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~
  14. 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~
  15. 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/
  • Create New...