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! Go to 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.
User | Count |
---|---|
16 | |
12 | |
9 | |
4 | |
2 |