How can I separate the applications so that they may be judged by a third party panel of judges?

  • aapgfdn
    Asked on April 15, 2016 at 11:55 AM

    Last year I had to separate the pdf page by page. With more than 250 applicants this is an incredibly laborious task. Is there a way to download the individual applicants as separate pdf forms?


    Thanks,
    April

  • Welvin Support Team Lead
    Replied on April 15, 2016 at 2:21 PM

    There is a PDF button in the form submissions page that you can click to download the PDF file of the single submission, but doing so would take you time.

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 1 Screenshot 20

    Let me think for a workaround. I'll let you know later.

  • aapgfdn
    Replied on April 15, 2016 at 2:29 PM

    Oh yes, please please help me with a workaround! Otherwise I will have to do that 400 times! :-o

     

  • Welvin Support Team Lead
    Replied on April 15, 2016 at 2:51 PM

    Please do the following to download the PDF files separately:

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

    2. Filter the report by Submission ID only:

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 1 Screenshot 80

    3. Download the Excel Report

    4. Open the Excel file using MS Excel (hope you have one).

    5. Copy and paste this URL into another column: https://www.jotform.com/pdf-submission/. Here's example:

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 2 Screenshot 91

     

    6. Fill all rows with the same URL. You can just drag the row down to fill it without copy/pasting manually.

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 3 Screenshot 102

    This article should help:

    https://support.office.com/en-us/article/Fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db

     

    7. Combine both Submission ID and the URL columns to create the download URL, using a formula. Example:

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 4 Screenshot 113

    This article should help: 

    https://support.office.com/en-us/article/Combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6

     

    8. Fill again the entire rows in the third column to create the URL for the others. You can fill it again per step #6.

     

    9. Save the Excel file as HTML:

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 5 Screenshot 124

     

    10. Download this addon for Firefox: https://addons.mozilla.org/en-US/firefox/addon/downthemall.

    11. Open the saved HTML file for combine Submission ID and URL in Firefox.

    12. Download the links using the Addon. Right Click > Downloadthemall:

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 6 Screenshot 135

    13. Select All files and click Start button;

    How can I separate the applications so that they may be judged by a third party panel of judges? Image 7 Screenshot 146

    That's it! Too long steps, but should be easy if you'll have it. The add on will auto save the file. Let me know for questions.

  • aapgfdn
    Replied on April 15, 2016 at 2:59 PM

    Thanks, Welvin! This is really helpful!

    Do I need to be in Firefox to do the above? I typically use Chrome.


    April

  • Welvin Support Team Lead
    Replied on April 15, 2016 at 4:01 PM

    You're welcome.

    Yes, because there's no Chrome version of the download them all firefox addon. 

  • aapgfdn
    Replied on April 15, 2016 at 4:44 PM

    Thanks, Welvin. I've done everything but unfortunately on the last step the DownloadthemAll app is not actually downloading anything. It begins by downloading the first 4 but makes no progress after clicking start. Am I doing something wrong?

  • Welvin Support Team Lead
    Replied on April 15, 2016 at 5:47 PM

    Please zip your saved web page of the exported Excel report and send it to support@jotform.com. Please mention this thread in your email and let us know here so we can check it right away. 

    But when it start downloading, you should see the green bar. Errors are usually in red or orange. 

    Also, if it's urgent, I can get it all for you. Just let me know what form.