Convert URL to image

[Bulubulu]

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 ?

[dbaum]

---

@Bulubulu wrote:

I tried to create a column of type URL to fill a virtual column of type show (image)

---

That's what I would have tried too.

---

@Bulubulu wrote:

I tried different formulas

---

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

[Bulubulu]

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.

[dbaum]

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.

[Bulubulu · Accepted solution]

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])

[Kabuliño]

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%>"