Image URL returns as a 404 error when opening on google sheets

[R_D_Engineering]

When I take a picture using the app, it returns the image to my google sheet as an image address. I followed the formula SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“Imagesinsheets-71626”,"&tableName=”, “Data”,"&fileName=",RC[-1]), " ", “%20”) and was able to convert the image address to a URL address. However it does not display my image in the sheets. and clicking on the URL opens up a new tab and then displays a 404 error.

I am new to the image side of things on Appsheet and was wondering if someone can help.

Greatly appreciated.

Thanks

[Apps_Tracklink]

I’m having the same problem. I’m using the following formular on a url column in my app:

CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“merchApp-1517199”), “&tableName=”, ENCODEURL(“E ADICIONAL”), “&fileName=”, ENCODEURL(CONCATENATE(+F,[_ROWNUMBER])))

I don’t know what’s wrong. I’m following all the instructions detailed here: Displaying Images and Documents | AppSheet Help Center

Please help!

[Koichi_Tsuji]

Apps_Tracklink:

ENCODEURL(CONCATENATE(+F,[_ROWNUMBER]))

We usually pass the column for image on the table, so not sure why you are passing such strings for image file name.

[Apps_Tracklink]

I’m right now at the point of trying nonsense trial and error. I tried this now:

CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“merchApp-1517199”), “&tableName=”, ENCODEURL(“E ADICIONAL”), “&fileName=”, ENCODEURL([FOTO]))

Where [FOTO] is just that, the column for the image on the table. But I’m still getting a bad request error. Any ideas?

This is how the links looks like on the spreadsheet after I capture a photo with my phone:

Appreciate the help!

[Koichi_Tsuji]

It could be possible that the app sheet is generating the URL BEFORE the image file path/file name data is being captured on the backend. Thats why your URL string does not have fineName values.

you need to place workflow with action to update each row once the new row is added and also value in FOTO row is changed.

[Koichi_Tsuji]

You have Date Time field already, so this should be the easiest set-ups.

Generate the action
Update column of Date TIme, by passing NOW() Expression.

Then fire this action once the new row is added from the workflow.

Once the new row is added, meaning the one photo is taken and saved, the datetime value will be refreshed by the action and workflow, which is triggering the re-evaluation of your appformual for IMAGE field automatically.

There will be a bit of time lags until you see the final string as this is backend service, but it will achieve what you want at least.

[Apps_Tracklink]

Thanks for your help! I just got it to work!