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โฆ
Solved! Go to Solution.
Should be:
SELECT(
rf_design[id],
[asset_id] = [_THISROW].[asset_id])
Should be:
SELECT(
rf_design[id],
[asset_id] = [_THISROW].[asset_id])
Thanks @Steveโฆ That does it exactlyโฆ
survey[asset_id] = [_THISROW].[asset_id]
You are comparing a list to a row, you cant do this,
Thanks @Jonathan_Sโฆ
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |