All Collections
Advanced Form for Airtable
Conditional Field Visibility
How to check if a record exists and only show the complete form if it doesn't?
How to check if a record exists and only show the complete form if it doesn't?
Updated over a week ago

We don't have a straightforward solution for this, but here's the workaround:

  1. Add a formula in Airtable to detect whether the "Name" field is filled or empty. E.g. IF(Name,1,0)

  2. Turn on Compute Mode.

  3. Set the fields in the form to be conditional and let them only show up if the "Name" is filled. Select the formula field you just created as a condition.

This way the form will only have the "Name" field showing by default and users will be able to click compute or "NEXT" to load the rest of the form fields if the "Name" doesn't exist. Or the user will get an error if the name does exist already.

Did this answer your question?