Show Ratings/Reviews in a second location on app

[Katelyn_Alberts]

My salon profiles have team members listed:

If a team member gets a review, it only shows up on their profile:

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:

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.

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?

[Darren_Murphy]

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.

[Katelyn_Alberts]

Looks they are only singles, did i check the right ones?

[Darren_Murphy]

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?

[Katelyn_Alberts]

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.

[Katelyn_Alberts]

This is all it’s letting me do:

[Darren_Murphy]

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]”

[Katelyn_Alberts]

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

[Darren_Murphy]

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

[Katelyn_Alberts]

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

[Darren_Murphy]

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

?

[Katelyn_Alberts]

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)

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)

And the “stylist works at” one won’t return anything I can use:

Why do i make everything so complicated?

[Darren_Murphy]

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?

[Katelyn_Alberts]

Yes! I’m deriving it from my professionals (stylist) table:

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?

[Darren_Murphy]

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.

[Katelyn_Alberts]

Halleluiah! SEND ME THE BILL!!!