Joining Votes from an Array to Linked Records

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.