# Set Column Values after Form submit **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [February 22, 2022, 4:53pm UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850 "2022-02-22T16:53:37Z")\ **Posts on this page:** 8\ **Page:** 2
**Author:** ![gbigelowtutordoctor](https://avatars.discourse-cdn.com/v4/letter/g/9e8a1a/32.png) [@gbigelowtutordoctor](https://community.glideapps.com/u/gbigelowtutordoctor)\ **Post date:** [June 28, 2023, 7:42am UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/21 "2023-06-28T07:42:27Z")
I was able to use this discussion to add a submission date and submission ID to row data using Special Values (thanks!!!) when form is submitted following this discussion BUT, I am still unclear in an additional “default” value to add to one column in the new row submitted. I need to set the Status column to a pre-defined value = 1. New Applicant. I thought Set Column On Submit would work but as the discussion states this doesn’t work. How would I set that column value for the current row for new submissions? Or will I need to have the App Script that does some other things on the google sheet on new row adjusted to handle it? ---
**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:** [June 28, 2023, 7:47am UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/22 "2023-06-28T07:47:43Z")
You could create a Template column in your User Profile table that contains the value `1. New Applicant`, and then pass that as a [User Profile Value](https://www.glideapps.com/docs/reference/values/introduction-to-values#user-profile-columns) with your Form submission. > [@gbigelowtutordoctor](#): > > I thought Set Column On Submit would work but as the discussion states this doesn’t work. I wouldn’t say it doesn’t work, it’s more than it can’t be relied on to work consistently. The problem is that there is a bit of a race condition happening. That is, if the Set Column Values action fires before the new row is added, it will fail. ---
**Author:** ![gbigelowtutordoctor](https://avatars.discourse-cdn.com/v4/letter/g/9e8a1a/32.png) [@gbigelowtutordoctor](https://community.glideapps.com/u/gbigelowtutordoctor)\ **Post date:** [June 29, 2023, 12:25am UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/23 "2023-06-29T00:25:36Z")
Works perfectly. Thanks Darren!!! ---
**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:** [June 29, 2023, 12:51am UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/24 "2023-06-29T00:51:17Z")
An alternative is to use a text entry component pointing to your status column, set the default to “1. New Applicant”, and then hide that text entry with a condition that will never be true (i.e “Status is empty”, since that would always be filled with the default value). ---
**Author:** ![variadevang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/variadevang/32/59414_2.png) [@variadevang](https://community.glideapps.com/u/variadevang)\ **Post date:** [January 29, 2024, 11:56am UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/25 "2024-01-29T11:56:48Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2adfc6c8c7d0066a00d16b5ee41a6bbca1e9be11.png) I use this form to create products in the system. When created, the product has a default status of `Active`. I am unable to set column value to `This item` On submit. It creates the row but does NOT set the value for the column Product status as directed in the action in the `On submit` event. I am thoroughly confused. I am hoping there is a better solution in January 2024. ---
**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:** [January 29, 2024, 12:48pm UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/26 "2024-01-29T12:48:00Z")
> [@variadevang](#): > > I am hoping there is a better solution in January 2024. There is. Don’t use an onSubmit action to try and Set Column Values in the row just added. Instead, pass the extra values as “Column Values” with the form. There are several ways to do this. For your use case, one option would be to have a Template column in your User Profile Row with the word “Active”, then pass that as a User Profile value with the form. > **[Column Values | Glide Docs](https://www.glideapps.com/docs/reference/values/column-values#column-values-in-submission-screens)** > > Column values are the values contained in your data source tables. ---
**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:** [January 30, 2024, 12:38am UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/27 "2024-01-30T00:38:57Z")
An alternative is having a text entry column pointing to the status column in the destination table. Have a default value of “Active” for that entry, and then use a conditional visibility for that component that will never be true (say “Status” is empty, because it will always be not empty thanks to your default value). ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 30, 2024, 2:28am UTC](https://community.glideapps.com/t/set-column-values-after-form-submit/38850/28 "2024-01-30T02:28:00Z")
This is why we need the ability to add custom values as special values. Please upvote! [https://community.glideapps.com/t/pass-a-custom-value-when-completing-a-form](https://community.glideapps.com/t/pass-a-custom-value-when-completing-a-form) [Previous page](https://community.glideapps.com/t/set-column-values-after-form-submit/38850.md?page=1)