# On Submit not working as expected

**URL:** <https://community.glideapps.com/t/on-submit-not-working-as-expected/73692>\
**Category:** Ask for Help\
**Created:** [May 27, 2024, 2:43pm UTC](https://community.glideapps.com/t/on-submit-not-working-as-expected/73692 "2024-05-27T14:43:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathan\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathan_m/32/43901_2.png) [@Nathan\_M](https://community.glideapps.com/u/Nathan_M)\
**Post date:** [May 27, 2024, 2:43pm UTC](https://community.glideapps.com/t/on-submit-not-working-as-expected/73692/1 "2024-05-27T14:43:29Z")

</div>

Hey guys,

I’m taking some inspiration from a free prebuilt app for this functionality, I need to “set column value” but its not working on my table.

The only difference that I can see from my version to the free one is that I’m using Gsheets, is that causing an issue?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20b96edaae80ffde8154a4e659fe0faf8ef7fa4a.jpeg)

Any ideas?

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [May 27, 2024, 2:54pm UTC](https://community.glideapps.com/t/on-submit-not-working-as-expected/73692/2 "2024-05-27T14:54:42Z")

</div>

Yes, the free plan does not support using G. Sheet as a data source now.

---

<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:** [May 27, 2024, 3:53pm UTC](https://community.glideapps.com/t/on-submit-not-working-as-expected/73692/3 "2024-05-27T15:53:00Z")

</div>

I usually avoid using On Submit, especially for something like this. The newly added row may not fully exist yet when the Set Column action tries to run. I always set values like that using one of the Columns Value, Special Value, or User Profile components. There’s also a trick where you can add an entry component, set the default value, and then hide it with a visibility condition.

---

<div class="post-metadata">

**Author:** ![Nathan\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathan_m/32/43901_2.png) [@Nathan\_M](https://community.glideapps.com/u/Nathan_M)\
**Post date:** [May 27, 2024, 6:42pm UTC](https://community.glideapps.com/t/on-submit-not-working-as-expected/73692/4 "2024-05-27T18:42:23Z")

</div>

Amazing thanks Jeff, I used your " entry component, set the default value, and then hide it with a visibility condition" trick and it worked a treat!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 28, 2024, 12:27am UTC](https://community.glideapps.com/t/on-submit-not-working-as-expected/73692/5 "2024-05-28T00:27:34Z")

</div>

Make sure you don’t put those defaults in a container and hide the container though. I had issues trying it that way like 2 months ago, ended up having individual visibility for each component.

---

<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:** [June 4, 2024, 12:27am UTC](https://community.glideapps.com/t/on-submit-not-working-as-expected/73692/6 "2024-06-04T00:27:52Z")

</div>

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