Is it possible to have the validation to a text answer automatically update dependant on a column in Google sheets to match any items in that column only.
Please rephrase your question. I do not understand what you want.
I have the app set up at the moment to scan items in and out however in google sheets I have a list of which bar codes are allowed to leave.
what I would like is for the validation to automatically update depending on what qr codes are in the sheet.
It is not possible for an AppSheet app to update a spreadsheetโs data validation settings. Consider moving the validation logic into the app itself.
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |