Existing feature survey - stuck with logic

112
1
08-24-2020 12:31 PM
JoySoulliere
New Contributor II

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

0 Kudos
1 Reply
DougBrowning
MVP Notable Contributor

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.

0 Kudos