# Lookup of followers **URL:** \ **Category:** Ask for Help\ **Created:** [May 24, 2020, 11:02am UTC](https://community.glideapps.com/t/lookup-of-followers/9674 "2020-05-24T11:02:58Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)\ **Post date:** [May 24, 2020, 11:02am UTC](https://community.glideapps.com/t/lookup-of-followers/9674/1 "2020-05-24T11:02:58Z")
Hi Everyone! I’m trying to get all the followers of users who uploaded reviews on a location. Is it possible? Can you please help me find a workaround if not? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/51a49a93532c3489b317f73ddce20425d4b19418.png) Thanks! ---
**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:** [May 24, 2020, 12:08pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/2 "2020-05-24T12:08:50Z")
Sounds like you simply need to create a multiple relation column in the locations sheet linking the location in the location sheet to the location in the reviews sheet. Then, create an inline list in the locations sheet to display the users that submitted reviews for the location. ---
**Author:** ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)\ **Post date:** [May 24, 2020, 12:37pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/3 "2020-05-24T12:37:45Z")
I don’t think that solves my problem. Maybe I’m mistaken. I have no problem getting the users of all the reviews in the locations sheet. But when I’m trying to get with Lookup the **followers emails** of all of those users, I don’t have this option in the lookup field edit. I need those to have a filter on Locations by Sign in user to check if the sign in user is among the followers of one of users who reviewed the location. Thank you for trying to help! @Robert_Petitto ---
**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:** [May 24, 2020, 2:06pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/4 "2020-05-24T14:06:49Z")
Can you take a screenshot of the reviews sheet for me? ---
**Author:** ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)\ **Post date:** [May 24, 2020, 2:39pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/5 "2020-05-24T14:39:37Z")
![Reviews sheet 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/352c6e0a9097587973fcfc59835898480e1b0bbd.png) ![Reviews sheet 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/96a4211a0e7cabacbfc7e5c1bdec699692035fb8.png) ![Reviews sheet 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/46dfd54a457ff04bfb21fc6e8ecfa892fa99264e.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:** [May 25, 2020, 9:30pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/6 "2020-05-25T21:30:26Z")
The screenshots didn’t help me much since everything was blurred out and it was hard for me to mentally map how everything was related. I think I’m also missing how the followers are attached to users. But if I understand what I think you are asking, you essentially want to create an array of all followers from all users who have written reviews for a location. You can easily create the relation from Locations to Reviews, do a lookup of User name, then create a relation from the lookup to the User’s sheet. I think where you run into the problem…and I’ve seen this before…is that you cannot create a lookup that creates an array of arrays together. I posted about this situation awhile back while helping somebody else, but it never evolved into anything beyond that. Maybe this would be a case for a feature request. > [@Lookup against an array of column](https://community.glideapps.com/t/lookup-against-an-array-of-column/3352): > > I’m not sure if this is a bug, but I have a sheet with 2 email columns ‘Email 1’ and ‘Email 2’. I am attempting to create a relation column within the same sheet that links the Email array to the same Email array. I know this seems weird, but I’m doing this to pull back a relation of all rows that contain at least one of the two emails. The relation appears to be working just fine. What I want to do is then create a Lookup column against the relation that pulls back every email, from the Ema… As an alternative, maybe you could try to think backwards and create your relation from the users to the reviews sheet, then a lookup to get the location and then create a direct relation from location to users. Again, I think I’m missing something to completely picture this. Also, kind of mentally out of it today. Also take a look at this to create a default value to use for a relation only when the signed in user is following a user who review a location. I think you could set it up so an if/then colum will only be filled, possibly with the signed in user’s email, when the signed in user’s email is found in the follower’s array (might need a template of signed in user’s email, to a relation in the followers array, to an if/then column that checks if the relation is empty or not and returns user email). Then you could use your original thought or some of the ideas I presented to build your email array on the locations sheet, but it would only contain the signed in user’s email for the relavant locations they can see. > [@List Relation "Data"](https://community.glideapps.com/t/list-relation-data/7659/5): > > 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. 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] [image] ---
**Author:** ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)\ **Post date:** [May 26, 2020, 6:13pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/9 "2020-05-26T18:13:05Z")
Thank you Jeff! It worked! 1. First I created a If-Then-Else column in the reviews sheet that will have the user’s email in case Users followers is signed-in user. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f61bad88b63588624495b1fd8cb0e4381be36db2.png) 1. Then I made a relation between the Location and all of its reviews in the Location sheet and added a lookup for the column I created in the Reviews sheet that I mentioned in the last paragraph. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/30cec7e406516a1615221355347888f8eedab4c1.png) 1. Then because it was an array, I had to find a way to convert it to a column with one value of the signed in user’s email, so I created rollup column to count the number of emails and creted another If-Then-Else column to check if the number is grater than 0 and if so to put the signed in user email address: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/760432cfe0c35a27a5c6670e97ef0d29f34f718b.png) 1. I used this final column to filter the inline Location list! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/97c59dfefed7c96457384fb791d3a4a6c13beff9.png) Thank you again @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:** [May 30, 2020, 3:14pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/10 "2020-05-30T15:14:25Z")
Awesome! I’m glad you made sense of what I wrote. I admit it probably wasn’t clear and wasn’t really a solution. Sometime you just have to think outside the box and think backwards to find the right solution.