Image URL

Hello good mornig for everyone!
I don't see a way for that to work for me:

I want that simply when uploading an image in an Appsheet form, the URL of the image is inserted. And not the Google Drive address.

Use:

if(
isnotblank([Upload of Receipt]),
CONCATENATE(
"https://www.appsheet.com/template/gettablefileurl",
"?appName=", ENCODEURL(CONTEXT("AppName")),
"&tableName=", ENCODEURL(CONTEXT("Table")),
"&fileName=", ENCODEURL([Upload the Receipt])),
"")

It turns out that the result in the cell is that:
https://www.appsheet.com/template/gettablefileurl?appName=System-00000001&tableName=D%C3%8&fileName=

OBS.: I DO NOT GET THE NAME OF THE ARCHIVE CONCATENATED TO THE URL. I always have to edit the form once for the link to update.

QUESTION: Is there a more professional way to do that for large volumes of data? Thank you!!

Solved Solved
0 7 782
1 ACCEPTED SOLUTION

You either:

1. Create a new Action to push some meaningless data change to the record to force it to re-evaluate all App Formulas. Run that Action from the Bot.

2. Create a new Action to set the URL, with your above expression, and run that Action from the Bot.

View solution in original post

7 REPLIES 7
Top Labels in this Space