Upload and display images from Google Drive with Google Form

Comments

6 comments

  • Hi Thomas, 
    I'm trying this from a Gsuite account but unfortunately I get an error message. 

    I know it's not on the formula as I've tried it on another table (personal Gmail account) and it works well. 
    Any clue why am I getting this error message?
    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Thomas Morin

    Hello,

    It seems there is an error in your formula.

    Your formula should be:
    ={"ImageType"; ARRAYFORMULA((IF(ISBLANK(H3:H), "",ARRAYFORMULA(Concat("https://drive.google.com/thumbnail?id=", REGEXEXTRACT($H$3:$H,"id=([^&]+)"))))))}
    instead of
    ={"ImageType"; ARRAYFORMULA((IF(ISBLANK(H3:H), "",ARRAYFORMULA(Concat("https://drive.google.com/thumbnail?id=", REGEXEXTRACT($H$H:$F,"id=([^&]+)"))))))}

    Moreover, if you use this formula with a Gsuite account and you want to share your images in your domain intranet or your images are only shared with anyone within your domain, you should use "https://drive.google.com/a/domain.com/thumbnail?id=" as an URL in your formula as it is explained in your article.

    Kind regards.

    Thomas

    0
    Comment actions Permalink
  • Thanks for your quick answer Thomas!
    I have corrected the formula and still get the error message. What's weird is that I've tried the same formula on a different Awesome Table that I have (with my private Gmail account instead of Gsuite) and the formula works. 
    I will answer to an e-mail from your support see if you can take a look to the spreadsheet ;)
    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Eugene Petersen

    GREAT stuff Thomas. Thank you for taking the time to explain the various use cases as well as all of the subsequent details. The tips in this post are PRICELESS!  Our team of developers applauds your efforts. thanks again and be well:)

    0
    Comment actions Permalink
  • Avatar
    Thomas Morin

    Hello Info Tips de Marketing Digital,

    Thank you for creating a ticket to solve your issue.

    Kind regards.

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Thomas Morin

    Hello Eugene Petersen,

    Thank you very much for your message.
    It's a great satisfaction for us. :)

    Kind regards.

    Thomas

    0
    Comment actions Permalink

Please sign in to leave a comment.