Conditional Linked Records

1001 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am testing a simple base approach which has three tables: Clients, Contacts and Jobs.

The clients table has linked records to contacts to denote all the contacts that we work with at that client. And linked records to jobs to denote all the jobs we are working on with that client. A client can have multiple linked contacts and multiple jobs, but contacts and jobs can only be linked to one client.

When I'm creating a new job record, I'd like to select the specific contact at the client who represents the lead contact for that particular project.

I realise this can be achieved by a simple linked record field to the contacts table. However, when selecting from the contacts table, this shows all contacts regardless of which client they are at. Which theoretically means it would be possible to assign a contact from a different client than the job is for.

What I was hoping was that there was a way to filter or add conditions to the linked record options so that when I go to select the contact, it only shows contacts who are assigned to the same client as the job is for. I'm open to this being done through a very different approach if it needs some backgrounds formulas etc to achieve this - if it's possible at all.

I'm attaching screenshots of the three tables to demonstrate what I've described. Thanks in advance for any guidance.

1 Reply 1
7 - App Architect
7 - App Architect

Hi @ben10

I wish that I had better news for you, but unfortunately this kind of functionality is not possible in Airtable at the moment. You can not conditionally limit select options from a linked field (or single-select/multiple select), based on the selection in other fields in the table. This is true for form views as well. 

If this is a feature you are passionate about I encourage you to post to the Product Ideas board in the Airtable Community. 

Third party form tools do exist to fill the gap in the use case that you describe. I would encourage you to check out On2Air Forms, as they allow for you to conditionally limit the linked field options in the form based on previous sections.