Help

Re: Limit records that can be selected in link field in form

Solved
Jump to Solution
935 0
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Goldstein
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions

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

See Solution in Thread

5 Replies 5
gsteinbrecher
4 - Data Explorer
4 - Data Explorer

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.

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. 😞

ScottWorld
18 - Pluto
18 - Pluto

@David_Goldstein 

Dynamically linked records are a native built-in feature of Fillout’s advanced forms for Airtable, which allows you to create or update records in Airtable with a form, and which allows you to dynamically change which linked records are available to choose from, based on a chosen value in another field.

This is the only form app for Airtable which offers this feature.