Would be a useful feature to minimise selection from a linked table’s rows.
Example:
Our business has subcontractors who become active and inactive at different periods, their activeness represented by a checkbox data column.
If they are inactive, they should not be able to be selected when assigning a subcontractor to a service.
There are a couple of threads looking at solutions for this problem, but no updates in a while. Not being able to filter makes airtable far less useful for my use (and more so in forms) and so we have not been able to move over our data to airtable.
I’ve got pretty much the same usecase as discussed above (staff being able to select shifts to work). A filter on the form page would be great. Alternatively a filter on the “Link to another record” field type, so only certain records were available to link.
It would be great if the base creator could in some way limit the fields that were able to have a linked record added to them, either by:
A) Adding filters to the linked record field dropdown
or more realistically
B) Having a dropdown in the field options that limited the View that the linked records have to be chosen from.
For example, imagine I have a base with a table in it called Products. In here are a load of unique products. Imagine that 100 are marked In Stock, and 400 are marked Sold. I have a filter on this view called ‘Available Products’ that filters on just the In Stock products.
Now imagine I have another table called Orders, where I take customer information and link to the desired product record.
If I could limit the linked records to the ‘Available Products’ view of the Products table, it would ensure orders weren’t being put against items that had sold.
I want to only display linked items that have a particular property set on them.
In the embedded base, in the “Tags” table, in the “Products” column, I want to only show those Products that have a “Available” checkbox set to true.
I can create a view that filters to only show “Tags” that are associated with Products where “Available” is true but the listed Products for each Tag are not filtered.
