Hmm, could you provide screenshots of the relevant bits of the form and table + field please?
Hmm, could you provide screenshots of the relevant bits of the form and table + field please?
Absolutely!
Here's the look up fields in the table that receives the form submissions:

Here's the table with the list of groups set up as outlined in Option 2 of this guidance:
Approved Grid View

Unapproved Grid View:

And of the form:



There's something in the Table of groups with the Approved and Unapproved that seems off and clearly the modified automation pictured in my initial post isn't rectifying it. May have to hop on a call with Airtable for this one but would love to hear if you have any ideas. Thanks for thinking about it!
Hmm, in the "Update Record" action, try updating the field "CA Local Groups" with the value "CA Other Option", I think that'll do what you need
If that doesn't work I'd be happy to take a look at it for you if you DM me a read-only collaborator invite link!
Hmm, in the "Update Record" action, try updating the field "CA Local Groups" with the value "CA Other Option", I think that'll do what you need
If that doesn't work I'd be happy to take a look at it for you if you DM me a read-only collaborator invite link!
Appreciate you drilling down on this! Changed the automation and still a no go. I'm setting up an Airtable Ask an Expert session and will report back in case others are attempting to do the same.
Appreciate you drilling down on this! Changed the automation and still a no go. I'm setting up an Airtable Ask an Expert session and will report back in case others are attempting to do the same.
Interesting! Does the automation error out or something? What should be happening is that whatever the user keyed in to the "CA Other Option" field gets created as a new record in "CA Local Groups" with that as the primary field value
Best of luck!
Interesting! Does the automation error out or something? What should be happening is that whatever the user keyed in to the "CA Other Option" field gets created as a new record in "CA Local Groups" with that as the primary field value
Best of luck!
Circling back on this for anyone who's interested and attempting to do the same. Our team had an Airtable Ask an Expert session and it was a game changer. We now have dynamic filtering in an Interface Form where someone submitting the form can add an option to the list for future selecting. For our use case we want individuals who submit a form to select from a list of group names that are filtered by state. So when they select their state only those groups names linked to that state present for selecting. Note, this only works in Interface Forms not in regular form view.
One table lists all 50 States and, for our use case, D.C. Another table lists all group names including Other. Link the two tables. There's a little setup work here where you have to manually link each group name to the applicable state.
In the table that receives the form responses, link both tables and add the lookup fields you need. For our use case it looks like this:

In your form, add the State and Group Names linked fields. We also added a Limit Selection of 1 for each field as seen below.

Add a conditional short answer field for when Other is selected
For adding the short answer to your list of Group Names when Other is selected create an automation: When a record matches conditions with the following trigger details

Add two Update record actions. Action Details #1

Action Details #2

Good luck!