I have a “link to table” field, and I want to only show a list of records that match a condition or field. Airtable has this functionality. Can this be accomplished with Baserow. NOTE: I am not talking about filtering records in a view, I am only talking about filtering records that are available to be selected in the “link to table” popup.
This is very important for speed reasons. Otherwise, the user will have to search through large amounts of records and filter manually through the full list to find records that match a specific field value.
Air table has this feature:
https://support.airtable.com/docs/dynamic-filtering-in-linked-record-fields
Hi @nocodegrant, I ran some tests, and even though it’s not exactly like Airtable, it’s possible to do this with Baserow. I tried to follow the example you posted, and here’s how I set it up:
-
I created both tables: the Header table and the Details table.
-
In the Header table, I added a Single select field with the values Yes and No.
-
Then, I created a View in the Header table with the filter I wanted to apply when linking records. Following your example, I set up a View that filters for records where a Single select field is not empty. (If I understood your example, you want users to be able to link only when there’s a Skill selected.)
-
When I created the Link field in the Details table, I selected the option “Limit selection to View” and chose the filtered View I mentioned in the previous step.
-
Now, when I link a record from the Details table, it only shows records that match the filter.
I hope this is what you were looking for
