I’d like to request the ability to add new linked records in interface forms. I use forms for adding data and I need to be able to create new linked records. this is a huge limitation at this time.
Yes, this is an unfortunate limitation with ALL the forms in Airtable, not just the forms in interfaces. It would be a really nice feature to have!
In the meantime, one good (free) workaround for this would be to create a completely different form that adds records into the linked record table. And then, back on your original form, you can give people a link to click on which guides them to the other form.
You could put some text on the form that says something like:
If the option you’re looking for doesn’t exist in the list, please go to this form to add it: https://www.example.com/
Alternatively, for a paid workaround to this dilemma, MiniExtensions.com offers this feature natively on their forms. You can create new linked records in their forms.
The brand new On2Air: Forms might offer this feature as well… I don’t see it listed on their product page, but @Hannah_Wiginton would know for sure about that!
For a workaround, you can get Linked Field records created with an Automation upon a Form being logged, but they require time to setup, modify and maintain - overhead to keep in mind.
Have your Automation trigger upon a New Form Record being created, and then copy the various fields you’re needing into a Linked Fields (perhaps after some data cleansing or duplication checks) - I found the Script Action was a must have for this process.
One main problem that I found with Automations for this purpose (of creating Linked Records from Forms), is that they can easily clash with Automations that trigger upon new record creation - as there are no prerequisites that prevent other Automations from triggering when a new record is created by a form (again, more workarounds…)
Wanted to mention another new way you could do this (for free!) is with fillout.com - it’ll take less than 3 minutes or so to connect your Airtable and you’ll be able to create new linked records in your form. We have a quick help article here if you’d like to see it in action!
Very cool, @Hannah_Wiginton!! Thanks! :grinning_face_with_big_eyes: On the page that you linked to above, and on the main landing page for On2Air Forms, it doesn’t list creating/editing linked records as a feature. That might be a good one to add to the list! :slightly_smiling_face:
Thanks Scott! I’ll add that feature on the Forms beta. We have a new webpage for On2Air Forms, but it’s not live just yet. :grinning_face_with_big_eyes:
This is a feature that is a must have. On top of what I see above, we need to restrict the ability for the person filling out the form to be able to see existing records in the linked table. Specifically this is because we want parents to be able to register themselves (create a parent record) and their children (create linked student records) for a class without seeing the details of all the other children that already exist in the table.
I feel that this isn't a monumental leap from the functionality that already exists in Interface forms. Just need it within Airtable rather than going through third party systems (eg Zoho Forms, miniextensions etc).
