The community member is trying to set up a dropdown of classes stored in a Google Sheet to register students linked to a specific class. They encountered an issue where the data stored in the column they tried to extract was not showing up. A community member suggested setting the appropriate column to extract into a variable, and then using this variable in a Buttons input with the Dynamic items property, which they said is a better experience than a dropdown. The community member confirmed that this solution worked for them.
To register students linked to a specific class, i need to provide a dropdown of classes stored in Google Sheet; the student can them select the right class, which will then link the answers to the corresponding teacher. I tried to setup the Google Sheet integration with Get Data, but the data stored in the column to extract is not showing up... Is this possible, or am i making a wrong setup ? Thanks !
Set the appropriate column to extract into a variable. Then you can use this variable in a Buttons input with the Dynamic items property. It's a better experience than a dropdown
