Hi! I am creating a client dashboard with an external and internal side. I want to be able to create a page in which the admin can choose a client to see their data and it filters their data out. I already have their data linked to the client in my Glide tables but I cannot figure out how to create a filter to show only certain rows by client. Any assistance is appreciated!
Wouldn’t it be easier for you if the admin clicks on the user’s row to view their data?
If you’re aggregating data already on each user’s row, then that would make your building experience much easier.
If your admin has to choose a client, let’s say using a choice component, you would have to do relation(s) & lookups to retrieve the data to be displayed on that same screen.
I guess an alternative for you is still using the choice component, but use a Custom Collection component, filter to the row of the chosen user, and display data on that element.
What do you mean clicking on the user’s row?
I mean you show a list of users and the admin can click on any of them to show a details screen/new screen, where you build your components to see each user’s data.
I think my situation is a little more complicated because I have multiple pages to show multiple types of data. It is already filtered by by each page having a type of data (column) per page but now I want the ability to filter by client (row) on the page.
Then maybe using a query column is your best bet, and use your aggregation column (e.g rollup) around the query.
Perfect, thank you so much for the help! I will look into the query column.
1 Like