I’ve been working on an extensive reading log on Airtable and I’ve gotten quite a bit of it figured out. I different “tables” in the same base for different years. I have certain line items as linked records (such as author name, genre, rating) on each of those linked records tables I am basically just doing yearly tallies right now. So basically how many books read for each author per year and then a total count field that adds up all the years to give most read authors, for example.
What I’d like to do is have more information added to the sorting capability and I can’t figure out how to make that happen. So for example instead of just counting total books read per year for that author (or genre etc) I’d like to add another field of information. Like say how many books per author and then sort per genre or rating. Basically to have the information of what do I generally rate books by a certain author or in a certain genre for example.
Any ideas on how to accomplish this or what fields I need to add would be greatly appreciated!