Expression for Referenced Rows range

[Jake_Naude]

Hi,

I have an action in my rf_design table called: UPDATE ROW (in rf_design table).
It works as expected and pops a name into the rf_design table column [cabinet_assigned_to]

I then have an action in the survey table called: UPDATE SET OF ROWS (in rf_design table)
I have this action here because this is where I run my Grouped: execute a sequence of actions — EXECUTE ON SAVE of survey form.

I’m having difficulty with the Reference Rows expression

I think what I need is something like get list of rf_design[id] where the rf_design[asset_id] is the same as survey[asset_id]…?

Thanks in advance…

[Steve · Accepted solution]

Should be:

SELECT(
rf_design[id],
[asset_id] = [_THISROW].[asset_id])

[Jake_Naude]

Thanks @Steve… That does it exactly…

[Jonathan_S]

survey[asset_id] = [_THISROW].[asset_id]

You are comparing a list to a row, you cant do this,

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Jake_Naude]

Thanks @Jonathan_S…