Jump to content
  • 0
Sign in to follow this  
Jess147

Totals

Question

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

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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.

count_trigger_on_Insert.PNG

 

I hope this helps.

 

~ H

Share this post


Link to post
Share on other sites
  • 0

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?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...