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

**URL:** <https://community.glideapps.com/t/how-can-i-cancel-changes-the-data-in-google-sheet-immediately-without-submitting/64648>\
**Category:** Ask for Help\
**Created:** [August 3, 2023, 6:25am UTC](https://community.glideapps.com/t/how-can-i-cancel-changes-the-data-in-google-sheet-immediately-without-submitting/64648 "2023-08-03T06:25:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AIC\_Appliaction](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aic_appliaction/32/62075_2.png) [@AIC\_Appliaction](https://community.glideapps.com/u/AIC_Appliaction)\
**Post date:** [August 3, 2023, 6:25am UTC](https://community.glideapps.com/t/how-can-i-cancel-changes-the-data-in-google-sheet-immediately-without-submitting/64648/1 "2023-08-03T06:25:28Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 3, 2023, 6:35am UTC](https://community.glideapps.com/t/how-can-i-cancel-changes-the-data-in-google-sheet-immediately-without-submitting/64648/2 "2023-08-03T06:35:24Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![AIC\_Appliaction](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aic_appliaction/32/62075_2.png) [@AIC\_Appliaction](https://community.glideapps.com/u/AIC_Appliaction)\
**Post date:** [August 3, 2023, 6:42am UTC](https://community.glideapps.com/t/how-can-i-cancel-changes-the-data-in-google-sheet-immediately-without-submitting/64648/3 "2023-08-03T06:42:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 10, 2023, 6:43am UTC](https://community.glideapps.com/t/how-can-i-cancel-changes-the-data-in-google-sheet-immediately-without-submitting/64648/4 "2023-08-10T06:43:08Z")

</div>

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