How do you select the only available option as default?

83
3
07-31-2019 08:51 AM
Highlighted
New Contributor II

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.

Tags (2)
Reply
0 Kudos
3 Replies
Highlighted
Frequent Contributor II

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.

Reply
0 Kudos
Highlighted
New Contributor II

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?

Reply
0 Kudos
Highlighted
Frequent Contributor II

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.

Reply
0 Kudos