# Creating 100% Match

**URL:** <https://community.glideapps.com/t/creating-100-match/21000>\
**Category:** Ask for Help\
**Tags:** actions\
**Created:** [January 11, 2021, 9:13am UTC](https://community.glideapps.com/t/creating-100-match/21000 "2021-01-11T09:13:48Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Franziska\_Spoddig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/franziska_spoddig/32/18756_2.png) [@Franziska\_Spoddig](https://community.glideapps.com/u/Franziska_Spoddig)\
**Post date:** [January 11, 2021, 9:13am UTC](https://community.glideapps.com/t/creating-100-match/21000/1 "2021-01-11T09:13:48Z")

</div>

Dear Glide Community,

I am stuck on the following issue:  
As you can see in the picture I have 10 relations made of specific preferences. 2 users have different opinions. What I would like to do is to have one column where I show in which row one user had all relations. As in the Image, the name “Franzi” should then be shown only in line 3 and 7, for “Alex Müller” it would only be line 6.  
I tried it with If then but it doesn’t work because there is only “is not empty” or “is empty”  
I have also tried not doing a relation and using if then to say if “Preference\_1” is the same as “Preference\_1” in the user tab & “Preference\_2” is the same as “Preference\_2” in the user tab until all preferences are cross checked, but that left me with empty results…

Is it somehow possible to say only when I have the same name in one row all the way through all the relations that to show that name?

 ![Bildschirmfoto 2021-01-11 um 10.06.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fe4c48bba8936be5b5a85788d01dc1b1b1c1d824.png)

---

<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:** [January 11, 2021, 9:50am UTC](https://community.glideapps.com/t/creating-100-match/21000/2 "2021-01-11T09:50:04Z")

</div>

So your condition is when a name that “appears” in a relation 10 times then it should be shown?

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [January 11, 2021, 10:13am UTC](https://community.glideapps.com/t/creating-100-match/21000/3 "2021-01-11T10:13:22Z")

</div>

Are these relations created from the same 2 sheets?

---

<div class="post-metadata">

**Author:** ![Franziska\_Spoddig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/franziska_spoddig/32/18756_2.png) [@Franziska\_Spoddig](https://community.glideapps.com/u/Franziska_Spoddig)\
**Post date:** [January 11, 2021, 11:07am UTC](https://community.glideapps.com/t/creating-100-match/21000/4 "2021-01-11T11:07:08Z")

</div>

exactly!

---

<div class="post-metadata">

**Author:** ![Franziska\_Spoddig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/franziska_spoddig/32/18756_2.png) [@Franziska\_Spoddig](https://community.glideapps.com/u/Franziska_Spoddig)\
**Post date:** [January 11, 2021, 11:07am UTC](https://community.glideapps.com/t/creating-100-match/21000/5 "2021-01-11T11:07:44Z")

</div>

it’s two tabs

I have the person with the preferences on one  
This sheet is where the preferences are matched to the different topics

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [January 11, 2021, 11:28am UTC](https://community.glideapps.com/t/creating-100-match/21000/6 "2021-01-11T11:28:21Z")

</div>

I would recommend that you create a template column on each tab which combines all the preferences in both the tabs.  
Then these template columns will be exactly identical only in the cases where all 10 preferences match.  
Create a relation on top of these template columns in both tabs.  
Hope it makes sense.

---

<div class="post-metadata">

**Author:** ![Franziska\_Spoddig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/franziska_spoddig/32/18756_2.png) [@Franziska\_Spoddig](https://community.glideapps.com/u/Franziska_Spoddig)\
**Post date:** [January 11, 2021, 11:37am UTC](https://community.glideapps.com/t/creating-100-match/21000/7 "2021-01-11T11:37:12Z")

</div>

tried this but the combination doesn’t work, see attachment

 ![Bildschirmfoto 2021-01-11 um 12.36.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/7/e755195b14c8624e08d2c255fb327df7fdba85ad.png)

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [January 11, 2021, 1:50pm UTC](https://community.glideapps.com/t/creating-100-match/21000/8 "2021-01-11T13:50:03Z")

</div>

Not this way,  
Create a template column where you combine all preferences in both the tabs and use those columns to create the relation the way you currently have.

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f78afa0eef62c6fbb5e53d05d390eef97db55168.jpeg "Template Column | Glide Data Editor Tutorial") ](https://www.youtube.com/watch?v=lJ8a0aMU2ds)

---

<div class="post-metadata">

**Author:** ![Franziska\_Spoddig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/franziska_spoddig/32/18756_2.png) [@Franziska\_Spoddig](https://community.glideapps.com/u/Franziska_Spoddig)\
**Post date:** [January 11, 2021, 3:17pm UTC](https://community.glideapps.com/t/creating-100-match/21000/9 "2021-01-11T15:17:43Z")

</div>

I can’t use it just as a word because behind all of these preferences is an object  
this object has a profile which I want to show in an inline list later on
