Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Joining Votes from an Array to Linked Records

Topic Labels: Base design
201 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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