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
Jun 22, 2020 05:27 PM
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:
Jul 24, 2021 09:37 PM
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.