Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Maximum count of a non-numerical linked value

Topic Labels: Formulas
438 1
Showing results for 
Search instead for 
Did you mean: 

I have an Airtable with 3 tables: a list of readers, a list of books, and a list of genres. The books table has a lookup relationship with both genre and readers. Each book can have multiple genres. I’m trying to display the reader’s favorite genre based on the books they have read.

In other words, of the books the user has read, which genre (or genres in the case of a tie) occur(s) the most number of times?

Here’s how I tried approaching the problem: Make a hidden lookup or rollup field that aggregates all of the genres from the linked books then find the genre that occurs the most number of times. However, I’m not sure how to do that second step.

Is this possible in Airtable? I would appreciate any suggestions! :slightly_smiling_face:

1 Reply 1

I find the easiest way to find the most is to convert relationship counts to numbers, which would mean adding a count field on genre that counts the number of linked books. Then you can either sort by number or write a formula field based on it.