How to load data from an excel sheet and make populate options for a survey?

14 Views Asked by At

I wanted to create a tool to collect follow-up data from people. I have a dataset with over 10,000 entries, each collected by one of 200 data collectors. There are over 10,000 individuals in total. In the tool, I need a drop down to select a data collector's names. Then, based on that selection, display the individuals they interviewed in another dropdown. Finally, after selecting an individual, show the data they provided in subsequent dropdowns. I have tried this with google sheets.

0

There are 0 best solutions below