How to generate direct image URLs

AppSheet Tips & Tricks
, ,
1

TEXT([Image])> Put the express in a virtual column with “URL” type.

If you need to store the link itself, you might need to make some changes to the row after the image is uploaded like example below.

3X_8_4_84b2c52e07603fae72f61f00153c9c91dd8c1f07.png

3X_8_4_84a6d62322cd4a50111a1506fda1da9784735d0a.png
3X_8_4_84a6d62322cd4a50111a1506fda1da9784735d0a.png1317×137 7.66 KB

There’s another option to create the image URL
CONCATENATE(
“https://www.appsheet.com/template/gettablefileurl?appName=”,
ENCODEURL(“AppName-AccountID”),
“&tableName=”,
ENCODEURL(“TableName”),
“&fileName=”,
ENCODEURL([ImageColumn])
)
But if you like to share the image file outside of your organization, you will have to to disable “Required Image and File URL Signing” under Security > options . (If you disable the option, a person can theoretically try to read other files by changing file name.)

12 Likes
2

If “Image URL” is a virtual column, it will not work It will just repeat the Image text.

Only when “Image” is written back to the “Image URL” source, the valid URL is generated.

It will be nice the virtual-column image URL will be the valid URL.

1 Like
3

Note that the generated URL is only good for non AppSheet services.

If you try to read the “Image URL” in a virtual column, the column will return the original image name, not the URL.

4

Note that you might have to change & to %26 or wrap it in ENCODEURL(). At least if you use the URL with other services (eg. QR code).

5

this is not Working for me, I get bad request error. the links are generating correctly into a the cells.

What am i doing wrong, Can anyone help please?

6

Finalmente di con la solucion a esto :smiling_face_with_sunglasses: gracias !

7

To generate a public link to the images that have been uploaded to Apsheet, I use a script inside the spreadsheet. I do a search by file name in the folder and write down the public link in the adjacent column. The script is triggered by changes inside the table.

8

Same here

9

Try this :ok_hand:

https://www.youtube.com/watch?v=Ikh2–PoHF8&t=141s

10

@Telecom puedes compartir como lo lograste?

11

Here is an alternative expression, taking advantage of CONTEXT().

CONCATENATE(
“https://www.appsheet.com/template/gettablefileurl?appName=”,
CONTEXT(“AppName”),
“&tableName=”,
Context(“Table”),
“&fileName=”,
ENCODEURL([ImageColumn])
)

2 Likes