Below is the action formula that I used to create the URL. It works but somehow the image cannot open and display the error message.
Formula: Concatenate(“https://www.appsheet.com/template/gettablefileurl?”,
“appname=”,encodeurl(“FMKKD4G9Home-66200218”),
“&tableName=”,encodeurl(“Engineer Team”),
“&filename=”,encodeurl([Image])
)
Error message:
Error retrieving file 'AFMI Team_Images/1.Image.042507.jpg': URL has an invalid signature.
The column type also I changed to URL already. Not sure what is the issue here since I did not see the wrong step I did.
1 Like
Hi Nadhirah,
You are trying to construct an URL to your drive File while having the URL sign-in option enabled. This option is creating a temporary signature in the URL of each of your files, and changes it every 5 minutes, as a security mean. This is why you can’t construct your URL with this enabled.
- If your files are created through appsheet and you want to keep this security feature, you’ll have to show to users a File type column :
Replace your URL column to type File, and replace formula into :
CONCATENATE(“AppSheet/data/appname/filefolder/”,[Invoice Number],“.pdf”)
- If you do not care about URL signature (knowing that anyone with the file URL can access your files), just disable it.
Hope it helps !
1 Like
Thanks for the help but I did the same thing but only using different worksheet and it works fine. That is why I am at lost as to why it shows the error. I try again using text and it works but that doesn’t enable the automation since we must edited it first. Hmm im so lost about this
Your welcome! Do you mean that what I suggested works or the file opening works on another app ?
I try again using text and it works but that doesn’t enable the automation since we must edited it first. Hmm im so lost about this
Can you provided further explanation on what is happening/ what you want to achieve ?
It turns out I disable the wrong button instead of the button you show lol. Thank you so much! Have a good dayy 
1 Like
