Show url link from file name

[baba_sawane]

Hi everyone !

I have multiples files that can be updated/added in a column. What I want for the user is to be able to see the link of the file. 

The files are generated from an automation and i'm using a column named [ReportName] for files names. My actual goal is to generate a link from a formula, that will change everytime my [ReportName] update.

This is the formula i'm using to create the link : 

When i open the link in the spreadsheet, i'm getting a "Bad request" error

Anyone have tips to fix this please ?

Show More

CONCATENATE(‘https://www.appsheet.com/template/gettablefileurl?AppName=’,

ENCODEURL(CONTEXT(AppName)), ‘&tableName=’, ENCODEURL(CONTEXT(Table)), ‘&fileName=’,

ENCODEURL([ReportName]))