looping action Automation

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

Solved Solved
0 6 344
1 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.

View solution in original post

6 REPLIES 6
Top Labels in this Space