How to create a field that contains only some of the linked records

Topic Labels: Formulas
105 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


In table Courses, I have a "Related Lessons" field that is a link to table Lessons

"Related Lessons" field contains 3 Lessons' records: L1, L2, L3

In table Courses, I want to create a second field, named "Open Related Lessons" that contains 2 linked records only: L1, L2. The remaining L3 records should be excluded based on filters.

--> How to achieve that?

1 Reply 1
8 - Airtable Astronomer
8 - Airtable Astronomer

You can create a lookup field that filters for conditions. There’s a little toggle button underneath the input box where you put the name of the field you’re looking up that says something along the lines of “only look up records based on conditions.” Once you toggle that button on, you can add filter conditions to your lookup.