Solved: Cannot Get Images To Display - Page 2

jinjok · 10-17-2019 09:15 PM

Hi all,

I have a database hosted on Google Cloud - Google Mysql. It is all linked to Appsheet fine.

In the Db, I have a table that has images in one of the columns. The column is set to a LONGBLOB type and the image URL is stored in the table.

The images are stored on a separate server (see link below) and when you open the link in a browser it works fine.

When I connect APPSHEET to the table I set the column which contains the URL to image type but nothing will be displayed. All i get is the triangle with an exclamation mark.

I’ve tried setting the row as a “show” type also and placed the URL in the content source but again nothing works. I followed the online documentation and according to that, it should display fine.

Any help, please? I’m going crazy

jinjok

OK Solved it!!!

It turns out to be the database field type which is set in the MySQL database. Originally the field type was set to LONGBLOB which i thought was the correct type for storing images. I have now changed it to TEXT type instead.

I then set the image_url field in Appsheet to Image and VIOLA! the image appears where it should.

Thank you Kirk for all your help. I can now sleep at night.

View solution in original post