# Show Ratings/Reviews in a second location on app **URL:** \ **Category:** Ask for Help\ **Created:** [July 17, 2023, 2:21am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988 "2023-07-17T02:21:14Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 2:21am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/1 "2023-07-17T02:21:14Z")
My salon profiles have team members listed: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3b8856cd3e159932cf314ee37b89f86a98eab2b.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/584d820b942b9c02d38e3a61152a9585c1a38e68.jpeg) If a team member gets a review, it only shows up on their profile: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c36076fc1885f9c336c37de0dd0123fb3e84be9.jpeg) However, I want it to additionally show up on the salon profile as long as they are working there. I have a column that relates the stylist to the salon they work at: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/254d904b60b872a369cf1ac8e58b0573d307b192.jpeg) but I can’t seem to figure out how create the relation so that I make an inline list for stylist reviews at the salon. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97d00a94c4e7fff7d4bef3013f666bf99fbd1635.jpeg) I can’t get anything to connect to the ‘stylist works at’ lookup column, but I also can’t seem to figure out how to convert the text in the lookup column to something that can be recognized. Any help? ---
**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 17, 2023, 2:37am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/2 "2023-07-17T02:37:22Z")
Your lookup column is returning an array, that’s why you can use it how you want to. I suspect that you have a multiple relation where you should have a single relation. Presumably a stylist only works at one Salon? Check your relation from Stylist to Salons in your Reviews table, and make sure it’s a single relation. ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 2:44am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/3 "2023-07-17T02:44:34Z")
Looks they are only singles, did i check the right ones? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/6194df5e4091714e48319ab2bf192d4b485d5d32.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c1bc0b6cc184cfa7f06efc203faa53fa00935c5.png) ---
**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 17, 2023, 2:48am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/4 "2023-07-17T02:48:17Z")
Yes, both of those look fine. And then I see you have the “Works at [name]” column, which is returning the Salon Name. Can you not use that? ie. Add a list to your Salons details screen that uses the Reviews table as a source, and then use that Salon name lookup as a filter? ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 2:54am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/5 "2023-07-17T02:54:09Z")
Let me try that. My other one was done with a relation and these were all the options it was providing me so i was trying to create the same thing as the other one. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec2283105e438d9e5cfe8cbce5064745cfe9fbce.jpeg) ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 2:57am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/6 "2023-07-17T02:57:34Z")
This is all it’s letting me do: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc89993c427245dab779257b040def0548e0e60a.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/beb3b57f675747a3d0eb541f70aba9369c839205.png) ---
**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 17, 2023, 3:00am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/7 "2023-07-17T03:00:55Z")
No no, that’s not what I meant. I meant to use the Salon Name as the filter. So “Salon Name IS Works at [Name]” ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 3:09am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/8 "2023-07-17T03:09:29Z")
OK so my problem there - is that in the reviews table, the salon columns are only returning the salon name when the reviews are actually left for the salon and _not_ the stylist ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/edee08ebc70a5ac1b433205129c0b6913d640537.jpeg) ---
**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 17, 2023, 3:16am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/9 "2023-07-17T03:16:59Z")
Okay, now you have me confused 🤪 This… > [@Katelyn\_Alberts](#): > > when the reviews are actually left for the salon and _not_ the stylist Seems to conflict with this… > [@Katelyn\_Alberts](#): > > If a team member gets a review, Let me study your screenshots a bit more ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 3:20am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/10 "2023-07-17T03:20:23Z")
LOL! The salon columns are only populated for the salon reviews The stylists columns are only populated for the stylist reviews I was trying to bridge the gap with the lookup column (you’ll see the "works in’ salons are filled in, in reverse of the salon column) but then that lookup column isn’t letting me do anything lol ---
**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 17, 2023, 3:36am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/11 "2023-07-17T03:36:18Z")
oh, right - so it could be either/or… duh 🤦‍♂️ Okay, so in that case could you not use both in the filter with an OR condition? So something like: - Reviewee Salon IS Salon Name – OR - Works at [Name] IS Salon Name ? 🤔 ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 3:47am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/12 "2023-07-17T03:47:12Z")
So the ‘reviewee salon’ column is out because that’s only showing up for salon reviews (which I’ve got covered in my original inline list) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3fa6a3fab086703e1c8f6d9c6863067f29f80370.png) If it’s a stylist review, reviewee salon is blank (ie. a review for breanna carr, will show nothing on the reviewee salon column, bc the review isn’t for the salon) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9ce41721ff6e5c87e515033b47ba07987b15d047.jpeg) And the “stylist works at” one won’t return anything I can use: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b213641703f3e9b6ba8313e29c905c39ba5f3c5.png) Why do i make everything so complicated? 😅 ---
**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 17, 2023, 3:57am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/13 "2023-07-17T03:57:16Z")
oh, now I see. I was looking at that “Works at [name]” column thinking it was in your Reviews table. But it’s in your Professionals table (which I guess is your Stylists table?) Anyway, you need to get that value into your Reviews table. You should be able to bring it in as a Lookup through that Stylists relation, I believe. And then use _that_ value in the filter. hmm, maybe that’s what that “Stylists works at” column is supposed to be? Can you show me the configuration of that Lookup column? ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 4:01am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/14 "2023-07-17T04:01:33Z")
Yes! I’m deriving it from my professionals (stylist) table: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/506793c5ccdcf64dfe98a3835aea51e50c6afdff.jpeg) I was trying to use the lookup column as the means to bring that connection IN to the reviews table from the professionals table, is that not right? ---
**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 17, 2023, 4:06am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/15 "2023-07-17T04:06:46Z")
HAH! I see it… You’re selecting the wrong column in the Lookup. See below - the one I’ve pointed to is the one you should select. ![CleanShot 2023-07-17 at 12.05.03@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/58b26b3ee6c438430b16a37a8d15213787ecc931.jpeg) ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [July 17, 2023, 4:08am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/16 "2023-07-17T04:08:53Z")
Halleluiah! SEND ME THE BILL!!! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 18, 2023, 4:09am UTC](https://community.glideapps.com/t/show-ratings-reviews-in-a-second-location-on-app/63988/17 "2023-07-18T04:09:03Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.