Totals

[Jess147]

Hi everyone. 

I have tabular report that has a column for prices. I use Totals and Aggregations to calculate the total of that column. I want the value on the total to be automatically inserted to a field on the other table. How will I do that?

 

Thanks

[JolliBeng]

Hi @Jess147,

You can achieve that workflow using triggered actions. But first, the records that needs to be calculated should be saved on your table. I suggest that you use Formula fields for calculations or directly calculate it under your triggered actions.

You may refer to the following links:

https://howto.caspio.com/tables-and-views/data-types/formula-fields/

https://howto.caspio.com/tables-and-views/triggered-actions/

-JolliBeng

[Harbinger]

Hi @Jess147, First off, I would suggest using a triggered action in your main table to calculate the total of the column, then send the value to another field from the table where you will insert the data. To do this, you will need to add an INSERT block, select the table where you want to insert the data --> Now set the field that will contain the total calculation and send to another field that will receive the value to the selected table.

Here's the screen capture of my sample triggered action.

 

I hope this helps.

 

~ H

[Jess147]

Thank you for your answers! It really helped a lot.

 

I have another question. I'm just curious, is there a limit on up to how many records can a trigger insert?

[JolliBeng]

Hi @Jess147,

As far as I know, Up to 10,000 records can be updated from a Triggered Action event.

 

-JolliBeng