I have a table that has columns Book names, a Genres lookup, and a third column containing an array of votes for each genre in that same order as the Genres lookup. I’m having trouble conceptualizing how I will search for something like “Show me Books with “Business” genre tag voted on over 150 times”.
Tried already (new to Airtable):
- Looking for a formula that will let me index to a position in the vote array such that I can concatenate it with the genre
- Thinking of a third table that will join the two. Just can’t wrap my mind around how that will work, being new at this.