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

    PDF Submissions: Download all at once as separate PDF files

    Asked by stowestory on June 30, 2016 at 05:15 PM
    Submissions download submission
  • Profile Image
    JotForm Support

    Answered by BJoanna on June 30, 2016 at 07: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.

  • Profile Image

    Answered by stowestory on June 30, 2016 at 08:45 PM
    Is there a way to download the whole batch of applications in one folder of
    PDF files?
    Thank you,
    David
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan 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:

     

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

  • Profile Image

    Answered by stowestory on July 01, 2016 at 05:47 AM
    Will this do them all at once or do I have to do each one seperately??
    Thank you,
    David
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on July 01, 2016 at 09: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.

    2. Download your submissions as an excel file.

    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.

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

    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.

    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.

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

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

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

    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.

    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.

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

    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.

     

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

     

    16. They are all now downloaded.

     

     

    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.

  • Profile Image

    Answered by stowestory on July 01, 2016 at 09: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
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on July 01, 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.