Expression for Referenced Rows range

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… :slight_smile:

image

Should be:

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

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

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

2 Likes

Thanks @Jonathan_S:slight_smile:

2 Likes

Thanks @Steve… That does it exactly… :+1:

2 Likes