PDF Submissions: Download all at once as separate PDF files

  • stowestory
    Asked on June 30, 2016 at 5:15 PM
  • BJoanna
    Replied on June 30, 2016 at 7:27 PM

    You can download your submission in excel and sent the your excel file to your team.

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel  

    You can also create excel report and share the link of your report with your team: 

    https://www.jotform.com/help/101-How-to-Create-an-Excel-Report 

    https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm 

    If I did not understood you correctly, please explain in more details what you are trying to achieve. 

    Let us know oif you need further assistance.

  • stowestory
    Replied on June 30, 2016 at 8:45 PM
    Is there a way to download the whole batch of applications in one folder of
    PDF files?
    Thank you,
    David
    ...
  • jonathan
    Replied on June 30, 2016 at 11:20 PM

    Hi David,

    You can do download all the existing submissoin data of the form in PDF document file format.

    Use the PDF button in the submission grid when in the submission panel of your form.

    Example:

    PDF Submissions: Download all at once as separate PDF files Image 1 Screenshot 20

     

    Hope this help. Let us know how if you need further assistance.

  • stowestory
    Replied on July 1, 2016 at 5:47 AM
    Will this do them all at once or do I have to do each one seperately??
    Thank you,
    David
    ...
  • Charlie
    Replied on July 1, 2016 at 9:34 AM

    If you are clicking the "Download as" button in the submission page, it will download all the submissions of that form as ONE PDF file.

    If you want to download the submissions as one separate PDF file, then I believe it is not yet possible using existing features. BUT I do have a workaround in mind. You can check the steps below, it is quite lengthy but I hope it will help.

    Please be familiar with this guide, we will follow this same extension and concept on how to download all our submissions as PDFs: http://www.jotform.com/help/315-Downloading-File-Uploads-in-the-form-using-DownThemAll-Mozilla-Firefox-Extension

    Now, to start, what we want to do is to have an excel file with all the submission PDF downloadable link on it and use the extension DownThemAll to download all of it automatically.

    1. Navigate to your Submissions page and make sure to tick the "ID" check box.

    PDF Submissions: Download all at once as separate PDF files Image 1 Screenshot 160

    2. Download your submissions as an excel file.

    PDF Submissions: Download all at once as separate PDF files Image 2 Screenshot 171

    3. Open the downloadable excel file, then create additional 2 sheets. In my case, I named them "Sheet1" and "Sheet2".

    Sheet1 will be the sheet where we will combine all the necessary parts of our link.

    Sheet2 will be the sheet where we will display the final download PDF links.

    PDF Submissions: Download all at once as separate PDF files Image 3 Screenshot 182

    4. In the "Submissions" sheet, you will see your submission data. Copy the "Submission ID" column. We will pasted it in "Sheet1". 

    PDF Submissions: Download all at once as separate PDF files Image 4 Screenshot 193

    5. Navigate to Sheet1, paste the Submission ID in column 2. Here's the break down of our columns. We will combine columns 1, 2 and 3 to have the final download link.

    Column 1: This is the URL structure of how the PDF submissions are being downloaded in JotForm.

    http://submit.jotformpro.com/server.php?action=getSubmissionPDF&sid=

    Column 2: This is the list of our Submission IDs, we will append them on column 1.

    Column 3: This is the Form ID, it is the same with all of the submissions so you can just copy and paste to make duplicates, or you can hold and drag.


    6. We will often use the function in excel file the hold and drag function to copy not only the value but also the formula. You see in column one, place your mouse at the lower right part of the box, the mouse will change into a cross, hold and drag down to copy and paste the values in your other rows.

    PDF Submissions: Download all at once as separate PDF files Image 5 Screenshot 204

    7. How to combine all three columns? You can check it here: Combine Contents of Multiple cells in one. So basically, add "&" on each cell.

    On column "D2", I added in the function bar this: "=A2&B2&C2"

    Now, to apply the formula to all of your rows, you can hold and drag downwards again.

    PDF Submissions: Download all at once as separate PDF files Image 6 Screenshot 215

    8. After that, you'll see that we have our downloadable links. Make sure that you are doing it correctly, check the submission ID on those links, if they are unique on each other, then everything is right on track. We want to have those links in our "Sheet2". Why? Because we can download them on "Sheet1".

    PDF Submissions: Download all at once as separate PDF files Image 7 Screenshot 226

    9. Navigate to "Sheet2". Click Insert->Hyperlink.

    PDF Submissions: Download all at once as separate PDF files Image 8 Screenshot 237

    10. Now we will add in the Address bar this: "=Sheet1!D2". We are referencing the first link value in column D, which is in "D2".

    PDF Submissions: Download all at once as separate PDF files Image 9 Screenshot 248

    11. After that, you'll see our first downloadable link in "A1". Now how do we copy the rest of the links? Just like what we are doing earlier, just hold and drag downwards.

    PDF Submissions: Download all at once as separate PDF files Image 10 Screenshot 259

    12. After that, make sure to save the excel file, to save the changes. 

    We will then save it as an HTML file. First, click "Save As"->Choose .htm or html as file type. Check the file name.

    PDF Submissions: Download all at once as separate PDF files Image 11 Screenshot 2610

    13. Navigate to your folder where you saved it, right click->Open with->Firefox.

    PDF Submissions: Download all at once as separate PDF files Image 12 Screenshot 2711

    14. Here you can download all the links automatically, just right click on the page and click "DownThemAll". Note: Make sure that you are viewing "Sheet2", you can check which sheet you are viewing at the lower left side of the browser. Also, make sure that only one link per line is shown in your page.

    PDF Submissions: Download all at once as separate PDF files Image 13 Screenshot 2812

     

    15. You can also highlight all of the link and right click, choose "DownThemAll". Click "Start" to download.

    PDF Submissions: Download all at once as separate PDF files Image 14 Screenshot 2913

     

    16. They are all now downloaded.

    PDF Submissions: Download all at once as separate PDF files Image 15 Screenshot 3014

     

     

    I hope this helps. If you need more assistance on this, please let us know.

    I will also forward this to our developers as a feature request, to let our users to download all or multiple submissions as separate PDF files. I am unable to guarantee that it will be implemented, but rest assure that we will update you on this thread as soon as we hear any news.

    Thank you.

  • stowestory
    Replied on July 1, 2016 at 9:45 AM
    thank you. So I understand, I can make one PDF of all the submissions or
    use this work around to create a separate PDF of each submission?
    Thanks,
    David
    ...
  • Charlie
    Replied on July 1, 2016 at 10:59 AM

    Yes that is correct, for now, the only way to download multiple submissions as separate PDF is by using the workaround. 

    Apologies for the inconvenience.

  • CustomerMining
    Replied on March 13, 2017 at 12:37 AM

    Hello - 

    I have tried this process to download 1,034 forms we have in the system but there isn't a download all option in any of my browsers.

    Can you assist?

    Bev

  • Charlie
    Replied on March 13, 2017 at 2:10 AM

    @CustomerMining

    To better assist you, I have opened a separate thread for your concern. Please refer to this link instead: https://www.jotform.com/answers/1089700

    Thank you.