I have a spreadsheet with validation on a range of cells, and I have a dropdown to select choices. When I change the values through Glide, with a valid choice, the value is entered correctly, but the the data no longer validates, and the dropdown isn’t there
1 Like
+1
I’m having the same issue.
Is there any chance you could avoid doing validation in the sheet, and just use a choice component in the app, or is the sheet being modified outside of the app as well?
Yes, the sheet is being modified both inside and outside of the app
I can’t think of a way around this. I’m sure Glide is just overwriting the dropdown with the value that is set in the app.