'Most Used' Category

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

  1. 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)
  1. 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”
  1. Find the Most Votes Category
  • Create a Query in the Users Table, targetting the Categories table:
    • Sort By: “Total Votes” (Descending).
    • Name: “Top Categories”.
  1. 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