Calculation based on whether a file exists

[Stickybeak]

I am trying to use the Goya FileExists function to produce a boolean result.

I use my database on 2 machines and they are synced using sugarsync.

The point of the boolean calculation is to permit a button to be appear if a PDF file with a given name exists.

I am using the Get(DocumentsPath) to provide the first half of the path.

I get the feeling that the goya function is not recognising the syntax of the result of the Get(DocumentsPath) calculation.

Any ideas?

 

[Wim Decorte]

Back up a little: where would the file (PDF?) be if it existed?  Inside a sugarsync'd folder?  If so that exact folder name would not be in the same exact location on both machines.

[Stickybeak]

Back up a little: where would the file (PDF?) be if it existed?  Inside a sugarsync'd folder?  If so that exact folder name would not be in the same exact location on both machines.

Correct - so what I have is a field that gets the path to documents folder  - the folder heirarchy once inside the documents folder is identical on both machines - if that makes sense.

[OlgerDiekstra]

You can get the foldername using the BE_SelectFolder function. Call it in a test script, and diisplay the result in a dialog. That will show you the exact syntac the BE_FileExist function would need.

[Stickybeak]

got it to work by going to troi file exists - but will try olger's suggestion just to see: warning for all - the format returned by filemaker requires a fair bit of manipulation to make it work