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
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.