# Databuilder: bug to display relation? **URL:** \ **Category:** Ask for Help\ **Created:** [August 31, 2020, 9:51pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031 "2020-08-31T21:51:48Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 9:51pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/1 "2020-08-31T21:51:48Z")
Hi @Mark, one of my Relation (col. 6) is not displaying the usual suspect caracters (xy25gzd73slknf0 -like), even if the Lookup behind (col. 7) works correctly. It’s a relation between a grade (col 5, template column) and a list of grades (1 to 5). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/ffc83e7e40b40958d43a290d1be1db9a8a18f9d0.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 31, 2020, 9:55pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/2 "2020-08-31T21:55:50Z")
What’s in the first column of the related sheet…as visible in the glide data editor? ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 9:58pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/3 "2020-08-31T21:58:20Z")
This is the column I am relating to. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4a74ce4830e91a53c74dca46636d02160554e22c.png) nb: since the Lookup works, this (potential) bug is not an issue for me, it’s just for information nb bis: hum … I think that you may say that it is due to the fact that the column it relates to is a formatted as “number” and not “text” … If yes, I won’t change it! (I don’t even remember to how much fields this ‘grade’ column is linked to…) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 31, 2020, 10:00pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/4 "2020-08-31T22:00:02Z")
I’m not asking which column you are relating to…I’m asking what the very first column is in the sheet you are relating to. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 10:01pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/5 "2020-08-31T22:01:13Z")
Erratum, I think I get what you mean: the 1st column in the original sheet (the one I am relating to) is … empty… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/061cbd05e62026274b1f8a493b368908c63c28ef.png) … Still & Always learning! Thanks @Jeff_Hager ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 31, 2020, 10:09pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/6 "2020-08-31T22:09:17Z")
The point I’m getting at is that a relation will (or always has in past) show the value of the very first column in the sheet you are relating to. Purely as an indicator that it found a matching row. What you are showing is a unique I’d as opposed to a row id, so I’m a little confused there, but I just want to clarify that it will not necessarily show the value you are relating to. Only the first column of the related sheet. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 10:11pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/7 "2020-08-31T22:11:33Z")
Yes I got it with my [Edit] picture which is the one you were asking for (the ‘Row Id’ picture was not what you were asking, my mistake, I delete it) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 31, 2020, 10:12pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/8 "2020-08-31T22:12:54Z")
Is it getting the unique I’d from the next available filled column? Curious now. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 10:18pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/9 "2020-08-31T22:18:31Z")
Not sure of the question, but as a summary: - sheet1: list of standard grades (1 to 5), but with the first column of the sheet being empty (cf. above col. name “Ungroup …”) - sheet2: relation to this list of grades, which functionnaly works but does not display anything (my original picture and below) So if I understand well your question, the answer is no, it doesn’t take the next available filled column, it takes the very first one… which is empty, and this is probably the reason why the display result in my relation is ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/da4e9465caaa6316a41d181828ac49ccaa000ac9.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 31, 2020, 10:40pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/10 "2020-08-31T22:40:48Z")
Ahh, ok. Now I understand. I was looking at the relation in the first column of the image in your first post (which happens to have a unique ID in it). I completely missed the relation in the second to right column of that same image. Sorry about that. But yes, the relation looks empty because of the empty column value. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 10:43pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/11 "2020-08-31T22:43:29Z")
I should have only put the last 2 columns in my first picture, but I wanted to show-off with my maths columns & so on now that I know how to do a + b 🙂 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 31, 2020, 10:44pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/12 "2020-08-31T22:44:46Z")
Hehe, I can totally understand that! We all like to show and tell a little bit. 😉 ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 10:51pm UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/13 "2020-08-31T22:51:52Z")
Incidentally, this picture is also because I wanted to re-use it to have my ‘rating component’ approach challenged with @Robert_Petitto regarding its ‘star wars’ approach (with its 1 space, 2 spaces etc): mine **seems** simpler … and it worries me a lot!!! Good evening ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 1, 2020, 3:05am UTC](https://community.glideapps.com/t/databuilder-bug-to-display-relation/15031/14 "2020-09-01T03:05:20Z")
Now that the Rating component can be added to a form, I no longer do my custom rating choice component. So much simpler.