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:
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.
(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…).