Problem with File and Concatenate

[B18ANU]

Hi,

I`m currently running in some trouble with the Column Type - File and Concatenate() function.
I have two tables and im trying to copy/insert the [Invoice File] column from table A in to table B. Invoice file holds a pdf thats stored in “Documents/Invoices/Example.pdf”

Case A :
If i use TableB[Invoice File] = TableA[Invoice File] i get : " Example.pdf "
This throws an error in the app because the path of the file is not defined, just the name.

Case B :
If i use Concatenate(“Documents/Invoices/”,TableA[Invoice File]) i get : “Documents/Invoices/https://www.appsheet.com/template/gettablefileurl?appName…”
When i click the link it takes me to the right file but because the path is in front of it it does not work in app.

Case C :
If i use Concatenate(TableA[Invoice File], “a”, “b”, “c”) i just get “Example.pdf”

How do i get the proper path set in table B from cell in table A ?

[WillowMobileSys]

B18ANU:

How do i get the proper path set in table B from cell in table A ?

I am not sure this will work but try this:

Concatenate(“Documents/Invoices/”, TEXT(TableA[Invoice File]))

By the way, this…

B18ANU:

If i use Concatenate(“Documents/Invoices/”,TableA[Invoice File]) i get : “Documents/Invoices/https://www.appsheet.com/template/gettablefileurl?appName…”

…seems like a bug to me. I would think the URL portion would only be constructed during operations that are attempting to physically display the file. During usage within an expression we should always expect to see the value saved in the datasource.

[B18ANU]

I have tried wrapping [Invoice File] with TEXT() but the restul is the same link as in case b.