Display images from Google Drive

Follow

Comments

8 comments

  • Avatar
    Pvrmextv (Edited )

    I struggled with getting images to show up and then 10 minutes later they started showing up. (update: now they have disappeared again...something with google?? strange)

    There seems to be some delay, at least for me right now.

    I also noticed that not all shareable links follow the same format as you noted above but I discovered that the https://drive.google.com/file/d/ format never shows my pictures.

    https://drive.google.com/file/d/xyz  - you get this if you click the share button (won't show images for me)

    but if you right click on file select "get shareable link" you get this format which will show my pictures.

    https://drive.google.com/open?id=xyz

    where xyz = unique ID

    While I have your attention...and being new to the NEW Google Sites.

    Can I get the slideshow into the banner?

    thx

  • Avatar
    Randolph Abelardo (Edited )

    Hi Pvrmextv. 

    Using the URL from the get shareable link won't work.

    You could try an alternative solution that's always worked for me. You can see the details here -  https://goo.gl/VfEiW7.

    Here's a post where I replied and shared a live demo using the method shared above in an AwesomeTable SlideShow - https://goo.gl/JenH8Q.

    Note: You cannot insert scripts (SLideShow) inside the New Google Sites' header / banner. This is a limitation on their part.

  • Avatar
    Mahernioio

    Is there an easy and automated way to display an image-gallery with images that got uploaded to Google-Drive by users using the upload-function of a Google-Form, in Awesome-Table?

  • Avatar
    Awesome Table

    Hi Mahernioio,

    You can use a formula in your spreadsheet to retrieve the ID of the image and add it to the URL of the example above.

    Regards,
    Thomas

  • Avatar
    Webmasterppsl

    Hi.. How can i automatically store only the file ID in a column ? 

    Im using Google Forms to store  data.. and generates the complete link to the image.. 

     

    Thanks..

  • Avatar
    Awesome Table (Edited )

    Hi Webmasterppsl,

    Indeed you can get the ID of your image from your Drive with a formula like this in a new column with the ImageType keyword:
    ={"ImageType"; ARRAYFORMULA(Concat("https://drive.google.com/thumbnail?id=", REGEXEXTRACT($G$3:$G,"id=([^&]+)")))}

    You just need to replace the cells concerned with those who have the image uploaded. In this example it the column "G".

    Here is the Awesome Table view connected with a Google Form and here is the spreadsheet with the formula used above. It will be helpful for you request. 

    Kind regards,
    Thomas

  • Avatar
    Si Biggs

    I'am trying to display images that have been added via google forms as a file using Imagetype from my speadsheet onto my Geo map, I have tried various tool tip codes but they just show as a long elongated picture.

    Any ideas please? 

    Thanks

    Simon

     

     

  • Avatar
    Awesome Table

    Hi Si Biggs,

    Would it be possible for you to share your Awesome Table view and your spreadsheet at "support@awesome-table.com"? If you have sensitive data, you can make a copy with similar data. Just make sure to give us access to your data.

    Thanks in advance.

    Thomas