How can I update the status of a child table?

AppSheet AppSheet Q&A
1

Hello,

Automation cannot filter specific rows in the child table from the data in the parent table.

The app has a parent table (purchase history) and one child table (details), which are connected by ref.
The child table has an id column for the parent table, which is a one-to-many relationship.
When the parent table is updated, an update event occurs and the following actions are taken:

  1. Extraction of target rows
    Do this: execute an action on set rows
    Referenced Rows:
    SELECT (details [status], AND ([_ THISROW]. [Id] = [id], [status] = “open”));

  2. Set of data
    Do this: set the values of some columns in this row
    Set these columns: [status] = “close”

However, it seems that the extraction is not successful even if I use the column [status] of the child table.
How can I update the status of a child table?

2

For referenced rows, you will need to use a list of keys, something like

SELECT (details [Details Table key], AND ([_ THISROW]. [Id] = [id], [status] = “open”))

3 Likes
3

@Suvrutt_Gurjar

Awesome! It’s solved！

Thank you so mush :heart_eyes:

2 Likes