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…
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |