Joining Votes from an Array to Linked Records

Topic Labels: Base design
572 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

Screen Shot 2021-01-19 at 7.15.41 PM

0 Replies 0