I have a base with a field "Company" that is a linked record.
Ultimately, I want to pre-fill my form with all values inc Company.
First, how can one pre-fill a Linked record field? Seems like it isn't possible.
Second, even if it is possible, how can I allow the creation of a new such Linked record from the form?
Best answer by ScottWorld
Yes, you can prefill a linked record field. The Prefilled Forms extension which @kuovonne created can help you with that.
However, prefilling forms is not the recommended way for updating a record in Airtable with a form, because:
The recommended way is to use Fillout, which is 100% free and lets you update Airtable records with a form — no prefilling necessary! It supports all field types, the link never breaks, and there are no complex automations to maintain.
Additionally, unlike Fillout’s forms, Airtable does not offer any built-in ability to add new records into a linked table from a form. Only Fillout can do this natively.
Although there are 2 workarounds for handling this in Airtable:
But, as I mentioned above, the best and easiest method would be to use Fillout's advanced forms for Airtable, which natively offers this feature on their forms.
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
+35Yes, you can prefill a linked record field. The Prefilled Forms extension which @kuovonne created can help you with that.
However, prefilling forms is not the recommended way for updating a record in Airtable with a form, because:
The recommended way is to use Fillout, which is 100% free and lets you update Airtable records with a form — no prefilling necessary! It supports all field types, the link never breaks, and there are no complex automations to maintain.
Additionally, unlike Fillout’s forms, Airtable does not offer any built-in ability to add new records into a linked table from a form. Only Fillout can do this natively.
Although there are 2 workarounds for handling this in Airtable:
But, as I mentioned above, the best and easiest method would be to use Fillout's advanced forms for Airtable, which natively offers this feature on their forms.
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
Yes, you can prefill a linked record field. The Prefilled Forms extension which @kuovonne created can help you with that.
However, Airtable does not offer any built-in ability to add new records into a linked table from a form.
But you do have a bunch of different workarounds for handling this:
- One workaround involves adding extra fields to your form, and then running an automation after the form is submitted that adds the new record into the other table.
- A much easier method would be to give people a link on your form to click on which would take them to ANOTHER FORM to submit new entries into the other table.
- However, the best and easiest method would be to use Fillout's advanced forms for Airtable, which natively offers this feature on their forms.
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.
- Another alternative approach would be to use other external form software like JotForm, and then use Make to parse out all the data into the right tables for you.
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
Oooh, great answer - thanks.
+15At 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. Additionally, you can prefill those new records with static or dynamic values:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
