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.
The name of the file isn't set/known until the data-change is saved. At which point, any expressions have already been evaluated on the blank/unknown value, and won't change until you force them to evaluate again.
Just the other day I set up a Bot that sends the gettablefileurl link immediately after an Add, and it evaluated correctly. So I'd suggest setting up a Bot that runs on adds/updates for this Table, that will set the URL value to the column, instead of setting it via an App Formula.
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.
Thanks. It works ๐
Muchas gracias mi noble Marc Dillon. Que seas muy feliz en todo en la vida!!
Did you by chance find a step-by-step guide or instructions to explain this process in detail? I would like to duplicate this URL link in the created row.
Thank you,
Drew
A step by step process would be nice
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |