Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Linked Fields on Forms

148 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rana_S
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2
ibayub
6 - Interface Innovator
6 - Interface Innovator

I 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

ScottWorld
18 - Pluto
18 - Pluto

@Rana_S 

Unfortunately, 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