Convert URL to image

AppSheet AppSheet Q&A
,
1

Hi,

How to make in a form to fill an image type column with a URL instead of the local file browser?

Not finding how to do it just from a column of type image, I tried to create a column of type URL to fill a virtual column of type show (image). I tried different formulas, but I can’t convert the url to image.

Could you please help me ?

2

That’s what I would have tried too.

If you didn’t already, maybe fiddle with including HYPERLINK() – or even LINK(HYPERLINK()) – somewhere in the mix.

3

I don’t know if it is what you are looking for but try using a Longtext type column with HTML format and use in the formula:

"<img src=' "&[URL]&" ' width=100%>"
4

THANKS ! I do not know how. It seems to me that these functions would be rather useful for the reverse operation (converting an image to a URL). What I’m looking for would rather be an equivalent of the IMAGE() function in Google Sheets.

5

Yes, I agree. Given that you already tried what seemed most logical to both you and me, my suggestion was to experiment with an alternate approach.

6

I found a very simple solution:

  • I used a URL type column named [PictureURL] which is only displayed in forms.

  • Then I created a column of type show (image) using this very simple formula:

TEXT([PictureURL])