Form question

[MartyToledo]

I'm new to Caspio and have gotten thru the first couple of tutorials and so far have seen no reference to the ability to do the following:

- formulas and calculations in the form (I did see the capabilities in report)

- the ability to update one record from from a value in another record. This could be math relationship or could be replacement relationship.

I was hoping somebody could point me to a reference on these two topics. Thanks in advance.

Marty

[shengnandou]

Hi Marty,

To answer your first question, currently Caspio only provide calculation on report Datapages as a standard feature (for plus accounts and above). If you would like to perform calculation on Web Forms, Javascript is needed to custom program this. Examples can be found at: viewforum.php?f=14.

Regarding the second question, it is possible by passing parameters. You will need to create two Report Datapages or Update Form to do so. The first Form is used to find and display the record that you would like to make a copy of. Either insert a custom link which opens the new record and passes the fields out as parameters, or utilize the 'destination and triggers' function to link to the next page as well as pass parameters. Here are the help articles on parameters: http://howto.caspio.com/parameters/ and I highly recommend you to go over the following two: http://howto.caspio.com/parameters/pass ... tring.html and http://howto.caspio.com/parameters/rece ... eters.html.

Hope this helps.

[cheonsa]

Hi @MartyToledo,

 

Just to give you an update regarding your first question, performing a calculation in web forms is now a standard feature of Caspio.

For reference, you can visit this link: https://howto.caspio.com/datapages/datapage-components/calculated-values/

 

Regards,

kristina

 

[ManokNaPula]

For the second question, "the ability to update one record from from a value in another record. " 

 

I think, the Triggered Actions can do the trick. 
Check out this documentation about triggered actions: https://howto.caspio.com/tables-and-views/triggered-actions/

Hope this helps 

[NailDyanC]

Hi,

You may also try to refer to this video tutorials :

Trigger actions:

 

 

 

Calculated Fields:

 

I hope that helps.