# Updates and Edit Screen

**URL:** <https://community.glideapps.com/t/updates-and-edit-screen/68198>\
**Category:** Ask for Help\
**Created:** [November 28, 2023, 3:04pm UTC](https://community.glideapps.com/t/updates-and-edit-screen/68198 "2023-11-28T15:04:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [November 28, 2023, 3:04pm UTC](https://community.glideapps.com/t/updates-and-edit-screen/68198/1 "2023-11-28T15:04:08Z")

</div>

When does an Edit screen use an “Update” per Glide? (e.g. Show Edit screen)

For example, if I have a table/row with a boolean that is toggled on and off during the edit process but the action is “Cancel” rather than ‘Submit’…did this toggle cause an update per Glide?

I assume that only Submits causes an Update via ‘Set Col Value’-liek action but I can be wrong.

Thanks

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 28, 2023, 3:23pm UTC](https://community.glideapps.com/t/updates-and-edit-screen/68198/2 "2023-11-28T15:23:14Z")

</div>

An Edit form will only trigger an update when you submit the form because that is the only time that the data is sent to the database in Glide’s server.

> [@MattLB](#):
>
> assume that only Submits causes an Update via ‘Set Col Value’-liek action but I can be wrong.

Are you using a Set Column Value action On Submit of the Edit form???

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [November 29, 2023, 12:35am UTC](https://community.glideapps.com/t/updates-and-edit-screen/68198/3 "2023-11-29T00:35:51Z")

</div>

Am not using a Set Col Value - leaving that up to Glide.

But…I do NOT want a user to be able to edit all of the row information since the object goes through multiple stages. In stage 1, they have a choice of 2 types of edits. Based on their choice, they have a choice of 2 other edit stages.

For example, if they close the event - they can not edit any other fields. If they follow-up on the event they can convert it into a marketing activity OR a sales activity. If they choose sales activity they have to close it out - either win/lose.

I currently do this by setting an EDIT FLAG (which is User Specific - does that entail another update?) before calling Show Edit which hides/shows the appropriate options based on this FLAG to limit the choices. There is only one Show Edit screen per table and that is why I hide/show options so I can re-use the submit/cancel capability of Glide Edit for each “type” of update.

I have been testing different ways to do this (limiting editable items based on the current state) without setting the Edit Flag to save 2 writes (when I set it and when I clear it). Yes, I can save one “update” by just not clearing it.

Unfortunately a user has 2 choices and if they accidentally select one Edit path and than change their mind and select the alternative path; both will be updated since I do not know how to selectively clear a field in a Show Edit screen. In this example they can accidentally close the event before going back (before Submit) and correcting the mistake by entering the follow-up date. However, both close and follow-up dates/events will be updated in the record upon submit since there is no way to programmatically clean up the accidental close date entry.

Long-winded response…I have it working with a big Show Edit screen and the Edit flag.
