# In action Set Column Values, can I set the value from another table?

**URL:** <https://community.glideapps.com/t/in-action-set-column-values-can-i-set-the-value-from-another-table/38450>\
**Category:** Ask for Help\
**Created:** [February 13, 2022, 4:38pm UTC](https://community.glideapps.com/t/in-action-set-column-values-can-i-set-the-value-from-another-table/38450 "2022-02-13T16:38:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [February 13, 2022, 4:38pm UTC](https://community.glideapps.com/t/in-action-set-column-values-can-i-set-the-value-from-another-table/38450/1 "2022-02-13T16:38:21Z")

</div>

The case is, I want to setup column Discount in User table to be filled with value Amount from Promo table. I found that there is “Set Column Values” action, but it seems like I can’t easily found a way to get the value from any table…

… is there a workaround for this?

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [February 13, 2022, 4:51pm UTC](https://community.glideapps.com/t/in-action-set-column-values-can-i-set-the-value-from-another-table/38450/2 "2022-02-13T16:51:03Z")

</div>

Hi Eko,

If I’m correct you need a single relation column.

Read here

> [@rocket Set Column Action: Alter a DIFFERENT SHEET'S VALUES!](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342):
>
> heart_eyesNot only can you use the new “Set Column” action to edit a value within your sheet via button press, but now you can manipulate values in OTHER SHEETS as long as there’s a relation! This is SUPER powerful. In my demonstration below, I take an inline list of four items and turn them into buttons that can be used to track habits in a DIFFERENT SHEET that’s associated to the currently signed in user!

Thank you

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 13, 2022, 5:40pm UTC](https://community.glideapps.com/t/in-action-set-column-values-can-i-set-the-value-from-another-table/38450/3 "2022-02-13T17:40:21Z")

</div>

You may need to “create” a relation in order to get to your User Profile table. Here’s a thread that helps explain how: [Need "Set Column \> User Profile \>" without template/relationToUser](https://community.glideapps.com/t/need-set-column-user-profile-without-template-relationtouser/34131)