Limit linked record selection to a view


#101

Same problem here. One table is used to record, say, 4 transactions (one each week for a month) for a vendor. A second table records a single check written for those 4 transactions. When I record the check number, I link to the transactions table, and although searching for the records I want is easy, the list gets cumbersome.

If I could either filter the link or use cntl key to multiple select, I wouldn’t have to search and select 4 times for each check.


#102

Please make this happen!


#103

I would also love to have this feature!


#104

Agreed - this would be a great way of achieving something as simple as filtering out completed tasks linked to an event or project .


#105

You can do this! I believe in you Airtable!


#106

This would be great as well! I don’t currently use airtable(currently with JIRA) but that would really make this powerful as a CRM and PM tool.


#107

+1 Would love to see this feature for project management use case


#108

Absolutely a needed feature. How has it gone so long without being implemented? I would love to use Airtable for more solutions, but without some basic features like this, I can’t.


#109

Hi everyone, I have en employee data base that contains active and departed colleagues, who are marked “alumni”.
On a separate form for current employees I have an expense request form, in which my employees can select their name from a drop down.
Problem is that in that drop down, there are my former employees as well… is there a way to only show a specific subset of my records in a web form ?
Thanks in advance.


#110

There is not currently functionality built in for that, but there is feature that does this currently in beta testing. It allows one to limit the selection of records linked into one table to only those available in a particular view in the source table.

So when this feature goes live, you’ll be able to create a view in your Employees table that filters to show only active employees, and then use that view to filter records in your Expense Request table Form View, so that only Active Employees show up as options.

Based on my past experiences with Airtable’s beta program, I’d guess you can expect to see this feature go live in somewhere around a month. But not all betas are the same, so that’s not a guarantee.


#111

Great!! Signed up and looking forward to testing this one out!


#112

that’s great news
looking at the responses on this thread, this is a qualified need and if it doesn’t make through beta, there will be a lot of disappointed users


#113

It is indeed a long awaited feature.
Does this mean that I can now rollup/count specific records from a certain view (Aka conditional rollup/count)?

This does not seem to be working for me. I have limited my linked records to a specific view, but the rollup is still rolling up values from ALL records, and not from the specific view.


#114

Do we know if this has been worked on at all?


#115

Look at the 4th response above yours:


#116

Thank you for your help Jeremy. Next time, I’ll carefully read through every single comment before asking a dumb question.

Jeremiah Sumner

Facilities Systems Engineer

Sutter Health FM Technology

916-305-0157

SumneJ1@sutterhealth.org


#117

+1 - looking forward to trying it out.