Skip to main content

I have the following case history:
a base with multiple tables interconnected with each other;
I've created an interface form to populate one of these tables;
In this interface I have a field that allows me to select a record linked to another table;
In this field, again from the interface, I have the possibility to choose only existing records;
Is there a way to add, from the interface form, a new record directly from the field with the drop-down list?

 

Directly from table this is possible, but not from the interface form or any form view.

 

Many thanks

No, that is not possible with Airtable’s forms, but you have 3 good workarounds for this:

  1. Give your users a link to click on which takes them to another form to add the linked record.
  1. Give your users a fake linked record that is named something like “CREATE NEW RECORD”. And then, if they choose that option, reveal additional fields for them to type the new information. And then, after the form is submitted, run an automation to create the new record. Personally, I do not like this method, because it adds extra clutter & overhead to your base.

  1. Your #1 best bet for this is to use Fillout’s advanced forms for Airtable because it natively lets you add new linked records with a form.

    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:

    - Using Fillout to create an eSignature approval process with PDF file creation.
    - Using Fillout to create an order entry form with line items.

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

 

Our company is having the same problem. This should be an option in Airtable Forms. It's a common situation.

My guess is that Airtable must be working on it, since it’s such a common request that comes up all the time. 

However, in the meantime, you can always use Fillout’s advanced forms for Airtable because it natively lets you add new linked records with a form.

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

Much more need feature - please work on it 

Hi there!

At miniExtensions, we've created a third-party form that integrates seamlessly with Airtable, and allows you to add new records through any linked record fields in your form: 

 

 

 

Reply


Terms & Conditions