I’m looking to check the validity of a value entered in a form field.
The field can only take a limited possibilities of values, all stored in a Google Sheets colum. The list of values can dynamically evolve over the time (ie values can be added/removed from this colum).
I want to make sure that the value entered in the field belongs to the list of values possible:
- If the value belongs to the list of values stored in my Google Sheets colum, then the form can ben sent
- Otherwise, an error message appears
Has anyone made a similar script before?
Any help is appreciated