Skip to main content

Hi Team, I would like to understand, how to automatically reset the form sub-field values, when user change the parent input field. Here is a simple example,

  1. Form has two fields, Country and State which is dynamically populated using Linked record feature
  2. State field will be shown displayed, only when Country field is not-empty (ie, only when user selects the country, state field will be enabled for selection)
  3. Once user selects the Country and State, and when we clear the country selection, then automatically state field is getting disappeared as per the condition mentioned in step-2
  4. When user selects the country again, State field is shown, but with previously selected value
  5. We do not want this field to show the users previous selection, because user has changed the country , hence we want user to reselect the state freshly and not showing the previous selected value

 

​@JothiKrishnan 

Unfortunately, this is not possible with Airtable’s forms.

You can only get this behavior with Fillout’s advanced forms for Airtable.

In Fillout, whenever you conditionally hide then show a field again, the field will start off as empty again.

Or it will start off as whatever default value you set for that field. You can even set the default value dynamically based on other form values.

In Fillout, conditional visibility is setup in the “Logic” section for that field.

Note that you will need to setup the filtering for your “dynamic linked record selection” on your Fillout form itself, because Airtable doesn’t provide this information to Fillout.

In Fillout, you can setup dynamic linked record selections in the “Advanced -> Filter” section of the linked record field, and you will appreciate how much more powerful it is than Airtable’s dynamic linked record selections.

If you’re not familiar with Fillout, 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, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

These 2 videos don’t apply to your situation, but 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 ​@JothiKrishnan as Scott mentioned, unfortunately this is not possible.

On this other article I list some of the differences between Airtable native forms and Fillout Forms.

Also, you might want to submit this as a feature request using this form. Airtable’s forms are super limited, and pushing for new features would be amazing.

Mike, Consultant @ Automatic Nation

Reply


Terms & Conditions