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.
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.
Name: New branch in progress (ROW)
Do this: Data: set the values of some columns in this row
Set these columns: [branch_form_trigger] = “New branch in progress”
Name: New branch in progress (ROWS)
Do this: Data: execute an action on set of rows
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?
[_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…