Is is possible to create a list base on information from the row in a table that triggered an event?
SELECT([ID], [ID] = [The row from the other table that triggered the event].[reference column to parent table])
Solved! Go to Solution.
The Referenced rows property requires a list of IDs from the Referenced Table. Since the action was triggered from a row that includes the ID you want in the Ref type column that links it to its parent table, you should be able to just use that column's value. Since it needs to be a list type value, use the LIST function. Try:
LIST([Ref column])
I basically would like to trigger an action on only the row that matches ID with the child row that triggered the event.
The Referenced rows property requires a list of IDs from the Referenced Table. Since the action was triggered from a row that includes the ID you want in the Ref type column that links it to its parent table, you should be able to just use that column's value. Since it needs to be a list type value, use the LIST function. Try:
LIST([Ref column])
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |