Data actions using 2 values from _thisrow

AppSheet AppSheet Q&A
1

Hi,
I’m trying to automate a data action where-

  1. 2 IDs are collected from [_THISROW]
  2. Data is selected based on 1 ID from a table using “Data: execute an action on a set of rows”,
  3. Then copied to a another table using “Data: add a new row to another table using values from this row”. When this action is performed I want to add the 2nd ID from step 1 in a column for all new rows.

Because the 2nd ID is not found in the “for a record table” in step 3, I can’t determine a way to add it within the existing automation.

Please help. I’ve ran out of logical options

2

Set input values dynamically in data-change actions

1 Like