Jump to content


  • Content Count

  • Joined

  • Last visited

  1. Hello @DDNex, HTML blocks can be added to the DataPage for adding descriptive text, links or graphics to your DataPages. They can also be used to add snippets of JavaScript, HTML or CSS. For the Conditional Cases, you need to use Calculated Fields. You may check this article: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ So the answer is yes, you need to have the calculated field. Regards
  2. Hello @DRomano, Please choose the Formatting on the Calculation Field and select Formatting: Custom, Format type: Short date. Also you need to make sure that Short Date is in correct format in the Localization that you use for the DataPage. Hope this helps!
  3. sandy159

    Hide datapage

    Hi @DDNex, You may want to look into Conditional Forms: https://howto.caspio.com/datapages/forms/conditional-forms/ Or if it is not what you are looking for, please elaborate on your workflow. Regards
  4. Hello @richs, I believe you may have this problem because [@field:town] is the text value. You may get the value of the Mill_rate from your lookup table with the following formula so it will be the Number type: SELECT [@field:Mill_rate] FROM Town_lookup WHERE Town=target.[@field:Town] And then you can have another calculated value which is [@field:House_value]*[@field:Mill_rate]/1000 Just change the names of the fields to yours. Hope this helps!
  5. Hello @mruns, If you want your calculator to display calculated values without the user actually submitting any data to the table, you will need to add Virtual Field to your Submission form. Just select the Virtual Field from the picker and then set Form element to Calculated Value. Please refer to the screenshot below. Hope this helps!
  6. Hello, @senicholas you are right. I suggest you should use a formula like this: SUM(ISNULL([@field:Total_price],0)) , where Total_price would be your calculated field of # of units * cost per unit. Or you may try ISNULL([@field:Total_1],0)+ISNULL([@field:Total_2],0)+ISNULL([@field:Total_3],0) , etc. As an option, you may also use Totals & Aggregation field on the Report page, so you will not need to write any formulas. Hope this helps!
  • Create New...