I have a table that uses a form to enter meeting information including who was there (linked field to another table). If I need to add new people to the people table through the meeting form, is there a way to do that?
Linked Fields on Forms
+1
+10I don't believe you can create new linked records in linked tables through Airtable forms. But some potential workarounds -
- Create a separate text field in your form (like New Attendees) and then trigger an Airtable automation to create that person in People if it's blank (note that would be fine for 1 new person - if you have multiple either need to use Make.com or create additional text field columns which may be cumbersome)
- You can use a 3rd party like Fillout
+35Unfortunately, that is one of the major limitations of Airtable. It is not possible to create new linked records from a form.
There are 3 workarounds for this limitation:
1. On the first form, give the user a link to ANOTHER FORM which will allow them to add new records to the linked table. Then, they can come back to the first form to continue their data entry.
2. On the first form, in the linked record field, give the user an option to choose from that is called "new record" or something like that. Then, conditionally show additional fields where they can type in the new information. Then, use an automation to add the new record into the appropriate table.
3. Use Fillout’s advanced forms for Airtable, which already has this functionality natively built into its forms. Fillout is 100% free and offers hundreds of advanced features that aren’t natively available in Airtable’s native forms, such as adding new linked records from a form and updating existing Airtable records from a form.
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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.