Would really appreciate some help from any experts in Google Forms.Is there a way to link a Choose from a list style question in a form to a list of data (e.g. in a spreadsheet)?This would mean that as new options were added to the list in the spreadsheet (or wherever else it might be possible to host the list), they would automatically appear as an option to select in the form in the future.In my case it would mean that the respondents filling in the form would be able to select which volunteers were present at that particular volunteering session from the comprehensive list of volunteers (rather than typing in each name individually), but since volunteers join sporadically, it would be hugely helpful if it were possible to add these to the options on the list automatically rather than adding a new option manually each time.I have no idea if this is possible but I would really appreciate it if anyone could suggest a way of doing it. Please let me know if there is anything that is unclear about what I am attempting to do.Thank you.
Is there a way to link a Choose from a list style question in a Google Form to a list of data (e.g. in a spreadsheet)?
google spreadsheets;google apps script;google forms