Upload and display images from Google Drive with Google Form

Comments

2 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!

  • 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

Please sign in to leave a comment.