looping action Automation

[tony98]

Hi all I have an issue with AppSheet automation which is meant to add a new row to my table as well as do some calculations in the recently added row, I am trying to make it in a way that when the save button is clicked, it will automatically do it

[Aurelien]

Hi @tony98 

Here is the combination you need:

View events - AppSheet Help

Section "Form Saved (Form Views)" and "Event actions"

And the action to trigger is the one of type "Data: execute an action on a set of rows".

For reference:

Use bulk actions - AppSheet Help

[tony98]

Hi , thank you

i tried however get errors with my formula which says 

in this case what can I do to solve it?

[Lynn]

Hi @tony98 

Where is this expression and what are you trying to do with it?

[tony98]

i am trying to put the expression in circled

I want it to take the valued from the quantity required to the quantity allocated 

[dbaum · Accepted solution]

Component Allocations[Quantity Required] returns the list of values in that column across all rows. From the information you've provided so far, it sounds like you want that column's value from just a single row, but it's unclear from which row--especially given that you're creating a brand new row. Potentially what you need instead of including the Quantity Allocated column in your action at all is to define an Initial value expression for the Quantity Allocated column that returns a default value based on the Quantity Required column.

[Aurelien]

What about:

SUM([Related COMPONENT ALLOCATIONSs][Quantity Allocated])