How can I import my generated PDF forms into google sheets as hyperlinks?

  • Profile Image
    strykerssp
    Asked on June 05, 2017 at 04:33 AM

    Hi there, 

     

    Would love some help here.... How can I import all my final Jotform submissions (PDF) into my online google sheet?

    Is it possible to view all the PDF hyperlinks in my master google sheet like 'google forms "form publisher"' or is there a work around for this?

     

    Kind regards,

     

    Eddie :-) 

  • Profile Image
    Nik_C
    Answered on June 05, 2017 at 05:00 AM

    Just to be on the same page, you would like to have a column in the sheet where when you click on a hyperlink in each cell a submission will open?

    That is doable, in the spreadsheet itself, if you could tell us which form and submissions you would like to have in the spreadsheet, we could make that for you.

    On the other hand, if you want to have PDF opened when a hyperlink is clicked then that will require creating PDF of each submission and upload it to some online drive and creating a hyperlink to that file.

    Please let us know how would you like to proceed so we can assist you.

    Thank you!

     

  • Profile Image
    strykerssp
    Answered on June 06, 2017 at 05:00 AM

    Hi Nik! 

    Thanks for the prompt response! I think I'm after the latter? I'd like to set-up a column in the spreadsheet that has a hyperlink directly to the form submissions PDF! I have a Google drive etc, with a folder that all submissions have been going too. Is it possible to automate this process or does it have to be done manually? 

    Thanks for all the help! 

    Eddie 

  • Profile Image
    Nik_C
    Answered on June 06, 2017 at 06:23 AM

    Unfortunately, I don't see an automatic way of doing that. The only way would be to manually insert the links to PDFs in Google Drive since you can not predict the URL and therefore create an automatic way of creating them.

    The only automatic way of doing this I see in creating Edit links in spreadsheet that will open each submission in edit mode, like this:

    And that is doable since we know how the link will be created:

    https://eu.jotform.com/edit/3725531410518507145

    And we can create that for each submission.

    You could even make all fields read-only when the submission si edited. 

    You could even hide the Submit button by using that condition.

    If that could work for you please let us know so we can assist you further. 

    Thank you!