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

  • Profile Image
    Wolfvalley
    Asked on August 03, 2019 at 06: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". :) 

  • Profile Image
    jherwin
    Answered on August 03, 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

  • Profile Image
    jherwin
    Answered on August 03, 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.

  • Profile Image
    Wolfvalley
    Answered on August 03, 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.

  • Profile Image
    jherwin
    Answered on August 04, 2019 at 03: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/