Calculate log entries in child table and submit total into parent table

[aarchuletajr]

Hello,

I am trying to take multiple cost entries in a project cost log child table, total them up and insert the total into the parent field Total Project Cost. For example:

In child table:

Task 1- 1000

Task 2 - 200

Task 3 - 250

Total - 1450

Parent table:

Total Job Cost - (Have calculated (1450) entered here.

I was trying to figure out a way to pass the aggregated total from a tabular report as an external parameter into am Update Table Form but didn't see a way to do it.

[MayMusic]

You need to have a triggered action on your child table on Insert / Update to calculate the total Cost and add it to the parent table. https://howto.caspio.com/tables-and-views/triggered-actions/

[aarchuletajr]

12 hours ago, MayMusic said:

You need to have a triggered action on your child table on Insert / Update to calculate the total Cost and add it to the parent table. https://howto.caspio.com/tables-and-views/triggered-actions/

May I tried to set up a trigger but i think i have it setup incorrectly because instead of summing all the submissions for all submission for a specific Job_ID into the parent table it is creating new single entries into the parent table

[Hastur]

@aarchuletajr

Here is the example of the trigger you need:

The "New" block returns the sum of all new values and "Existing" block returns the sum of all existing values.
Case block within the "SET" part checks if the Existing sum is present.
If not, it throws "0" as the value.

You can find the application with this trigger  attached - TRIGGER_Update_Parent_Total_1_0_2019-Jun-12_0929.zip