Script not working

[Makangsi]

Hello everybody,

I am trying to write a script to retrieve a pdf file from an external drive.

I am trying to use this command:

"file:/Users/alfredomarques/Desktop/Databases/PDF/" & Document Control::Document & ".pdf"

This not working and says that the file cannot be found. Even using filemac it doesn't work.

 

Any help on it, please?

 

Thank you very much in advance

[Steve Martino]

Are you sure you need the first two sets of quotes?

[Makangsi]

Yes. Or else it says Table not found. 
 

Thank you very much anyway!

[comment]

On 7/19/2021 at 11:00 AM, Makangsi said:

write a script to retrieve a pdf file from an external drive.

I am not sure what exactly "retrieve a pdf file" means. Also, a path that goes through a user's desktop does not seem to be on an external drive?

Anyway, the simple way to solve this is to insert the file into a container field (as reference only) and compare the resulting path with the path created by your calculation. Then, I suspect, you will discover that the path created by Filemaker has the drive's name before the /Users location step.

Note also that Filemaker has a function that returns the path to the desktop folder of the current user. If that's what you need in your situation, you could make your task simpler by making your calculation =

Get(DesktopPath) & "Databases/PDF/" &  Document Control::Document & ".pdf"

 

Edited July 20, 2021 by comment

[comment]

4 hours ago, Steve Martino said:

Are you sure you need the first two sets of quotes?

Huh?