Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help with filtering linked records

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

Hi! I’ve been wrapping my head around this problem for a few weeks already with no solution, so I thought I could try to get some help from you here :slightly_smiling_face:

Here’s my problem:

  • I have two tables: Videos and Tags. Every video can have multiple tags, thus linking the records from the two tables.
  • On Videos I have 2 views: one is “All”, where I have all videos users submitted, and the other is “Filtered”, where I apply some filters to determine what are the videos I want to show on my app - for example, I only show videos with ratings above 4 stars.
  • On the Tags table I’d like to calculate some metrics on number of videos from each tag, but ONLY considering the “Filtered” videos, NOT all of them.

I thought the Limit record selection to a view would do the trick, it really seemed to. However in this Community I found out it doesn’t filter dynamically the linked records, but only the options to be shown on an eventual dropdown in a Form.

Does anyone have any idea on how to solve it?
Seems pretty simple, but I’m not being able to see how.

Thank you!

0 Replies 0