Is possible filter linked records?

[Jose_Martinez1]

Greeting ! Attached image explain the question, Thank for your support.

[WilliamPorter]

Ad-hoc or on-the-fly filtering of the records shown in that listing isn’t possible, but you CAN control what’s shown there. Create a view in the linked table that filters records the way you want. Then back in the parent record, click the option Limit record selection to a view and select the filtered view.

I suggest, over in the linked record table, making a note in the description of the view to remind yourself that this view is used in that way (so you don’t delete it later by accident thinking it’s not important).

[Williams_Innova]

I’ve also done something similar with a separate table, having only 1 record in that table, that I link to all my records that I want filtered. In this case, the 1 record would link to the table feeding Items Contrato. Then, I set conditions that work for me, like records that meet a certain criteria. The downside to the method is you would need to set up an additional criteria, either a filter on/off switch or a time based criteria so your filter is only looking at the last modified record. I would attach screenshots but there would be a lot. If interested, I can walk you through it.

Chris

[Jose_Martinez1]

Thanks a lot, but this is a partial solutions, the view must change every time that I make a order from other contract. Greetings.

[Jose_Martinez1]

Thanks a lot, is an interesting solution, I understand it, but it don’t work with differents contracts on at same time.

[ScottWorld]

Yeah, sadly, as @WilliamPorterTech mentioned in his first post above, dynamic filtering of links is a gigantic missing feature from Airtable.

You can send an email to support@airtable.com to request this feature, but in all the years I’ve worked with Airtable, I have never seen them implement a single customer feature request unless it comes from one of their largest enterprise customers.

There is a workaround to do what you want to do, but it’s pretty complicated and it has several limitations:

Conditional Logic-ish Linked Records Show and tell

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. [Condition…