# Update the value of a column in another table

**URL:** <https://community.glideapps.com/t/update-the-value-of-a-column-in-another-table/78190>\
**Category:** Ask for Help\
**Created:** [November 25, 2024, 9:41pm UTC](https://community.glideapps.com/t/update-the-value-of-a-column-in-another-table/78190 "2024-11-25T21:41:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [November 25, 2024, 9:41pm UTC](https://community.glideapps.com/t/update-the-value-of-a-column-in-another-table/78190/1 "2024-11-25T21:41:01Z")

</div>

I have seen this question asked before but I’ve yet to find a how-to-ish explanation for how to actually update values using set columns to another table.

My sitch - i have a series of tables with items in them. A form uses choice components to allow the user the pick which items to include in as a new row in the “orders” table.

This works great but what I can’t do is to decrement the counter in the items table when i submit the row to my orders table.

I have related the items table \<\> orders table. I have lookups which list the item count in the orders table but I can’t CHANGE the value using a set column action since the only tables I can access are THIS ITEM and the user profile table.

I imagine other Gliders have ran into this so if there is a tutorial or other step by step way to do this I’d appreciate any help.

Thanks!

---

<div class="post-metadata">

**Author:** ![Atom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atom/32/82126_2.png) [@Atom](https://community.glideapps.com/u/Atom)\
**Post date:** [November 25, 2024, 10:42pm UTC](https://community.glideapps.com/t/update-the-value-of-a-column-in-another-table/78190/2 "2024-11-25T22:42:06Z")

</div>

If you’re looking to setup a checkout system, I highly recommend watching @Robert_Petitto’s video on the trebuchet method: [https://www.youtube.com/watch?v=1QbKTccN850&t=2459s](https://www.youtube.com/watch?v=1QbKTccN850&t=2459s)

---

<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:** [November 25, 2024, 11:20pm UTC](https://community.glideapps.com/t/update-the-value-of-a-column-in-another-table/78190/3 "2024-11-25T23:20:48Z")

</div>

> [@Need to change a value of one table to another table](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/9):
>
> Jeff - i deleted the action I was previously using and created it from scratch and and it is working. I have seen this behavior in Glide before so I start over and things seem to work better. I have specified a negative increment value -1 but i noticed it add to the count. Hey - I’ll take the win but wanted to confirm that i can increment negative values? THANKS

Is this problem solved for you here?

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [November 26, 2024, 2:22am UTC](https://community.glideapps.com/t/update-the-value-of-a-column-in-another-table/78190/4 "2024-11-26T02:22:55Z")

</div>

Everything looks good. I’m officially recognizing you and Jeff when I give thanks on Thursday