Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Add new linked record when entering data in a form

cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Robbins
6 - Interface Innovator
6 - Interface Innovator

One of my fields is a link to another table. I’d like end-users who are using the Form to add data to be able to create new records in the linked table but from the primary table data entry form.

139 Comments
Aaron_Owen
7 - App Architect
7 - App Architect

I’ve been using Cognito Forms as my front end form which then passes the data into AirTable via Zapier. I really like the power of cognito forms and the nice custom field layouts you can do with it. You can even have the form perform complex calculations and dump the result into AirTable if all you care about is the result. Zapier connects the two and allows you to specify what action you want to take when a new form entry is submitted; one of which is create new record.

Daniel_Robbins
6 - Interface Innovator
6 - Interface Innovator

thanks for the info. Sounds overly complex and I’d rather Airtable add this
natively…

Erik_Johnson
4 - Data Explorer
4 - Data Explorer

Aaron,

Is it possible to use the repeatable section in Cognito form & zapier to populate a linked table? I have a request table and would like to populate a linked environment table. Each request could have multiple environments.

Thanks,

Erik

Aaron_Owen
7 - App Architect
7 - App Architect

From what I remember, the repeatable section in Cognito exports via Zapier
in sort of a strange way. I believe it’s in a comma separated single field.
I think running a test would be the best way to find out if it’ll do what
you’re wanting.

Aaron Owen

2440 Mariposa St. 2nd Floor
San Francisco, CA 94110
415-671-6588 x700 (o)
415-571-6979 ©

Erik_Johnson
4 - Data Explorer
4 - Data Explorer

Thanks Aaron. Yeah testing doesn’t seem to give me much success, I’ve tried
including the column names, ;, and commas.

Erik Johnson

Systems Analyst
Virtual Infrastructure & Release Team

😧 802.654.0000
F: 802.654.9699

Retail Business Intelligence Software, Point of Sale Merchandising

Mi9 Retail is the fastest growing provider of enterprise software for retailers, wholesalers, and brands, from corporate retail systems to point of purchase systems.

ccd7095dcf00435f843489fe72aa9d8474362953.png

Keith_Taylor
5 - Automation Enthusiast
5 - Automation Enthusiast

I agree - this could be a real game changer.

Being able to search and pull records from tables on the forms is awesome. It just needs to be taken one step further and allow the ability to create a new record from that form submission (that fills that table since it did not exist)…

We have a workaround that is working well, but again this would benefit a lot of people I believe.

Thanks!

Keith

Andreas_Skyttne
4 - Data Explorer
4 - Data Explorer

+1 for the possibility of adding records from the form view

John_Mazzarella
4 - Data Explorer
4 - Data Explorer

I’ve run into this same problem several times, it would be great to have some kind of “Sub Form” option, or some way to add a record into one table, while in the middle of adding a record into another table. For example:

I have a table of clients, and a table of groups that the client is a part of. When adding a new client from the form view, I can select from existing groups to associate the client with, but not create a new group. I’m hoping my base will be adopted by my team, but this problem makes the process more time consuming, which means people will be less likely to use it. :worried:

Justin_Miller
5 - Automation Enthusiast
5 - Automation Enthusiast

Would be a game changer for my team!

Keith_Teare
4 - Data Explorer
4 - Data Explorer

I need this too. Without it I have to have a user add themselves to a “People” table in order that they can then “choose” themselves in the form. When they go on to choose themselves their search “shows” existing “people” records to form users so I compromise the privacy of those already in the database. I would love a way to have a blank field that BOTH adds the record to the linked table AND accepts it as an input without showing other records in the table.

Make sense?

What is your work around? I’d love to have one too :slightly_smiling_face: