Mar 01, 2024 04:00 AM
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
Mar 01, 2024 06:06 AM - edited Nov 29, 2024 07:24 PM
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.
2. 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.
3. Use Fillout’s advanced forms for Airtable, which enables you to add new linked records from a form, and about 100 other advanced Airtable features, such as displaying as many fields as you want in a linked record picker, displaying Airtable lookup fields and rollup fields and formulas on a form, updating Airtable records from a form, and much more.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Oct 17, 2024 12:13 PM
Our company is having the same problem. This should be an option in Airtable Forms. It's a common situation.
Oct 17, 2024 12:30 PM - edited Nov 29, 2024 07:20 PM
My guess is that Airtable must be working on it, since it’s such a common request that comes up all the time.
However, be sure to send an email to support@airtable.com to request this feature, and in the meantime, you can always use Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Nov 29, 2024 06:15 AM
Much more need feature - please work on it