Help with Calculations for totals again

[plance]

Hi please help... I need to have calculations done instantly on this form to gather the totals...

Thank you in advance! Paul

[MayMusic]

Are you trying to calculate the value as soon as you enter values into the textbox before hitting update button? If yes, then you need to have a Java Script to perform this task. Maybe a function which executes when you the last textbox loses the focus. As far as I know calculated fields are getting the values from table and runs upon page load but since there is no value in the table (I see your textbox are null) then there won't be any calculated value yet. :wink: :wink: :wink: :wink:

[Kurumi]

Hi @plance,

Regarding calculations, you may want to check these links for more information. 

https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

I hope this helps!

[NailDyanC]

Hi Just to add to the previous comment above, you may also find these video tutorials useful:

 

And just an update, you can now add the Calculated Value form element to Update Forms and Details Pages to generate dynamic calculations as users interact with your forms. Previously, this feature was only available in Submission Forms. You may check this link: https://howto.caspio.com/release-notes/caspio-bridge-17-0/