Hi, I am creating a form where users can select a module from single select box 1, I would like the contents of single select box 2 to only display the corresponding options as stored in my GoogleSheets document.
- I have 2 single select boxes.
- I have a table stored in GoogleSheets that contains two columns: Module and Learning Content.
- The first select box has the options mapped to the module column, users can only select one module.
Please can you support me with how I ca condition the single select box 2 in order to only include the options in learning content that are mapped to the selected Module in single select box 1.
Thank you