What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Zapier: How to send existing submissions to integrated app?

    Asked by fmfernandez on July 04, 2017 at 11:16 AM

    Hello,

    I created a Zap in Zapier that goes like this:

    1- On new Jotform submission

    2- Lookup spreadhseet row with same e-mail as the submission

    3- Update row

     

    The zap is working according to the tests. Now, I would like to run it for all the submissions the first time, and then run it for new submissions. Can I do something (perhaps with a jotform API call?) to make all this jotform form's submissions appear as new for zapier for one time?

     

     

     

     

     

    Page URL:
    https://form.jotformz.com/71832585684670

  • Profile Image
    JotForm Support

    Answered by Kevin_G on July 04, 2017 at 01:19 PM

    I have checked the current integrations with Zapier and it seems like there is not a current way to send existing submissions, it seems to be triggered only with the new submissions. 

    I think you may want to try the following: 

    1. Integrate your form directly with Google Spreadsheet: How-to-Integrate-Form-with-Google-Spreadsheet

    2. The integration will create the sheet and will also send existing submissions. 

    3. Once you have created this, you could re-integrate on Zapier, select the sheet created from JotForm and get all the existing submissions as well as new ones. 

    4. Do not forget to remove the integration on JotForm (from the form builder) in order to avoid conflicts. 

    Hope this helps.