I would love for there to be a way to filter out the options that appear when linking a record. For example, if I have a table for monthly events and a separate table for RSVPs (with a form view to RSVP), I would want to be able to link to an event record to associate that personโs RSVP with that event. But if an event has passed, it will still show up in list of available records to link, both in the grid view and form view. I would love to be able to filter by a checkbox (event completed) or filter by a date field (everything today or in the future).
I would say that this is my most important requested feature. @Katherine_Duh any chance you can let us know if this is on the roadmap โ either linked records from views or conditional/filtered linked records?
Thereโs no way of filtering linking fields in Airtable at the moment - although it has been requested by a lot of us.
Iโd like to add something to the debate - if filtered lists are implemented, the implementation needs to take into account that you would still need to be able to see existing recordsโ values which may be linked to records which are filtered out for new recordsโฆ (I hope this makes sense)
+1 Airtables felt like the perfect solution until I discovered it wasnโt able to filter the values in a linked field or lookup field. Really hoping a solution is added soon.
Iโll add my voice to this request, and also second Julianโs emphasis on being able to retain records which were created with records which have since been made inactive - that would be crucial.
If you sort the default view for the [client] table by {active}, you can at least move all the active clients to the top of the list. (Presumably, you could apply a secondary sort by client name or some other logical order, as well.) Doesnโt protect you from incorrectly linking to an inactive client โ although you can create an error-checking and warning field to watch for and report such an error โ but it does making it less likely, and it avoids the irritation of paging through intermingled active and inactive customers.
+1 Another use case. I have a look-up on an appointments table linked to the service table, The service table contains prices for each service. If I want to change prices of items, I want to be able to set old service prices to inactive and filter them out of the drop down look-up on the appointments table so the wrong services/prices donโt get selected.
Is there a place where we can see the development roadmap?
+1 from me too! I work at a nonprofit and am saving a TON of time by having donors enter information directly into our database. One of the linked fields they choose is โEventโ and Iโd love to not list our old, inactive events in that listโฆ
Curious why this hasnโt been done yet?? Seems like a rather easy feature and would end up saving time and data as less info is passed based on filtering criteriaโฆ
