Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Linked records that match all conditions?

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

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 :slightly_smiling_face:

J

0 Replies 0