Linked records that match all conditions?

Hi there

AirTable newbie trying to work out how achieve something. Scenario:

I have a table of Video Clips from different countries and containing different languages.

I have a table of footage Loggers that will review the clips and be assigned based on the languages they speak.

In the Video Clip table, I wanted to display a list of Loggers that speak that clips language. To that end I created a Languages table, linked both the Video Clip and Logger tables and using a look up field can now see the names of suitable loggers. I can then just their name into the Logger field in the Video Clip and consider them assigned. Brilliant.

EXCEPT

If a clip features multiple languages (ie English and Spanish), my lookup field displays all the loggers that speak English or Spanish. NOT loggers that speak English & Spanish (which would be the best solution).

Is there a solution to this? I can’t see an obvious way of using the conditional Lookup or Roll Up fields to achieve what I’m after.

Thanks :slight_smile:

J

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