Expression to select Referenced Rows for "Data: execute an action on set of rows"

Evening all,

We’re looking at an XY Map View of one of the four orange rows in the survey table below.

The two assets in [branch_A_asset_list] are about to be used in a new survey form.

A Surevyor clicks bottom-right ‘+’ icon which calls a LINKTOFORM action to start a new survey form.

LINKTOFORM(
“survey_Form”,
“floorplans_id”, [floorplans_id],
“lcs”, [lcs],
“location”, [location],
“plan_code”, [floorplans_id].[plan_code],
“survey_type”, [survey_type],
“select_cabinet_to_survey”, [select_cabinet_to_survey],
“select_asset_type”, [select_asset_type],
“asset_name”, [branch_A_assets],
“survey_branch_number”, [branch_A_number],
“branch_A_decision”, “No”,
“room_sid”, [room_sid],
“room_name”, [room_name],
)

I’d like to use the [survey_number] from the LINKTOFORM action and carry it over into an expression to identify the orange rows (for this example) to use as the Ref Rows range for Action 2 below which I’ll trigger with an existing OnSave action.

Action 1 feeds Action 2.

Action 1
Name: New branch in progress (ROW)
Table: survey
Do this: Data: set the values of some columns in this row
Set these columns: [branch_form_trigger] = “New branch in progress”

Action 2
Name: New branch in progress (ROWS)
Table: survey
Do this: Data: execute an action on set of rows
Table: survey
Ref Rows: (need some help with this expression)
Ref Action: New branch in progress (ROW)

The four orange rows all belong to the same survey (SS3-N123) and I’d like to update [branch_form_trigger] to “New branch in progress” in all four rows when the new survey is saved.

I’m using this expression in action 2 Ref Rows Range but it returns the wrong result. It returns “New branch in progress” for the new row(s) that I create and not for the orange highlighted rows.

I don’t know how to carry over the [survey_number] from the LINKTOFORM action to use in this expression?

SELECT(
survey[survey_number],
AND(
[_THISROW].[lcs] = [lcs],
[_THISROW].[select_cabinet_to_survey] = [select_cabinet_to_survey],
[_THISROW].[select_asset_type] = [select_asset_type],
[_THISROW].[survey_number] = [survey_number],
)
)

Many thanks in advance… :slightly_smiling_face: