Adding PDF link in the Google Spreadsheet integration?

  • Profile Image
    mflanagan
    Asked on August 20, 2015 at 03:06 PM
    I am wondering if you can have the PDF link in the google sheet with the submission data.  For example, add a column that has a clickable PDF link to the entry. Is this possible?
  • Profile Image
    Charlie
    Answered on August 20, 2015 at 03:46 PM

    Unfortunately, it is not possible to transfer it in the Google Spreadsheet integration.

    However, you can attach it on the email notification.

     

    However, it is possible by manually concatenating 3 parts of the PDF link.

    Here's an example of the pdf link of my form:

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

    Blue highlight: 1st part

    Green highlight: 2nd part

    Yellow highlight: 3rd part

    1. Now in my form, I will create two text boxes where the default value is the "1st part" and "3rd part" of the link.

    2. Now I will integrate it to Google Spreadsheet. In my spreadsheet, I now have 1st part, 3rd part and the Submission ID will be the 2nd part.

    3. In the end of the spreadsheet, I added a column "PDF Link", it will be the combination of all the PDF parts.

    To concatenate, you just need to reference the rows, here's an example shown above:

    =E2&H2&F2

     

    4. To apply that formula to all of your rows and submissions, you can simple drag the one with the formula.

     

    5. You'll now see that we have a complete PDF link in the spreadsheet. It should be automated when a new submission has been received.

     

    I hope that helps.

     

  • Profile Image
    mflanagan
    Answered on August 20, 2015 at 03:56 PM

    This is GREAT!  Thank you so much!

  • Profile Image
    Charlie
    Answered on August 20, 2015 at 05:03 PM

    Glad to hear that it helped. Should you need more assistance on the workaround, please do let us know.

    Just an added information, this is what the parts are referencing to:

    Blue highlight: 1st part - the domain and default URL format to get the PDF submission for the specific form, try making a test submission and check how your PDF link looks like in your form.

    Green highlight: 2nd part - this is the submission ID, each submission is unique, we can get it directly in the spreadsheet.

    Yellow highlight: 3rd part - this is the Form ID, you need to get your own Form ID, you can find it in your form's URL.

     

    For other concerns or questions, feel free to open a new thread here in the forum.

    Thank you.