Evening All,
In my survey table > survey view > survey_Form I have two expressions that enable the branch number ‘buttons’ to show the most recent pin position & background base image for each branch. I can move an existing pin here or drop a new pin - no problem.
The issue:
If I browse to a new floor plan and drop a new pin, the survey_Form remembers the XY position and image from my expression and does not show the new background image for the new floor plan where I dropped the new pin.
This short clip may help?
I think the problem lies in my expression which is not accounting for the new floor plan background image or pin location details?
.
Initial Value formula for column [position] (XY)
IFS(
CONTEXT("View") <> "survey_Form",
"50, 50",
AND(
CONTEXT("View") = "survey_Form",
[survey_type] = "Node"
),
LOOKUP(
MAX(
SELECT(
survey[_ROWNUMBER],
AND(
[_THISROW].[select_asset_type] = [select_asset_type],
[_THISROW].[asset_name] = [asset_name],
[surveyor_email] = USEREMAIL(),
[survey_type] = "Node"
))),
"survey","_ROWNUMBER","position"
),
AND(
CONTEXT("View") = "survey_Form",
[survey_type] = "Cable",
IN(
[survey_branch_number],
[survey_branch_numbers]
)),
LOOKUP(
MAX(
SELECT(
survey[_ROWNUMBER],
AND(
[_THISROW].[survey_branch_number] = [survey_branch_number],
[surveyor_email] = USEREMAIL(),
[survey_type] = "Cable"
))),
"survey","_ROWNUMBER","position"
)
)
BaseImage (Text) expression for Background image for the XY coordinates:
IFS(
CONTEXT("View") <> "survey_Form",
[floorplans_id].[Floorplan_URL],
AND(
CONTEXT("View") = "survey_Form",
[survey_type] = "Node"
),
LOOKUP(
MAX(
SELECT(
survey[_ROWNUMBER],
AND(
[_THISROW].[select_asset_type] = [select_asset_type],
[_THISROW].[asset_name] = [asset_name],
[surveyor_email] = USEREMAIL(),
[survey_type] = "Node"
))),
"survey","_ROWNUMBER","custom_url"
),
AND(
CONTEXT("View") = "survey_Form",
[survey_type] = "Cable",
IN(
[survey_branch_number],
[survey_branch_numbers]
)),
LOOKUP(
MAX(
SELECT(
survey[_ROWNUMBER],
AND(
[_THISROW].[survey_branch_number] = [survey_branch_number],
[surveyor_email] = USEREMAIL(),
[survey_type] = "Cable"
))),
"survey","_ROWNUMBER","custom_url"
)
)
.
I forgot to mention that “custom_url” used in the above lookup is a VC that calls the background image URL using… [floorplans_id].[Floorplan_URL]
Thanks…
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |