Form - edit multiple tables

Using an External Forms package and Zapier

I’ve just read this thread through and would like to share a blog post I wrote in November about using Cognito Forms and Zapier to populate multiple sub records (from repeating fields in Cognito) in a database (Airtable is used as an example):

http://software.kirknessassociates.com/blog_files/9c91c7ada28c024f95a26f1ac8a8d620-25.html

This allows for the creation of a main record and sub records in Airtable.

Using Airtable forms and a separate table

Another approach I’ve used on projects is to capture the data into a single receiving table and then use Zapier (or Integromat, which is perhaps a more powerful solution) to ‘split it up’. This approach can even be used to update existing records - you simply need to search for the record to update in the Zapier Zap or Integromat Scenario and if it’s found you can update it - or if not create it.

I’ve not introduced Integromat into this forum before as I’ve only recently found it but it offers more flexible logic that Airtable (for example branching based on conditions). I will probably write a blog post about it soon.

Thanks @Julian_Kirkness. Can’t say I’m a fan of either solution, but I understand that unfortunately we don’t have a lot of options here and I appreciate your advice.

I also need this for my application.

I’d like to use a form to enter data into multiple tables as discussed here:
https://community.airtable.com/t/form-edit-multiple-tables/5454/4

(separately discussed, I’d also need to enter data into multiple records as discussed here: Multiple Record Entry Forms)

This would allow me to enter parts on a quote where my quote table contains top-level information (Account, Contact, Quote Date, Etc…) and then on another table to load line-item data (part or service #1 at price X with quantity Y, part or service # 2 at price Y at price A with quantity B…).

Thanks,
Mike

Any update on this? I’d love to build a form that pulls info from a couple different tables. Is this in the works?

Ditto. This would be great.

Needed! Otherwise, the only option is to duplicate info across tables.

Hi dear people. This indeed would be wonderful

Do you know if it’s possible to pull information sitting in one row into a new row on another table?

I also need this feature.

Have heard anything on this topic? Would love to see this feature. @Airtable_Team

+1 on support for fields from multiple tables in forms.

Use case:
I want viewers to be able to submit data to an Events table, while also giving me their phone number. They already exist in my Users table. I’d want to pre-fill the user data they have, collect the user data we don’t have, and submit the new event with a single submission.

I work in film and video production. When I bring on a crew, I have them fill out a form which lists name, e-mail address, mobile phone, food allergies, scheduling conflicts, their production department, and their production title. The problem is, this information needs to be distributed into two different tables:

One table holds name, e-mail, mobile phone, & food allergies-- that information tends to stay the same from production to production, so I keep that in a “master contact table” (which I also use as my general address book)

Another table (the “Roster” table) holds the person’s scheduling conflicts, production department, and production title-- that information differs from production to production, so I don’t want to keep it in my master contact table because the same contact might work on different productions in different roles and I need to keep track of who did exactly what on each production.

(Yes, I could just keep it all in the “Forms table” and try to manage everything with filtered views, but that would be unwieldy because each contact could be entered multiple times-- making it clunky as an address book)

Because air table forms only allow information to go into a single table, I have to go through some crazy gymnastics in order to get the information from the crew form into the appropriate fields. Currently, I do this:

I have a THIRD table, a “Forms” table which collects information for all of the fields.

I have a Zap which 1) pulls the name/phone/e-mail/allergies info from the forms table into the master contact table (updating an existing record or creating a new record as needed) 2) copies the name/department/role/scheduling conflicts info into the rosters table 3) links the name record in the rosters table to the name record in the master contact table (and finally) 4) deletes the record in the forms table once all of the information has been moved into the correct place.

This multi-step Zap costs $25/month.

However, if I could create a form with field inputs from multiple tables (instead of being limited to my form only inputting information into a single table), I could save myself a lot of money and headaches.

Up, still interesting ! @Airtable_Support

My need : to use a subtable in three differents ways :

1. a source of datas in which user will select one or more items. This one is already develop in your product.
2. give the possibility for the user to create a new entry if he don’t find an existing item (a kind of “Other entry”)
3. Only propose a sub form merged with the parent form. In other words no possibility to select an existing entry.

Agreed, this is also requested on

Hey folks! While we don’t yet support this feature in our own forms at the moment, we just partnered with JotForm to build a direct integration between Airtable and JotForm. With JotForm, you can set up the integration so that submissions can feed into multiple tables across different bases. You can read their instructions on how to do it here.

ah very cool. I was aware of the integration, but not that you could set it up multiple times for the same form (so that it could go to different tables/bases).

We are big fans of Jotform and do a lot of work with it in conjunction with Airtable. Its our preferred form solution.

One more integration… Do we need to get a new licence to use JotForm ? Please !

We built a tool that allows you to achieve that with the least amount of work possible. It takes the incoming data from one Airtable form and copy it into multiple tables. The nice part is that you can setup how the data is divided inside Airtable itself.