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.
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.
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)
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.
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.