Adding PDF link in the Google Spreadsheet integration?

  • mflanagan
    Asked on August 20, 2015 at 3: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?
  • Charlie
    Replied on August 20, 2015 at 3:46 PM

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

    However, you can attach it on the email notification.

    Adding PDF link in the Google Spreadsheet integration? Image 1 Screenshot 50

     

    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.

    Adding PDF link in the Google Spreadsheet integration? Image 2 Screenshot 61

    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.

    Adding PDF link in the Google Spreadsheet integration? Image 3 Screenshot 72

    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.

    Adding PDF link in the Google Spreadsheet integration? Image 4 Screenshot 83

     

    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.

     

  • mflanagan
    Replied on August 20, 2015 at 3:56 PM

    This is GREAT!  Thank you so much!

  • Charlie
    Replied on August 20, 2015 at 5: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.