# Make a relation column with user favorites

**URL:** https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964
**Category:** Ask for Help
**Created:** [October 9, 2020, 6:21pm UTC](https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964 "2020-10-09T18:21:09Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)
#### Post date: [October 9, 2020, 6:21pm UTC](https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964/1 "2020-10-09T18:21:09Z")

</div>

it’s surely a no-brainer , but …

I can’t find a way to set a relation column in “Users” sheet which relate the favorite “Events” of every “User”.

🥺

---

<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: [October 9, 2020, 10:46pm UTC](https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964/2 "2020-10-09T22:46:52Z")

</div>

It is a user-specific column so we don’t have a way to do that now.

---

<div class="post-metadata">

### Author: ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)
#### Post date: [November 16, 2020, 3:04pm UTC](https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964/3 "2020-11-16T15:04:48Z")

</div>

unfortunately

---

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [September 2, 2022, 7:10pm UTC](https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964/4 "2022-09-02T19:10:29Z")

</div>

It will be great to have a solution for this in the future …I’ve stumbled upon this also wanting to create a list with all the favorite items without putting them in separate inline lists. I can select the field but it doesn’t display anything.

Hopefully there will be a fix for this moving forward …it’s not a must have, but for sure it’s nice to have it.

---

<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: [September 3, 2022, 2:00am UTC](https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964/5 "2022-09-03T02:00:15Z")

</div>

So you want to combine rows from different tables into one inline list of “favorites”?

---

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [September 3, 2022, 9:32am UTC](https://community.glideapps.com/t/make-a-relation-column-with-user-favorites/16964/6 "2022-09-03T09:32:48Z")

</div>

Yes … and I know there is a little challenge there because they could have different columns.  
Right now I was able to add the favorite items in another cell by creating in each table that has favorites another if-then-else column that adds the value 1 if the row has favorite checked.  
In the table that I add them, I’ve created a column that has the value 1 and after that I’ve created the relation columns checking the 1 in the table I want to have all the favorite items with the 1 in each table from where I want to grab the favorite items.  
I now have a table with the columns that contain the favorite items for each table, but I can’t merge them into one column in order to display them in one list.

Hope this makes sense.

Now, the problem I can see here is the difference between columns in each table when selecting in the list what to be displayed … so, I’m figuring something like this could work:

- The columns that will be displayed in the list selection will be only the columns that have the same column name and type in order to have the same data
- when clicking on each item, it will automatically display the detail screen for that item … so here, it shouldn’t be a problem

Now, why I need this is because from a user UX point of view, when you have multiple lists , you don’t want to go to each list to see what you’ve marked as favorite and also, if those lists have a location you may want to see them all inside a map.
