Am I correct in assuming that if a submission is edited, instead of overwriting the data, there is no way to create a new record per submission with o

  • fbarrin1
    Asked on October 4, 2017 at 2:59 PM

    I have a separate question: Am I correct in assuming that if a submission is edited, instead of overwriting the data, there is no way to create a new record per submission with other services (such as Google Sheets, Zapier, AirTable, etc.)? We'd like to have a record of the original submission and the edited submission.

    Looking at the JotForm Google Sheets Third-party Integration, it seems like an edited submission updates the record. Looking at Zapier to Google Sheets, if a record is edited, the Zap doesn't add a record. Looking at Zapier to AirTable, only new submissions are added.

  • Mike
    Replied on October 4, 2017 at 4:03 PM

    UPDATE (April 5, 2019): Direct integration with Airtable is available now. 

    1. Open the Form Builder.

    2. Find the Airtable integration under the Settings.

    1554466796Screen Shot 2019 04 05 at 10 Screenshot 10

    3. Paste your API Key and click on the "Authenticate" button. (To generate API Key, you should open this page and click on the "Generate API Key" button)

    1554466786Screen Shot 2019 04 05 at 10 Screenshot 21

    4. Select which of your bases you would like to connect to, then select one of the tables within the base.

    1554466763Screen Shot 2019 04 05 at 10 Screenshot 32

    5. Map the fields on the table with form fields and click on the "Save" button. 

    1554466751Screen Shot 2019 04 05 at 10 Screenshot 43

    6. You can create multiple connections to various Airtable bases and tables with the same integration.

    1554466743Screen Shot 2019 04 05 at 10 Screenshot 54

    The submissions will be sent to Airtable every time your form is submitted.

    Additionally, you can look at this guide to learn how to integrate JotForm with Airtable: https://www.jotform.com/help/561-How-to-integrate-JotForm-with-Airtable

     

    There is no way to generate the new entries on native JotForm integrations like Google Sheet when the submissions are updated. When the submission is edited it will be updated in JotForm and linked Google Sheet.

    I think that for Zapier it should be tested for each specific Zap since it may be different for different integrations.

  • Nur Karabağ JotForm Developer
    Replied on April 5, 2019 at 8:21 AM

    UPDATE: Direct integration with Airtable is available now. 

    1. Open the Form Builder.

    2. Find the Airtable integration under the Settings.

    1554466914Screen Shot 2019 04 05 at 10 Screenshot 10

    3. Paste your API Key and click on the "Authenticate" button. (To generate API Key, you should open this page and click on the "Generate API Key" button)

    1554466904Screen Shot 2019 04 05 at 10 Screenshot 21

    4. Select which of your bases you would like to connect to, then select one of the tables within the base.

    1554466888Screen Shot 2019 04 05 at 10 Screenshot 32

    5. Map the fields on the table with form fields and click on the "Save" button. 

    1554466876Screen Shot 2019 04 05 at 10 Screenshot 43

    6. You can create multiple connections to various Airtable bases and tables with the same integration.

    1554466862Screen Shot 2019 04 05 at 10 Screenshot 54

    The submissions will be sent to Airtable every time your form is submitted.

    Additionally, you can look at this guide to learn how to integrate JotForm with Airtable: https://www.jotform.com/help/561-How-to-integrate-JotForm-with-Airtable