This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
At the moment we’re allowed to link the form to one table, I would like to have an option to link the form to several tables and so the data will be splitted into the tables according to the questions/columns :slightly_smiling_face:
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):
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:
(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…).
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.