# Once again: Set Column Values with ITE/Lookup/Math values during On Submit Action **URL:** \ **Category:** Ask for Help\ **Created:** [September 6, 2021, 9:56pm UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465 "2021-09-06T21:56:11Z")\ **Posts on this page:** 8\ **Page:** 2
**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:** [September 10, 2021, 11:02pm UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/21 "2021-09-10T23:02:59Z")
Yeah, this is the reason why I always tell people to use screen/user profiles column to do these, or have a hidden entry to write a default value. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [September 11, 2021, 12:40am UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/22 "2021-09-11T00:40:50Z")
The issue I have with that is the sheet I need to set column value is not the destination sheet of the form but another table altogether. @ThinhDinh Do you have a recommendation for my case? If I have to I’ll use Integromat but it’s going to introduce quite a delay. ---
**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:** [September 11, 2021, 12:49am UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/23 "2021-09-11T00:49:25Z")
I would resort to a custom form and just do an add row + set column combo. ---
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [September 11, 2021, 9:29am UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/24 "2021-09-11T09:29:40Z")
If Default Add Form + Set Column stopped work recently(however everyone agrees that it should work), why are you so confident that “Add Row + Set Column” combo will work always? ---
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [September 11, 2021, 10:15am UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/25 "2021-09-11T10:15:17Z")
@ThinhDinh Okay, just created “Add Row + Set Column” approach, and voila, it also doesn’t work. In this test application, I Add Row which uses relation and user hour rates to calculate sum of work. With Set Column I “freeze” calculated value to Basic Column. So it can be accessed in Google Sheets. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b61af4dd14a9e0ef28207675e7a024e8e077120.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47aa9f5925dce8220a24fe8f5ee2b4c5b49332be.png) ---
**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:** [September 11, 2021, 10:46am UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/26 "2021-09-11T10:46:36Z")
What’s your settings here for the whole flow? Eric was asking for a way to set column in a different sheet, not the destination sheet, I see you have “this item” for the set column action and that was not what we were talking about. I was also talking about a custom form with entries writing to user-specific columns, just to be clear, not a normal form. ---
**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\ **Post date:** [September 12, 2021, 5:58am UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/27 "2021-09-12T05:58:44Z")
Yes, I use USC. Maybe you can think of other approach? > **[Set Columns On Submit](https://rainy-night-6528.glideapp.io/)** ---
**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:** [September 12, 2021, 6:14am UTC](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465/28 "2021-09-12T06:14:03Z")
In your custom form, the action attached to the the “Commit” button looks like this: ![Screen Shot 2021-09-12 at 2.05.34 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/8184d040795fc0029dd9c2b0d71f52c637da928a.png) That extra Set Column Values step should not be necessary. That is, you should be able to calculate the “Freezed Sum” amount based on the selected owner, and then set that column together with the previous Add Row step. This is one of the big advantages of using custom forms. It presents the opportunity to pre-calculate additional values and include them with the Add Row action. Here is a copy of your app that demonstrates what I am talking about: > **[Set Columns On Submit](https://end-song-7277.glideapp.io/)** All I did was to create a relation to the users table with the value in the usc/Owner column, and then altered the lookup columns to use this relation. And that allows the “Freezed Sum” to be calculated and included with the Add Row action. [Previous page](https://community.glideapps.com/t/once-again-set-column-values-with-ite-lookup-math-values-during-on-submit-action/31465.md?page=1)