how to make images in my Google sheet to show up in an app?

Answered

Follow

Ketevan Eliashvili

January 24, 2019 07:38

Hi all,

I'm trying to test out openasapp and created a demo 5 raw table Google Sheet. It contains  basic information about people such as name, phone number and their profile photos.

I would like to make an app where the images of the employees will show up next to their personal information. My problem is that images in the Google Sheet don't transfer to the app, however in Google Sheets to import images in cells I've used the code =IMAGE("imageURL",2).

I don't get what I am doing wrong, could anyone help me? 

Thanks in advance,
KE

 

0

• Official comment

  

  Damian Roller January 24, 2019 15:04 (Edited November 24, 2020 13:34)

  Hey Ketevan,

   

  thank you for getting in touch. Showing images of the employees next to their personal information is something that can definitely be done with Open as App.

   

  The element you have to work with is the "List". You will find a detailed tutorial here: https://support.openasapp.com/hc/en-us/articles/207918675

  After creating the list you can select "Cards with Thumbnail" as your list type:

  

  If you want to display the images in your list, you have to make sure that the urls of the images are contained in your sheet. I suggest checking out this tutorial: https://support.openasapp.com/hc/en-us/articles/209875245

   

  I'm not sure how the data looks like in your spreadsheet but basically we need a column with urls like https://www.dropbox.com/s/a1b2c3d4ef5gh6/example.jpg?dl=1

  The url must point directly to a publicly available file.

   

  Hope that will help you creating the app.

  Best regards

  Damian

   

  Comment actions Permalink

Please sign in to leave a comment.