Image URL Bad Request Showing

[Sirfyaad]

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.

[SkrOYC]

Try using:

TEXT([Upload of Receipt])

[Sirfyaad]

---

@SkrOYC wrote:

TEXT([Upload of Receipt])

not working here. 

[SEUAdmin]

Remove both "Context" words from expression, that worked for me, after spending a whole day wondering why it would not work

Remove what's on red

CONCATENATE(

"https://www.appsheet.com/template/gettablefileurl",

"?appName=", ENCODEURL(CONTEXT("AppName")),

"&tableName=", ENCODEURL(CONTEXT("Table")),

"&fileName=", ENCODEURL([Image Column])
)

[Sirfyaad]

Hi @SEUAdmin @Koichi_Tsuji  Thank You For reply me,

The link is getting generated but the text of image column is not showing in this link.

Image column is not being included in this link.

Initial Value formula for column IMAGE LINK (Url)

CONCATENATE(
"https://www.appsheet.com/template/gettablefileurl",
"?appName=", ENCODEURL("ClaimFile7687765"),
"&tableName=", ENCODEURL("ShelfImage"),
"&fileName=", ENCODEURL([IMAGE])
)

The concatenation of all these text values (
...."https://www.appsheet.com/template/gettablefileurl"
...."?appName="
....ENCODEURL(
........"ClaimFile7687765")
...."&tableName="
....ENCODEURL(
........"ShelfImage")
...."&fileName="
....ENCODEURL(
........The value of column 'IMAGE')

Image Table

Image Table

[Sirfyaad]

Hi please help me @Koichi_Tsuji @SkrOYC @SEUAdmin 

[Koichi_Tsuji]

The expression of : -

CONCATENATE('https://www.appsheet.com/template/gettablefileurl?appName=', ENCODEURL(CONTEXT(AppName)), '&tableName=', ENCODEURL(CONTEXT(Table)), '&fileName=', ENCODEURL( [IMAGE]))

should work.

The problem you possibly face now is the image path is not generated when you save the new form.  Try it out to open the same form view after you newly created. As far as you pass this expression to App Formula (instead of initial value) the full path should be propertly created and saved to the backend spreadsheet.

To make this process automated, add new normal column to your sheet, such as [Trigger] and let the initial value as 0.

Make action to increment this column, [Trigger] +1

Set this action to be fired on saving the same form view.

[Koichi_Tsuji]

you probably need to re-open the form view and save. Then the correct URL would be generated out of your expression.