Skip to main content

From my research, I think the answer to this question is, "it can't be done", but I'm hoping I'm missing something.

My base has 3 tables:

  • Waiting List - this is the "main" table, listing the people on the waiting list.
  • Events - defines the events for which people may be waitlisted.
  • Site Types - lists the possible site types that could be available to a person on the waiting list.

Here's a highly simplified version of the base that illustrates the setup.

Each record in the Waiting List table is linked to a single Event Name record in the Events table.

Each record in the Events table is linked to one or more Site Types in the Site Types table. This link field defines the subset of Site Types that are available for that particular Event. This data is repeated as "Available Site Types" in the Waiting List table via a lookup field (if it's needed). As I have it set up, one Site Type record can be linked to multiple different Event records, but that's not mandatory--if it helped solve the problem, the Site Types could be unique to each Event.

The "Join the waiting list" form in the Waiting List table is used for data entry. In an ideal world, the form would display a Multiple Select field with the Site Types available for that event--but I realize that the options for this type of field can't be dynamically populated.

So instead, the form displays the link field to Site Types. The form is pre-populated with the Event Name, which is hidden so the user can't change it, and all the Site Types available for that event as defined in the Events table. The user is instructed to remove (click the "x") on each site type they would not be willing to accept if offered to them. Here are two examples for two different events:

This actually works pretty well, unless the user hits the "+ Add" button. Then they will see ALL of the Site Types, including ones that don't apply to that Event. Instead, I'd like the list of Site Types they see to be limited to those that are listed in the Site Types field of the Events table. I can't seem to find a way to do that. (Suppressing the display of the + Add button would be another avenue, but I don't think that's possible either.)

Limiting the record selection to a view in the form field doesn't solve the problem, because as far as I can tell there is no way to dynamically filter a view to just the subset of available Site Types.

Any ideas?

Hi David,

If I follow you correctly, you only want a specific list of New York locations able to be selected with New York events, and vice versa with Los Angeles.

You can setup two "Views" in your "Site Types" table. Duplicate the "Grid View" twice and label one "New York" and the other "Los Angeles". Filter one where "Event " "is exactly" "New York event", and the other "Event " "is exactly" "Los Angeles event". Then in your form on "Acceptable Site Types", select "Limit record select to a view" and select "Los Angeles event". Next select "Show fields only when conditions are met" and add the condition of Where "Event Name" "is exactly" "Los Angeles event". Duplicate "Acceptable Site Types" and follow the same steps but for "New York events".

This should show only the options based on the select of either site locations, and not the other.

Hi David,

If I follow you correctly, you only want a specific list of New York locations able to be selected with New York events, and vice versa with Los Angeles.

You can setup two "Views" in your "Site Types" table. Duplicate the "Grid View" twice and label one "New York" and the other "Los Angeles". Filter one where "Event " "is exactly" "New York event", and the other "Event " "is exactly" "Los Angeles event". Then in your form on "Acceptable Site Types", select "Limit record select to a view" and select "Los Angeles event". Next select "Show fields only when conditions are met" and add the condition of Where "Event Name" "is exactly" "Los Angeles event". Duplicate "Acceptable Site Types" and follow the same steps but for "New York events".

This should show only the options based on the select of either site locations, and not the other.


@gsteinbrecher wrote:

If I follow you correctly, you only want a specific list of New York locations able to be selected with New York events, and vice versa with Los Angeles.

Well, sort of. The New York and Los Angeles events were just examples to illustrate the question. In real life, internal users will create events as needed, so there could be any number of events. And I can't count on those users to know how to create the appropriately filtered views (and a separate copy of the form for each one) and then get the embed code for each form. That's why I want to figure out a way to do it dynamically with a single form and a single view.

@gsteinbrecher wrote:

If I follow you correctly, you only want a specific list of New York locations able to be selected with New York events, and vice versa with Los Angeles.

Well, sort of. The New York and Los Angeles events were just examples to illustrate the question. In real life, internal users will create events as needed, so there could be any number of events. And I can't count on those users to know how to create the appropriately filtered views (and a separate copy of the form for each one) and then get the embed code for each form. That's why I want to figure out a way to do it dynamically with a single form and a single view.


I don't think you can do this with Airtable forms I'm afraid.  You're probably going to need to look into utilizing another piece of software like On2Air forms, miniExtension forms, Jotform, etc to get this functionality

I don't think you can do this with Airtable forms I'm afraid.  You're probably going to need to look into utilizing another piece of software like On2Air forms, miniExtension forms, Jotform, etc to get this functionality


Thanks. I figured that was probably the answer. 😞

@David_Goldstein 

2025 Update:

This is now natively supported in Airtable using dynamic filtering in linked record fields.

However, dynamically linked records has always been a built-in feature of Fillout’s advanced forms for Airtable, and it is MUCH EASIER to set it up in Fillout.

Fillout allows you to create or update records in Airtable with a form, and also allows you to dynamically change which linked records are available to choose from based on a chosen value in another field.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

 

Hey there, what you're trying to achieve here is easily doable with our miniExtensions Form's dynamic filtering capabilites. You could set this up so the filter field is the Event and hide the filter field entirely. This way, users would only ever see relevant records displayed to them!

Terms & Conditions