Help displaying an Image..

AppSheet AppSheet Q&A
,
1

Hello all..

This is a topic that has come up a number of times, and I have reviewed the other postings but I still can’t get a result. Basically I can’t get a URL which points to a .png file to open in Appsheets. The following are what I think are the relevant factors:

  1. The .png files are located on a Jotforms web location. There is a setting in Jotforms to allow these uploads to be accessed publically, which is set to Yes. I have tested this - I copied a URL to a laptop not known to Jotforms and the file opened (actually the .PNG file downloaded by the browser but I could then open it). I don’t think permissions access is the issue.

  2. The URL is written to Google sheets. It appears that the format is a hyperlink but Google sheets is not too good at telling you how the field is formatted (it’s always set to auto). There is a hyperlink as well as the text that displays I guess (I think the issue might be related here to be honest).

  3. AppSheet thinks that the column is a URL but it is not clickable. I have tried many combinations of changing the field type (Image / Show / URL, even Thumbnail) but I can’t get anything to work. The closest I got was when I took the link for one of the images and pasted that in the formula for a VC to test - it gave me a grey triangle.

I know that this should be possible - I just need to hit on the right combination of settings. There are too many for me to test all exhaustively and still be enthusiastic about life.. !!

Anyone point me in the right direction please? I have read the Appsheet Help “Displaying Images and Documents” and many related Help document so please don’t point me there unless you think I am missing something

Thanks,

RoryF

2

I think this may be the specific issue. The link you have is to download something rather than to display it. If an image is going to appear in AppSheet then I believe it must either be loaded through the app itself and stored in the apps own file location, or it must be viewable at a public address. It doesn’t sound like the Jotforms service is serving up the image in that way.

1 Like
3

Hmm.. Thanks Graham..

It looks like I need to turn my attention to Google Sheets and see if there is some way to get a link to a .png to be resolved to an Image and stored in the Sheet (using a script maybe); I guess I need to jump over to the Google Sheets community..

Thanks for your help,

RoryF

4

I don’t think getting the image to display in Sheets is going to help you. You need to load the image onto something like Google Drive and then make sure it is shared publicly. Alternatively load the image through AppSheet itself.

1 Like