Existing feature survey - stuck with logic

JoySoulliere — Mon, 24 Aug 2020 19:31:46 GMT

Using a Survey with an existing feature dataset that is being displayed in a dashboard. The end users are able to update their project status. If project status is not 'Complete' they will be asked some questions.

Workflow example:

current year is set to 2020 and status is 'In Progress'

user is asked if their project will carryover into 2021

if Yes - modify date to 2021

Issue:

When I select my project (now 2021) I no longer want to see any of the modify date type questions.

The problem is I keep getting an error with the logic which I assume is because I am calculating the work plan year based on a yes/no question so I can't use that same value to hide fields.

Basically I want to be able to ask the questions if the work_plan_year = 2020 and the status != 'Complete' and then if the workplancarryover = 'Yes' update the work_plan_year to be '2021'.

It seems simple enough but I am stuck.

Thanks,

Joy

Re: Existing feature survey - stuck with logic

DougBrowning — Mon, 24 Aug 2020 20:08:58 GMT

Trick here is to create another field that holds the final result. Then you can calc if(workplancarryover, 2021, 2020).

You can set the esri bind column to null so that the other field is not stored to make it cleaner.

Hope that makes sense.

topic Re: Existing feature survey - stuck with logic in ArcGIS Survey123 Questions

Existing feature survey - stuck with logic

Re: Existing feature survey - stuck with logic