Search the Community
Showing results for tags 'calculate'.
Hi, I need help with calculating total sum based on values, entered in fields. I have 3 fields on the submission form, where users enter 3 values. I would like to calculate total in the forth field. Also, I want to show the value to the user. E.g when user enters value "5" in the first field, he will see "5" in the field Total then user enters "10" in the second field, he will see "15" in the field Total and finally user enters "7" in the third field, he will see "22" in the field Total And I wand to store value 22 in the table. Thanks!
Hi there,I had this simulator created https://c3esh258.caspio.com/dp.asp?AppKey=d5ad4000296a67c788fa46879a87 and the field "Idade 1º titular" reads an Excel cell that have number values of age from 18 to 80.How can I make "Data de Nascimento 1º titular" do the same thing - reading the age value from that Excel cell - but instead of inputing the age itself, doing so by inputing the date of birth?I would really appreciate any help.Regards,Rui Farinha
This old post from Caspio should be updated with the following changes so that it works when Grouping is enabled: http://forums.caspio.com/index.php/topic/3171-js-calculate-column-sum-in-the-result-page/ Aggregation should be used instead, but if you want to SUM a Calculated Field which in turn is based on a sub-query, it will not be available for Aggregation. See the second paragraph here for details on this case http://howto.caspio.com/release-notes/caspio-bridge-9-0/9-0-known-issues/ I've highlighted the changes below </div> <script> function NumberFormatted(am