# List Relation "Data" **URL:** \ **Category:** Ask for Help\ **Created:** [April 23, 2020, 1:25am UTC](https://community.glideapps.com/t/list-relation-data/7659 "2020-04-23T01:25:35Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [April 23, 2020, 1:25am UTC](https://community.glideapps.com/t/list-relation-data/7659/1 "2020-04-23T01:25:35Z")
Ok…riddle me this. Why does editing the Data for List Relations do nothing? I’ve always wondered this. ![Glide_·_Create_Apps_from_Google_Sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/824ef764b91e9d4c0dad47527fbeb5546a48c1e3.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:** [April 23, 2020, 2:02am UTC](https://community.glideapps.com/t/list-relation-data/7659/2 "2020-04-23T02:02:18Z")
If you only have 1 item, then I think it might show the other details. It will also take you directly to the details of that 1 item instead of a list. As Glide has said before, it’s one of the original components and hasn’t gotten a whole lot of attention. ---
**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:** [April 23, 2020, 2:06am UTC](https://community.glideapps.com/t/list-relation-data/7659/3 "2020-04-23T02:06:53Z")
Yeah…I mainly use it for accessing an “Archive” of form responses. Would be nice to customize it a bit… Completely unrelated, @Jeff_Hager, you have any tricks up your sleeve about getting the name of the signed in user to appear in a tab that doesn’t house the user profile rows? In my recent chores app, I want to create a form button that says “Assign me this chore” where it will auto pass the signed in user’s name. Im guessing the only way to do this is to pass the user email and then do a look up of the name in the responses? Not the UI i was trying to achieve, though. ---
**Author:** ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)\ **Post date:** [April 23, 2020, 2:45am UTC](https://community.glideapps.com/t/list-relation-data/7659/4 "2020-04-23T02:45:01Z")
I am also eagerly searching a way to display the signed in user’s name. I am just able to filter or do conditional visibility based on User email as signed in user. Want to learn the tricks to display users name as a welcome note. ---
**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:** [April 24, 2020, 5:24pm UTC](https://community.glideapps.com/t/list-relation-data/7659/5 "2020-04-24T17:24:09Z")
BAM! I figured it out. First create an If/Then column on the user profile sheet that fills the column with the word ‘Name’ if signed in user. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/04a9eface0744308c508ceef55035720d8d2dcdd.png) Next, on every sheet you want to display the name: - Create a template column that contains the word ‘Name’. - Create a relation column that joins the name template to the name template in the user profile sheet. - Create a lookup column that gets the name from the relation. - Bonus - make it look pretty. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/df9dca8e3c53797b2fdb09a81b90e290da5c92ed.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0c11c17788a96840ce33ed9d597bb13ca9a26e08.jpeg) ---
**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:** [April 24, 2020, 5:38pm UTC](https://community.glideapps.com/t/list-relation-data/7659/6 "2020-04-24T17:38:00Z")
YOU. ARE. BRILLIANT. New level of relations to templates! AWWWWW YEAH! This might solve my check user balances too because the column would only result in a single value and not an array! SO many more possibilities! ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c4169cebeca67b1786b0512626b62fc60c558c88.gif) ---
**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:** [April 24, 2020, 5:55pm UTC](https://community.glideapps.com/t/list-relation-data/7659/7 "2020-04-24T17:55:45Z")
I won’t take full credit. I remember a post somewhere where someone was using the if/then by signed in user. Definitely something to consider and use more. ---
**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:** [April 24, 2020, 7:26pm UTC](https://community.glideapps.com/t/list-relation-data/7659/8 "2020-04-24T19:26:35Z")
@Jeff_Hager OMG it’s going to work: ![Screen Shot 2020-04-24 at 3.26.04 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/79bb3943765d81fc47902f761cae93ba946dca6a.png) ---
**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:** [April 24, 2020, 7:28pm UTC](https://community.glideapps.com/t/list-relation-data/7659/9 "2020-04-24T19:28:41Z")
With this one little trick I can free up almost 800 rows of formulas. 😱 ---
**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:** [April 24, 2020, 7:54pm UTC](https://community.glideapps.com/t/list-relation-data/7659/10 "2020-04-24T19:54:00Z")
Awesome! By the way, I charge per freed up row. 😉 ---
**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:** [April 24, 2020, 7:57pm UTC](https://community.glideapps.com/t/list-relation-data/7659/11 "2020-04-24T19:57:07Z")
1¢ per row? Deal! …honestly, if you had a donation page, I’d send some appreciation your way. ---
**Author:** ![mrt224](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrt224/32/490_2.png) [@mrt224](https://community.glideapps.com/u/mrt224)\ **Post date:** [April 24, 2020, 8:48pm UTC](https://community.glideapps.com/t/list-relation-data/7659/12 "2020-04-24T20:48:54Z")
I hope I understand what is going on here. Trying to get the signed-in user name. ![Ididit](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/eb3f487c409103da54d4d115c32254413e1f4f68.jpeg) I saw the trick and try it but I did it this way. It only took me one step to get the username Look at pick. ---
**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:** [April 24, 2020, 8:50pm UTC](https://community.glideapps.com/t/list-relation-data/7659/13 "2020-04-24T20:50:03Z")
That works in the current tab, yes. The other solution will let you display the name in ALL OTHER tabs! ---
**Author:** ![George\_Lewis1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_lewis1/32/5517_2.png) [@George\_Lewis1](https://community.glideapps.com/u/George_Lewis1)\ **Post date:** [April 24, 2020, 9:23pm UTC](https://community.glideapps.com/t/list-relation-data/7659/14 "2020-04-24T21:23:31Z")
This is great, I use this trick to show/ hide components based on the type of user they are, i.e. you can also assign a user profile this way and take that over to your other sheets for visibility ---
**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:** [April 24, 2020, 9:39pm UTC](https://community.glideapps.com/t/list-relation-data/7659/15 "2020-04-24T21:39:57Z")
Right…this I’ve done before my relating two template columns together…I’ve just never thought of relating an ifthen to a template like this! ---
**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:** [April 24, 2020, 9:54pm UTC](https://community.glideapps.com/t/list-relation-data/7659/16 "2020-04-24T21:54:31Z")
Ahh yes! It’s @George_Lewis1 that deserves the real credit for this. It was his post that gave my the idea to approach it this way. > [@Conditional visibility of components usage question](https://community.glideapps.com/t/conditional-visibility-of-components-usage-question/1993/14): > > Hey guys, I’m trying to build a two-side marketplace at the moment looking at a few no-code options, but am loving playing in Glide and following all the new releases/ features. Initially I had two apps/ one spreadie, but am now trying to convert to one app, after I realised you can’t comment between them which I was using as a 121 chat function. I’ve had a few goes at this problem you’re talking about and one option seems to be working, but would like to know what you think and if it will sca… ---
**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:** [April 24, 2020, 9:55pm UTC](https://community.glideapps.com/t/list-relation-data/7659/17 "2020-04-24T21:55:27Z")
> [@Robert\_Petitto](#): > > 1¢ per row? Deal! I’ll give you this one this time. It was a team effort. ---
**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:** [April 24, 2020, 10:30pm UTC](https://community.glideapps.com/t/list-relation-data/7659/18 "2020-04-24T22:30:58Z")
@George_Lewis1 👏👏👏 ---
**Author:** ![George\_Lewis1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_lewis1/32/5517_2.png) [@George\_Lewis1](https://community.glideapps.com/u/George_Lewis1)\ **Post date:** [April 24, 2020, 10:44pm UTC](https://community.glideapps.com/t/list-relation-data/7659/19 "2020-04-24T22:44:56Z")
Thanks, pleased to give something back as both of your advice/posts have helped me build the other 90%! ---
**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:** [April 25, 2020, 2:17pm UTC](https://community.glideapps.com/t/list-relation-data/7659/20 "2020-04-25T14:17:27Z")
More testimony about how brilliant this trick is: 1. Only need to create “is signed in user” rel/lookup once in user sheet with keyword and then can relate to that keyword in each tab 2. able to create custom “headers” on each tab. 800+ rows & 20+ relation/lookup columns now boiled down to just 10 columns and 0 (new) rows…zero spreadsheet formulas = instant calculations. ![ScreenFlow](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8a15457900f83adab5795326473928713b012c2a.gif) [Next page](https://community.glideapps.com/t/list-relation-data/7659.md?page=2)