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

284 0
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

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.