# Creating a people directory **URL:** \ **Category:** Ask for Help\ **Created:** [April 6, 2023, 4:17am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204 "2023-04-06T04:17:29Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 6, 2023, 4:17am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/1 "2023-04-06T04:17:29Z")
I’m trying to create a people directory based on a number of categories. I’m importning the data from a google sheet. I’d like to homepage to be a list of categories that can be further drilled down (e.g. Real Estate, Finance, Investing) and then when you click on that tile it takes you to a directory list of people. One you click into a person it should take you to their profile page. Homepage (categories list) → List of people based on category selected → profile page. I’ve got the directory list and details page set up perfectly but can’t for the life of me figure out how to attach the list of people to each respective category. Any guidance is appreciated. ---
**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:** [April 6, 2023, 4:38am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/2 "2023-04-06T04:38:23Z")
What does your data look like? Do you have everything in one big table, or do you have separate tables for Categories and People? Ideally you should have two tables - Categories and People. Your Categories table should be a list of all the unique categories. And your people table should include a Category column that identifies which category each person belongs to. In your Categories table, create a multi-relation column that matches the category with the category name in your people table. On the UI, present a collection that uses your Categories table as a source. The default action on the collection items will be to open a details screen for the selected category. On that screen, add another collection component and set the source to be the multi-relation column. This will show you a list of people belonging to the selected category, and clicking a collection item will take you to the selected person’s details screen. ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 3:40am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/3 "2023-04-07T03:40:56Z")
> [@scoon](#): > > (e.g. Real Estate, Finance, Investing One google sheet with multiple tabs. Tab 1 = categories Tab 2 = real estate people (10 columns including name and 9 other data attributes I want to list in their profile page) Tab 3 = VC people (10 columns including name and 9 other data attributes I want to list in their profile page) Tab 4 = Finance people (10 columns including name and 9 other data attributes I want to list in their profile page) etc. etc. Do I need to use a Glide sheet for this? I got it to nest for one of the tabs but I want to map each category to each people tab and bring in the 9 other data attributes. ---
**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:** [April 7, 2023, 3:58am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/4 "2023-04-07T03:58:23Z")
Are those “9 other data attributes” the same in each case? If they are, I’d suggest combining all of those “People” sheets into a single sheet, and include an extra column that differentiates them - Real Estate, VC, Finance, etc. If you do it this way, you’ll find it much easier to manage in Glide. You’ll only have to build a single details screen, whereas the way you have it now you’ll need to build a separate details screen for every sheet. And then you just take the approach that I described earlier - that is, a multi-relation column in your Categories table that matches the category with the category in your people table. ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 5:26am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/5 "2023-04-07T05:26:20Z")
Ok I now have two sheets and the relations have been correctly mapped. Where I’m stuck now is the UI. Here is how it’s setup: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df0e7650ec49cada2547c967fd46b79a8f661fcb.jpeg) and when I click into the real estate category it shows the people for “investing” ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 5:27am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/6 "2023-04-07T05:27:02Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f42f0b9e6cb4459b1b435696c072af6ef469f42.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:** [April 7, 2023, 5:27am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/7 "2023-04-07T05:27:56Z")
You should be using the relation as the source of your collection, not the Master sheet. ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 5:27am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/8 "2023-04-07T05:27:58Z")
Here’s the data view ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/118f08aab940dcd9238376e1147b06debec95339.jpeg) ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 5:28am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/9 "2023-04-07T05:28:45Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/178cc27a2c648436d633d09946eab6a4d1c8eace.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:** [April 7, 2023, 5:29am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/10 "2023-04-07T05:29:43Z")
👇 > [@Darren\_Murphy](#): > > You should be using the relation as the source of your collection, not the Master sheet. here, below… change that to use the relation that you created (“New Column”): ![CleanShot 2023-04-07 at 13.30.52@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df408657c49b2f63fc6ad185d3343c957035d1cc.jpeg) ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 5:36am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/11 "2023-04-07T05:36:09Z")
Thanks for being patient… it doesn’t allow me to select “new column” ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/525ac6bb457e6a46fe6d8b9e355d96a3d6175c15.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:** [April 7, 2023, 5:38am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/12 "2023-04-07T05:38:46Z")
Are you sure? Scroll all the way to the bottom of the list, below “User Profile”. As long as it’s a multi-relation (and it looks like it is), then it should be there. ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 5:42am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/13 "2023-04-07T05:42:00Z")
Good man! 🙏 ---
**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:** [April 7, 2023, 5:44am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/14 "2023-04-07T05:44:56Z")
So I guess that means you found it? 😉 All good now? Let us know if we can help with anything else. ---
**Author:** ![scoon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scoon/32/57138_2.png) [@scoon](https://community.glideapps.com/u/scoon)\ **Post date:** [April 7, 2023, 5:47am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/15 "2023-04-07T05:47:53Z")
Yes. Thank you! Don’t worry this is just the start 🙂 Now I need to figure out how to incorporate a voting system and filters 🤣 ---
**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:** [April 7, 2023, 5:54am UTC](https://community.glideapps.com/t/creating-a-people-directory/60204/16 "2023-04-07T05:54:41Z")
Check out some of @Robert_Petitto’s tutorials. I believe he has one on each of those topics.