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

  • Profile Image
    fbarrin1
    Asked on October 04, 2017 at 02: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.

  • Profile Image
    Mike
    Answered on October 04, 2017 at 04: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.3

    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.4

    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.4

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

    1554466751Screen Shot 2019-04-05 at 10.4

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

    1554466743Screen Shot 2019-04-05 at 10.4

    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.

  • Profile Image
    nelly
    Answered on April 05, 2019 at 08: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.3

    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.4

    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.4

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

    1554466876Screen Shot 2019-04-05 at 10.4

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

    1554466862Screen Shot 2019-04-05 at 10.4

    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