- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 01, 2021 09:09 AM
Hello everyone. I am just in the beginning states of a big project (for me), which I hope will do the following. I have customers who fill out 5 different forms. Right now, after they are submitted, I go through the forms, and copy and paste entries into my Airtable. What I would like to do is have the forms update the initial entry with information. The flow would look like:
- Customer fills out form 1, creating the entry
- Customer fills out form 2, updating the entry
- Customer fills out form 3, updating the entry
Etc.
My first question before I get started is simple: is it possible for the content of other forms to be ADDED to cells in an entry, instead of OVERWRITING cells. I don’t want information that was submitted in a cell in Form 2, to be overwritten when the customer fills out some related information in Form 3. If this is possible, could someone kindly give me a keyword or a help article that explains how to do this?
I am not asking for help doing the updating (yet!), I am asking a very specific question about whether or not cells can be added to instead of overwritten, and a resource that talks about this if possible. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2021 03:54 AM
Hi there @Nate_Sheets , Michaela from Integromat here :wave:
Not sure how to make this work via Zapier but it certainly can be achieved with Integromat. It’s a no-code platform that lets you connect pretty much any online services and automate all kinds of processes.
Anyway, you’d do something along the following linea:
-
First of all, you need to get a hold of the existing record (in the scenario below, the record was found via an email address) with the ‘Search Records’ module.
-
You then retrieve the entire row of the record with a ‘Get a Record’ module.
-
Finally, you use the ‘Update a Record’ module in which you map the original value as well as the new value. Thanks to this, the data will be added, not overwritten :slightly_smiling_face:
The scenario looks like this:
If you’re curious to see what the options are when it comes to automating Airtable-related tasks with Integromat, you can check out the landing page of the Airtable integration listing all the currently available features of the integration as well as a library of pre-made templates :slightly_smiling_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2021 08:57 AM
Hi Michaela, unfortunately my form provider (Formplus) does not have an integromat integration ability.