In my survey there is a section called "Optimizer Band". Based on the previous selections (Asset Code, District, and Location), there is only one option to choose. How can I make that auto populated, similar to a default? Keep in mind this number could be from 1-5, pending the Location selected. We need it shown in the reports after the surveys are submitted; otherwise I know it's silly to have a section in a survey where you can only choose from one thing. Thanks for your time.
Attached is my xls form.
Rereading your post maybe you actually want a lookup? So if they pick A,B,C then return 1, if they pick A,B,E return a 2, etc?
If so then you can use pulldata for that.
Not sure where you are going with this OB=${OB} but you cannot calc a field from itself.
So when I tried that, I put in OB=${OB} and it 'broke' the survey. I had to take it out and it loaded as it would before. Clearly that isn't the right 'code' to put into the calculation column.... is there a simpler trick to that?
Use calculation column instead. Works just like default since the user can still overwrite it. Default only loads when the form loads - so after your values change - which it is too late.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
