Have the link to the drive file instead of the upload link

  • moduli471
    Asked on March 1, 2021 at 4:31 AM
    I connect the form upload files with drive. OK.

    But it would be nice to have (in the drive sheet) the link to the drive file instead to the download link of jotform. Is this possible? with this arrengement i can see the file upload by te user that complete the form with a preview, also is fast to open, i dont have to download, and duplicate files...

    Many Thanks and best regards,

    Manuel.

  • Sam_G
    Replied on March 1, 2021 at 4:43 AM

    Hi Manuel,

    Unfortunately, the link to uploaded files would be in Jotform.

    Currently, google sheet links are from the submission uploads.

    We do have a guide that will help you integrate your form into your Google Drive. Please check this link: https://www.jotform.com/help/192-How-to-Integrate-a-Form-with-Google-Drive.

    If you have any questions, let us know. Thank you.

  • moduli471
    Replied on March 1, 2021 at 5:07 AM

    Hi Sam,

    Thanks.

    Unfortunately, the link to uploaded files would be in Jotform. OK, i see, no problem with this.

    I make the integration with google drive, to store all there. But if i want to see the document from jotform link, i must first download.. so at the end i am making 3 files of the same: 1 in jotform, 1 in drive and 1 in my pc.

    My question is: There is method to convert this link:

    1614593146 603cbc7a9b940  Screenshot 10

    to a drive link of the file... Meaning; when you create the google drive folder, you can "copy" the link and inform me that one, or both?


  • Sam_G
    Replied on March 1, 2021 at 6:50 AM

    Hi Manuel,

    Once you integrate it to Google Drive it would show all the files uploaded.

    1614598784 603cd2804d60b  Screenshot 10

    Related guide: https://www.jotform.com/help/192-how-to-integrate-a-form-with-google-drive

  • moduli471
    Replied on March 1, 2021 at 7:04 AM

    Hi Sam.

    Thanks. Yes I understand that.

    What i am asking is:

    1. when somebody upload 1 file(we will call it file X) , in the google sheet, you provide me a link to this file. This link is from Jotform.com No problem with that, but if i want to see the file, i must download. An also, i already conect files with Drive. So at the end: We have 1 file X in jotfrom, 1 file X in drive and 1 file X in my pc because i must download. So we have 3 files, that are the same.

    IF instead of inform me the link (in the google sheet) of jotform, you inform me the drive link i dont need to download...

    and also, when in google sheets you have a link of drive, you can see a preview. Very usefull.

    Best Regards,

    Manuel

  • Lorenz JotForm Support
    Replied on March 1, 2021 at 8:46 AM

    Greetings,

    There's actually an option in the JotForm table to change the view to uploads, which allows you to quickly preview the uploads.

    Here's a guide: https://www.jotform.com/help/1005-how-to-add-an-uploads-view-in-jotform-tables

    IF instead of inform me the link (in the google sheet) of jotform, you inform me the drive link i dont need to download.

    I'm quite not sure what you meant by this, can you please elaborate? Do you mean to show the drive's link to Google Sheet instead of the upload link from JotForm? If so, that is not possible. If you are referring to something else, kindly please provide us more details.

    We will wait for your response.

  • moduli471
    Replied on March 1, 2021 at 9:18 AM

    Hi lorenz,

    When somebody use my form and upload a file. When i go to the google sheet, i saw the link of that file. That link is a link to jotform. and when i click, i muts donwload to see the image.


    If instead: you inform me the link of drive to same file (i already have made the integration with drive); i can avoid downloading (time + local space)

    for example:

    Somebody complete a form and upload a foto.

    This is how i see in google sheet the link:

    1614607294 603cf3bed19e5  Screenshot 10

    here the link so you can see:

    https://www.jotform.com/uploads/moduli471/210554006581044/4902220262746089738/274862A_1592360_png_zoom_5.jpg

    but also, as i already make integration of Jotform with drive; the photo is in drive: under this link:

    https://drive.google.com/file/d/1Jya4NziOhuImM53fajYt2dTu5tFBagsg/view?usp=sharing

    1614608119 603cf6f7ec7a4  Screenshot 21

    SO, my question is:

    In the google sheet, were i see all the forms that people complete, can you show me the drive link of the documents instead the jotform link?


  • Jovanne JotForm Support
    Replied on March 1, 2021 at 10:18 AM

    Hi,

    There is a preview of the image because a copy of the image file was uploaded to your Google Drive. The file source is now on your Drive. However, on the Google Sheet integration, a file is saved on JotForm's server, so the source link is sent to the sheet.

    I'm afraid that it is not possible to change the file source link from your Google Drive in the Google Sheet integration.

    Let us know if you have further questions.