# Setting values through relations and clearing user-specific columns - recategorized

**URL:** https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111
**Category:** Ask for Help
**Tags:** actions
**Created:** [February 19, 2021, 10:54pm UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111 "2021-02-19T22:54:46Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [February 19, 2021, 10:54pm UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/1 "2021-02-19T22:54:47Z")

</div>

Not a new post. I wanted to give a more appropriate home to a discussion around the use of actions to:

1. Set columns through [single] relations.
2. Clear user-specific values.

> [@Looking for ideas - how to solve 'create new card' button in a Swipe app](https://community.glideapps.com/t/looking-for-ideas-how-to-solve-create-new-card-button-in-a-swipe-app/23092/6):
>
> Hi Jeff - Has this worked consistently for you? I ask because it hasn’t for me. In fact, it stopped working in two of my apps last month. Per Support, use of compound actions for the purpose of clearing USP values following a submission [1] as well as setting columns through relations that are formed as a result of a preceding step in the same compound action [2] is not possible/does not work. Solving this would require significant time and resources according to Glide engineers.

---

<div class="post-metadata">

### 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: [February 20, 2021, 7:29am UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/2 "2021-02-20T07:29:54Z")

</div>

I do really wish that somebody from Glide would weigh in on this, and provide some advice on what can be expected to work and not work. Right now it just feels like we’re bumbling around in the dark, trying to figure it out through trial and error. And seeing inconsistent results, which just makes it all the more frustrating.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [February 20, 2021, 10:53am UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/3 "2021-02-20T10:53:12Z")

</div>

Right!

I have looked for a workaround and even an explanation for months to understand why the Set Columns actions can’t work with a multiple relation??

Glide would be almost “perfect” fixing this missing feature.

Saludos Rasha

---

<div class="post-metadata">

### Author: ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [February 20, 2021, 7:51pm UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/4 "2021-02-20T19:51:26Z")

</div>

True, multiple relations would be very useful @gvalero But I want to emphasize the issue here relates to single relations, which do show up as options for set column actions along with their corresponding columns. Some just don’t work as expected for no clear reason.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [February 20, 2021, 8:01pm UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/5 "2021-02-20T20:01:37Z")

</div>

What kind of problem do you have using a simple relation?

I have used this in several APPs and cases and works well for me. Show me an example to try to duplicate it.

Saludos

---

<div class="post-metadata">

### Author: ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [February 22, 2021, 9:40pm UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/6 "2021-02-22T21:40:26Z")

</div>

bueno @gvalero… I can’t post the app so I’ve tried to isolate the on-submit, set col single relation action in this app. Look for it before you submit a form. It’s grossly simplified in that the data doesn’t truly come from those columns, but the relation in question (rel\_C) does form and live in the same sheet.

> **[SingRelSetColAction](https://cremini-maitake.glideapp.io/)**

I modeled it after [this](https://cremini-maitake.glideapp.io/) exchange with Jeff and Darren.

Let me know where I can shed more light and thanks for offering to take a look! Again, the feedback from Glide is that set column on this type of relation is not feasible. At least that’s what was conveyed to me.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [February 24, 2021, 2:27am UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/7 "2021-02-24T02:27:23Z")

</div>

Hola @Rasha

Tomorrow I will test your problem with more time, I have had 2 days very busy.

No te olvido! 😉

Saludos

---

<div class="post-metadata">

### Author: ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [February 25, 2021, 4:00am UTC](https://community.glideapps.com/t/setting-values-through-relations-and-clearing-user-specific-columns-recategorized/23111/8 "2021-02-25T04:00:18Z")

</div>

**Update:** In one of 3 apps we’re been testing, _some_ values began appearing, mainly the timestamp refreshing as it should via the **set column single relation action** but in the editor only, NOT the sheet. Not sure what to make of that. I can’t reproduce those results in the app I posted here.
