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.
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.)
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.
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.
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).
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?
Same here
Finalmente di con la solucion a esto ๐ gracias !
@Telecom puedes compartir como lo lograste?
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.