Google Sheet Integration - How to make the links of photos go to google drive instead of jotform?

  • Wolfvalley
    Asked on August 3, 2019 at 6:14 PM

    I'm curious how to make the links to my photos go to goolge drive rather than jotform?

    Also, can I remove the "edit link" column that is full of "edit submission" links?  I'd like the form to be reporting to a few people sharing the google sheet, but I'd rather them not have jotform info or see anything with "edit". :) 

  • jherwin
    Replied on August 3, 2019 at 10:22 PM

    Does your form already have submissions? If so, the Edit link will be placed automatically to the spreadsheet when a submission is received. It is not recommended to make any changes to the spreadsheet since it may break the integration and can stop receiving the submissions to the spreadsheet. As a workaround, you may hide the Edit link column in the spreadsheet.

    However, if it's newly created form and you are still not receiving submissions to it, then you can delete the "Edit Link and Upload" columns in the spreadsheet. You can then integrate your form to google drive to receive the uploaded images to your form. I've tried this option and it works. However, if it already has submissions and you delete a column in the spreadsheet, it will stop updating the sheets and it will break the integration.

    Please make sure your form is newly integrated into the spreadsheet before you apply it.

    Related Guides:

    How-to-Integrate-Forms-with-Google-Sheets

    How-to-Integrate-a-Form-with-Google-Drive

  • jherwin
    Replied on August 3, 2019 at 10:27 PM

    In addition, if your plan is to direct the upload to your google drive so that you do not reach the upload space limit for your account, unfortunately, that's not possible. The file uploaded to your form will go directly to the submission page before it transfers to your google drive. Therefore, the upload will still remain in Jotform.

  • Wolfvalley
    Replied on August 3, 2019 at 10:31 PM

    Okay, the thing is when my form takes photos, I'd like the link to the photo that is sent to sheets to be a "google drive" link, not a jotform.   I like the permissions on google drive to the files stored there.

  • jherwin
    Replied on August 4, 2019 at 3:17 AM

    Sorry, but we only have direct integration with google drive that uploads the uploaded file to your form directly to google drive. The form/spreadsheet cannot pull the image link to your google drive.

    What you want is achievable using Upload care widget, perhaps that could work for you?

    Guide: https://www.jotform.com/blog/uploadcare-widget/