Referencing data for Calculation

[AIloser]

I have created a calculating form in Caspio and it works well...www.adkinsautoparts.net/trip .  The formulas that I used I based off my variables and information and are in the data table.  I would like to design another form where future users could input their own variables that the calculating form could reference in the formulas/calculating fields in my calculator.  Any suggestions would be appreciated.

 

[Tubby]

Basing off the website, it seems that you can input your values fine. So I am quite confused with the question. Anyways, if you just need some fields to input values without saving them in the table, you can always use "Virtual Fields". Its like fields but not actually. It is a temporary holder of values so you can use them the same way you use Table Fields/Variables. To add a Virtual Field just click the "+" button in the Configure Fields page in the DataPage Edit Wizard and get Virtual Fields.


You can then call that Virtual field in the Calculated Values that you are using. (Additional Tip: Virtual Fields can also be set to a Calculated Value for displaying a calculation without saving it to table)

[Tubby]

Adding this Article for additional reference: https://howto.caspio.com/datapages/datapage-components/virtual-fields/

[cheonsa]

You may also check this article for more details about Calculated Value: https://howto.caspio.com/datapages/datapage-components/calculated-values/

[NailDyanC]

Just to add, you may consider as well checking this video tutorial about Calculated Values: