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.