How can i cancel changes the data in google sheet immediately without submitting?

Hello Gliders,
i filling in the data grid in the form, it changes the data in google sheet immediately without submitting the form, I want to press summit before the data changes, what should I do?,because it affects edit usage.

A data grid isn’t intended to be used inside a form. A data grid allows a user to change values in several rows in the same screen, whereas a form is intended to add or edit a single row at a time.

To get the behaviour you want, you should use normal entry components (text entry, number entry, date/image pickers, etc) inside your form.

oh i get it I’m very grateful to you for explaining. I’ll have to try different methods.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.