# Display Computed Field on a Details Page **URL:** \ **Category:** Ask for Help\ **Created:** [July 11, 2023, 5:57am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755 "2023-07-11T05:57:23Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 11, 2023, 5:57am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/1 "2023-07-11T05:57:23Z")
I have built a user table where I assign team membership to a player. I have a Team table that contains team name, motto, image. I added a computed field (Team Members) to the Team table to collect all players in the user table with that team associated. This all works fine, but when I click on a team for details, I can’t figure out how to get the Team Members field to display the names of the team members (preferable as links to their profiles). I’m just getting started with Glide, and I am feeling the crunch as school is approaching because I want to gamify my honors course of 9th graders right away with the support of the app I am building Robert Petitto’s 1st lesson on YouTube. Please help! Thanks so much. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 11, 2023, 6:03am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/2 "2023-07-11T06:03:03Z")
You probably just need a relation column in your teams table that links back to Users. Can you show me a screen shot of both tables (from the Glide Data Editor)? ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 11, 2023, 7:27pm UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/3 "2023-07-11T19:27:13Z")
I figured that part out today, but they still don’t show as an option on the detail screen. I want to understand this relationship business before I get much further in. The GUI looks different than the tutorials that were made 1-2 years ago, so that is making things a little harder. ![Screenshot 2023-07-11 at 3.26.14 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0c025e947ca81efe936a007001209db8e9669c8.jpeg) ![Screenshot 2023-07-11 at 3.25.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a4e14d90e083b069914e8f6ce070285235ff4db.png) ![Screenshot 2023-07-11 at 3.25.34 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/947b721829200d843efd2f9cab748e0b02227066.png) Thanks for caring!! ---
**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:** [July 11, 2023, 7:54pm UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/4 "2023-07-11T19:54:29Z")
You can add add collection to the team detail screen and set the source as the relation. ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 11, 2023, 8:07pm UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/5 "2023-07-11T20:07:22Z")
How do I add that? I only see “Title” with no place to add. I think I must be misunderstanding something. ---
**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:** [July 11, 2023, 8:43pm UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/6 "2023-07-11T20:43:41Z")
You add components to the screen via the lower left panel. Then you can select that component and configure on right hand panel. ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 11, 2023, 9:11pm UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/7 "2023-07-11T21:11:17Z")
Oooo. I see that now. Duh. My only problem is that I want to add rel\_Crew Members field, but it isn’t available down there yet. It is in the table but not showing. ---
**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:** [July 11, 2023, 9:35pm UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/8 "2023-07-11T21:35:48Z")
It looks like you have rel\_Crew Members set up as a multiple relation, which is good. Can you show a screenshot of what you see in the dropdown? ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 1:05am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/9 "2023-07-12T01:05:12Z")
I figured it out! Next issue is with trying to do math in my users tab: (current XP / user’s rank XP MAX [from lookup]) \*100 ![Screenshot 2023-07-11 at 9.01.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e622a90e30ab2c0b511d281f1f2305298cd04b6.png) But the lookup does not appear as an option when defining the math column: ![Screenshot 2023-07-11 at 9.03.57 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/04abd1dfd917d53b6c6565e704bbaf656cad30b4.png) If I could pick that lookup column, then I could get the right answer. On the video tutorial I am following it was there, so I must have missed a step. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 12, 2023, 1:12am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/10 "2023-07-12T01:12:19Z")
The Lookup is returning an array, which is why it can’t be used. Where does it come from? If it’s a relation, you need to make it a single relation. If it’s a query, you need to use a single value instead of a lookup. ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 2:52am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/11 "2023-07-12T02:52:40Z")
OK, I am really confused now. I have a Ranks Table: ![Screenshot 2023-07-11 at 10.29.58 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/4970521802493a66f0bd0e6f02d11ce73c2eaa8e.jpeg) The user’s initial Rank comes from an if/then/else field that checks user XP than manually assigns the rank “word”. I somehow related the Rank Name field in the Rank table to it and can get the correct rank image back to the User table. I just can’t get the other fields (XP Upper Limit, for example) to link back without returning many of the values. What do you need to see to get the info you need? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 12, 2023, 2:54am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/12 "2023-07-12T02:54:51Z")
Check the configuration of your relation column. If the “match multiple” box is checked, uncheck it. ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 2:57am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/13 "2023-07-12T02:57:37Z")
Does each table have to have an index field? ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 2:59am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/14 "2023-07-12T02:59:46Z")
maybe this will help: when I create a rel\_Rank Name in my Users that links to Ranks: Rank Name, it returns an image instead of a name, even though the Ranks: Rank Name field is text ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 12, 2023, 3:03am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/15 "2023-07-12T03:03:10Z")
That’s fine. Did you check the relation configuration? Can you show me a screenshot of that? ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 3:04am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/16 "2023-07-12T03:04:04Z")
Relation doesn’t work because the Users table doesn’t have the xp range rules columns. When I use Lookup, it returns the entire column, telling me it doesn’t know which row to look at. ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 3:05am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/17 "2023-07-12T03:05:05Z")
![Screenshot 2023-07-11 at 11.04.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a465102ff867c3254b59f7e0a52fc67fccf77c74.png) ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 3:07am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/18 "2023-07-12T03:07:47Z")
If I try to create a Ranks: rel\_Rank Name field pointing back to Users: Rank Name, I get either 1 or all users that have that rank returned, so I renamed that one Ranks: rel\_Rank Owners (which is useful in the layouts). ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 12, 2023, 3:11am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/19 "2023-07-12T03:11:16Z")
I think you just need a query column with a single value. Have a watch of Bobs video below. He covers how to do rankings with a query column. > [@magnet The QUERY Column: One Column to Rule Them All!](https://community.glideapps.com/t/the-query-column-one-column-to-rule-them-all/61532): > > wave Hey fellow Gliders! mechanical_arm Glide just got even more powerful by introducing the QUERY column! No more complex, multi-column setup to achieve conditional relations. The Query column can: point_right Filter point_right Sort AND point_right Limit related data in ONE COLUMN Learn more: [[Glide 101: Query Column Replaces DOZENS of Computed Columns] ](https://www.youtube.com/watch?v=2K3KzgbrXT8) (sorry my replies are a little terse, I’m away from my computer) ---
**Author:** ![Todd\_Callen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_callen/32/61512_2.png) [@Todd\_Callen](https://community.glideapps.com/u/Todd_Callen)\ **Post date:** [July 12, 2023, 3:31am UTC](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755/20 "2023-07-12T03:31:00Z")
So if I am understanding the video, I need to dump the if/then/else definition column in the Users table and just worry about keeping track of XP. Since I have the Rank Table already created, I don’t even need relations; I can just query the Rank Table from the User Table with a min/max this-row filter? [Next page](https://community.glideapps.com/t/display-computed-field-on-a-details-page/63755.md?page=2)