Hello, I have an app that takes information from various inspection forms and presents them in a dashboard. My client asked if I can include a ‘Most Used’ category for each table. So I need the app to automatically display the category with the most votes. I have attached a picture of one of the tables. Any help is greatly appeciated.
Are these votes stored in Glide?
I would suggest a Categories table. (Categories are stored in their own table, e.g., “Position of people,” “PPE”)
- Link Inspections to Categories
- In your Categories Table, add a Relation column pointing to your Inspections Table, using whatever is the value linking the two together (ideally IDs, but it might be the category name in your case)
- Count Category Votes
- In your Categories Table, create a Rollup column:
- Relation: Select the relation above.
- Aggregate:
Count
on rowID/Categories column. - Name: “Total Votes”
- Find the Most Votes Category
- Create a Query in the Users Table, targetting the Categories table:
- Sort By: “Total Votes” (Descending).
- Name: “Top Categories”.
- Display the result with a single value column targetting the query above, getting back the first category name.
1 Like
Yes they are all stored in Glide