# Relation bug? **URL:** \ **Category:** Ask for Help\ **Created:** [July 20, 2020, 2:44pm UTC](https://community.glideapps.com/t/relation-bug/12829 "2020-07-20T14:44:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 20, 2020, 2:44pm UTC](https://community.glideapps.com/t/relation-bug/12829/1 "2020-07-20T14:44:31Z")
Hello guyz ! There is something i should miss in relation function… 😭 I made two templates : email - color and email- marbe in a same tab. It is exactly the same expresion but i doesn’t match 😓 → [br.lataste@gmail.com](mailto:br.lataste@gmail.com) - Blue ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4e8ec585d30faa0e344c9dfab8dc7492ba203c71.gif) ---
**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:** [July 20, 2020, 2:52pm UTC](https://community.glideapps.com/t/relation-bug/12829/2 "2020-07-20T14:52:14Z")
What are your settings for the “Rel email” and the lookup? ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 20, 2020, 2:59pm UTC](https://community.glideapps.com/t/relation-bug/12829/3 "2020-07-20T14:59:27Z")
> [@ThinhDinh](#): > > email” and the lookup? 🙂 here : ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d85b1279a5d983937c4c6147347db70f032a546e.gif) ---
**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:** [July 20, 2020, 3:07pm UTC](https://community.glideapps.com/t/relation-bug/12829/4 "2020-07-20T15:07:00Z")
Because it will only match the first row where there is a match, isn’t? ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 20, 2020, 3:13pm UTC](https://community.glideapps.com/t/relation-bug/12829/5 "2020-07-20T15:13:44Z")
If you’re talking about relation multiple, it doesn’t work either… ☹ ---
**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:** [July 20, 2020, 3:15pm UTC](https://community.glideapps.com/t/relation-bug/12829/6 "2020-07-20T15:15:02Z")
Yeah but can I know more about your specific use case here? ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 20, 2020, 3:19pm UTC](https://community.glideapps.com/t/relation-bug/12829/7 "2020-07-20T15:19:49Z")
Ok, so, In my **Leaderboard** tab, people choose a color marble In my **Marble color** tab, it is all the color possible with the current user email. I make a template in a **Leaderboard** tab and template in **Marble color** tab, For every matchs, it means the color is not available anymore. ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e7e758026a265d60f415f0bcc0c2ec86f17b40fd.gif) ---
**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:** [July 20, 2020, 3:44pm UTC](https://community.glideapps.com/t/relation-bug/12829/8 "2020-07-20T15:44:07Z")
So following your example, I set it up like this. - Marble choices. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/01765d92b3bb2a7f0ec6cedac046f602f0176b5f.png) - Marble submit. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d91d7d0de1da031eee0fb0912144dacdaa253b9c.png) - The choice in the form. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/66ce4cd7b975ff5b780b34c356f0acac720e6ec4.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cf27bf6f39e67aea50ec4231658b28031c837347.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1b50b36cece9d2e3f5c90757e6319c0752e8e4d9.png) ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 20, 2020, 4:00pm UTC](https://community.glideapps.com/t/relation-bug/12829/9 "2020-07-20T16:00:01Z")
[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/01765d92b3bb2a7f0ec6cedac046f602f0176b5f.png) ](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/01765d92b3bb2a7f0ec6cedac046f602f0176b5f.png) My problem is here. Why i don’t have any relation match? [https://far-silk-9227.glideapp.io/](https://far-silk-9227.glideapp.io/) ---
**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:** [July 20, 2020, 4:14pm UTC](https://community.glideapps.com/t/relation-bug/12829/10 "2020-07-20T16:14:09Z")
Can you check if you have any spaces in one of the two template columns? ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 20, 2020, 4:17pm UTC](https://community.glideapps.com/t/relation-bug/12829/11 "2020-07-20T16:17:29Z")
OMG 🤣 It was that indeed Thank so much ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 20, 2020, 5:50pm UTC](https://community.glideapps.com/t/relation-bug/12829/12 "2020-07-20T17:50:35Z")
Hey again ThinDinh, Maybe you can help me on something else. 😇 I am trying to have limited choice per race. Everytime someone joins race, he has to choose a color (limited list), and if the color was taken by another user, the color doesn’t show up in a list. **They join race before to select the color** , then i can offer a right list of color. In that way i can collect template like : race 1 - blue race 2 - green race 3 - blue race 1 - red … etc I just need to be sure to don’t have the same combination… But i don’t know how 🤣 ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8b5ec2a12e47b578a61d5292b8fc7d75e650f864.gif) I hope it was clear, and If you have any idea, it would be awesome ! 😀 ---
**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:** [July 20, 2020, 11:44pm UTC](https://community.glideapps.com/t/relation-bug/12829/13 "2020-07-20T23:44:21Z")
Same idea as what we have done, but this time join the league ID/invite code and the color. If the relation between the two sheets show something then use the filter to take that choice out as I have shown with the screenshots. ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 21, 2020, 8:14am UTC](https://community.glideapps.com/t/relation-bug/12829/14 "2020-07-21T08:14:31Z")
Yes totally agree, but in our previous example we use the **current user email** as dynamic data. Here we need something like **current race / ID race** as dynamic data. If i follow you, we would need to make a template like : **current race** **- color** The color list is limited list, but the **current race** is unlimited list, and user can have like 2 or 3 races in a same time… ☹ You can’t make a template with that : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b4ac680484f3de42ca5b29706f550874815d3219.png) I tried here : ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0535e0f6749d3d79ed31af26d3ac8aa314817139.gif) ---
**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:** [July 21, 2020, 8:19am UTC](https://community.glideapps.com/t/relation-bug/12829/15 "2020-07-21T08:19:37Z")
I would advise you to do it in a separate sheet, where you store the user email and the races in different rows, I think you have one like that already to store the registration information right? ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 21, 2020, 8:23am UTC](https://community.glideapps.com/t/relation-bug/12829/16 "2020-07-21T08:23:51Z")
> [@ThinhDinh](#): > > ser email and the race Here is my configuration : - User profil tab : profil stuff - Leaderboard tab : race / email / - Color tab : List of colors ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b2db0b4ef185732d14afb7b5bba1144ef0ce4a14.gif) ---
**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:** [July 21, 2020, 8:24am UTC](https://community.glideapps.com/t/relation-bug/12829/17 "2020-07-21T08:24:55Z")
So do it in the Leaderboard tab, combining the league invite code and the color chosen. ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 21, 2020, 9:24am UTC](https://community.glideapps.com/t/relation-bug/12829/18 "2020-07-21T09:24:09Z")
I use race name instead of code race : I did in **leaderboard tab** , my problem is to make the template in **marble colo tab** ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0cacb0d78ab8932e7e97074748f5c6cbdbbd941a.gif) ---
**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:** [July 21, 2020, 9:32am UTC](https://community.glideapps.com/t/relation-bug/12829/19 "2020-07-21T09:32:19Z")
What is your current flow for the user to submit a new color, do they submit via a form after they have gone into a details page for a league? ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 23, 2020, 12:23pm UTC](https://community.glideapps.com/t/relation-bug/12829/20 "2020-07-23T12:23:29Z")
I finaly did it 🕶 Thanks ThinhDinh