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

[NailDyanC]

Hello, just want to add to the previous comments above, you may check as well some Caspio limits in this article about System Limitations: https://howto.caspio.com/troubleshooting/system-limitations/

[cheonsa]

Hi all,

I just wanted to share this Trigger setup that will update the Total field on the Parent Table every time a new record is inserted or updated on the Child Table.