# After submit action not working as expected

**URL:** <https://community.glideapps.com/t/after-submit-action-not-working-as-expected/63150>\
**Category:** Ask for Help\
**Created:** [June 26, 2023, 6:15am UTC](https://community.glideapps.com/t/after-submit-action-not-working-as-expected/63150 "2023-06-26T06:15:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\
**Post date:** [June 26, 2023, 6:15am UTC](https://community.glideapps.com/t/after-submit-action-not-working-as-expected/63150/1 "2023-06-26T06:15:54Z")

</div>

I have an **after submit action** designed like so:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/04537063177251edadb32b66ded153cc1c141015.png)

The **set column values** steps set a column to A or B.

Here’s what I see:  
Glide **client** app data source (Excel) shows value A for 3 x test records:

 ![Screenshot 2023-06-26 at 4.13.46 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f644887be9423c4c37bed64a82af1f66a7bb5bd8.png)

Glide **admin** glide app using same data source shows value A or no value set:

 ![Screenshot 2023-06-26 at 4.13.56 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f10e7b297cd3370b1f5dde21387074a12b34983e.png)

Again, these apps use the same data source.

---

<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:** [June 26, 2023, 10:00am UTC](https://community.glideapps.com/t/after-submit-action-not-working-as-expected/63150/2 "2023-06-26T10:00:54Z")

</div>

Is the column a user specific column by any chance? Can you show the data, and show the set column action?

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [June 26, 2023, 11:20am UTC](https://community.glideapps.com/t/after-submit-action-not-working-as-expected/63150/3 "2023-06-26T11:20:54Z")

</div>

You might or might not be aware, but in one of your screenshots you seem to have an in-app filter with a selection.

---

<div class="post-metadata">

**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\
**Post date:** [June 26, 2023, 8:31pm UTC](https://community.glideapps.com/t/after-submit-action-not-working-as-expected/63150/4 "2023-06-26T20:31:42Z")

</div>

Correct.

The list of records should be the same in both apps. Because (which I’ve now determined) the “on submit form” action essentially doesn’t work with an Excel data source because of timing issues, the columns that require data from the action aren’t populated, therefore only one record is being displayed in that screenshot.

The filter should display all three (where status = exceeds budget).

---

<div class="post-metadata">

**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\
**Post date:** [June 26, 2023, 8:38pm UTC](https://community.glideapps.com/t/after-submit-action-not-working-as-expected/63150/5 "2023-06-26T20:38:13Z")

</div>

No.

What happens is I use an action (shown above) to update some cols for the record I just created when submitting the form.

As has been pointed out, Glide tries to do the update and create the record at roughly the same time. Syncing with Excel is often a problem for Glide (not necessarily Glide’s fault). The create record then update cols is too much for the sync to handle. May or may not be true for other data source types.

In my case, the record is created in Glide’s cache, synced back to Excel, but then because of timing and sync issues, column updates performed by the action are shown in Glide but soon disappear. This behaviour is common when syncing to Excel it seems.

Anyways, I’m using form fields that are hidden with visibility conditions to work around this. All good.

In terms of showing you the data, I can get screenshots that I’ve posted in slack. But the issue I’m describing is about timing. So at point in time 1 the record is shown as hoped, at point 2 it disappears. At point 3 it is back but without the updates from the action.

Glide

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/334a6900b51aac7e50ef238ad2449deab6462604.png)

The Excel file 10 mins later

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f683abc92352868dc6a8edec42d35d25dce9641.png)  
(There are no entries in the status column, but there were some shown in Glide minutes before)

The Excel data is then synced back to the Glide cache and those columns are then empty in Glide.
