I have a form where branching alone doesn't meet my needs. For instance, if I ask the question "What area does your division fall under?" and the options for answers are North, South, East, and West, the subsequent division names vary depending on the chosen area.
If I select North, I will see division names A, B, C, and D. Upon selecting a division name like 'A', a corresponding field should populate with the assigned division number 'A100'.
Similarly, if I choose South, division names E, F, G, and H will be available. If I select 'E' as my division name, a field should display the assigned division number 'E100'.
Is there a way to link this information to another data source, such as Excel, where an If/Then formula can be utilized to incorporate this logic? Ideally, Forms should accept this linked data, enabling me to avoid creating separate questions for each division name and number on the form.
If I select North, I will see division names A, B, C, and D. Upon selecting a division name like 'A', a corresponding field should populate with the assigned division number 'A100'.
Similarly, if I choose South, division names E, F, G, and H will be available. If I select 'E' as my division name, a field should display the assigned division number 'E100'.
Is there a way to link this information to another data source, such as Excel, where an If/Then formula can be utilized to incorporate this logic? Ideally, Forms should accept this linked data, enabling me to avoid creating separate questions for each division name and number on the form.