Jump to content
Sign in to follow this  
Stickybeak

Calculation based on whether a file exists

Recommended Posts

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?

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.