Envoyer le lien PDF de soumission à l'intégration Google Sheets

  • Autaa
    Demandé le 19 février 2025 à 04:16

    Bonjour

    J'aimerais obtenir un lien dans google sheets du PDF.

    J'ai testé cette formule ="https://www.jotform.com/pdf-submission/"&R3

    Le problème est que le PDF s'ouvre bien mais je n'ai pas les réponses. Le document est vierge


    Voici un exemple

    https://www.jotform.com/pdf-submission/6157629206918709171


    Je pense que je dois modifier des paramètre pour rendre "public" les réponses mais je ne trouve pas ou

  • Shane Jotform Support
    Répondu le 19 février 2025 à 08:53

    Hi Autaa,

    Thanks for reaching out to Jotform Support. Our French Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in French, let us know and we can have them do that. But, it might take a while until they're available again.

    Now, coming back to your question, can you try changing the Share Settings of your Submissions Table to Public? Here's how:

    1. In Submissions Table, click on the Share button.
    2. From the pop-up, click on Share Settings.

    Envoyer le lien PDF de soumission à lintégration Google Sheets Image 1 Screenshot 30

    3. Select Public Table from the list.

    Envoyer le lien PDF de soumission à lintégration Google Sheets Image 2 Screenshot 41
    We also have a guide about How to Share Your Submission Tables with Jotform Tables and Collaborate that you can check out.

    Give it a try and let us know if you need any help.

  • Autaa
    Répondu le 20 février 2025 à 02:45

    Bonjour


    J'ai modifié mais le problème n'est pas résolu.

    Les PDF sont toujours vierge (sans réponse)


    Envoyer le lien PDF de soumission à lintégration Google Sheets Image 1 Screenshot 20

  • Chris_L Jotform Support
    Répondu le 20 février 2025 à 08:44

    Hi Autaa,

    I see that your form is integrated with Google Sheets. If I understood what you’re asking, you'd like to send the submission PDF link to the Google Sheets. You can do that by adding two Short Text fields in your form and add default value on each Short Text field. I'll walk you through setting that up:

    1. In Form Builder, select the first Short Text field and click on the Gear icon.
    2. Under the Advanced tab, set as a default value.Jotform Tables: Add submission PDF link  Image 1 Screenshot 30 Screenshot 20

    Here's the default value for first Short Text:

    https://www.jotform.com/server.php?action=getSubmissionPDF&sid=

    Here's the default value for second Short Text:

    &formID=250491365518056

    To get the PDF links, enter this formula to the Google Sheets column:

    =First part of the short text + Submission ID + Second part of the short text field

    Check out the screencast below to see how it's done:

    Envoyer le lien PDF de soumission à lintégration Google Sheets Image 1 Screenshot 31

    Like what you see in screencast, the link to the submission PDF was created as soon as the formula is created.

    Give it a try and let us know how it goes.

Votre réponse