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.
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
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.
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.