File Path Calculation

[James Gill]

I'm trying to find a way to set a file path for a script that is dependent upon current date, month, and year. The script would eventually save PDF's into this folder automatically.

The file path I am trying to replicate is "/2010-Exams and Reports/6-June 2010 Reports/1 - Report Preparation/"

Of course, I want the year and month to always be up-to-date. Basically, the syntax would look like /(CurrentYear) & " - Exams and Reports/"(numeric number of month) & "-"(Name of month)& " " (Current Year)& " Reports/ 1 - Report Preparation/"

Of course, there are no functions to get the current number of month or year that I'm aware of, but if somebody could shine some led on this issue that would be appreciated.

edit: Also, since I just realized that this is going to be an issue; How can I create files on a network share? Is there a way to do this through Filemaker directly or am I going to have to use Applescript commands?

Edited June 3, 2010 by Guest

[bruceR]

"Of course, there are no functions to get the current number of month or year that I'm aware of..."

Sometimes it's a good idea to read FileMaker help first:

http://fmhelp.filemaker.com/fmphelp_10/en/html/func_ref1.31.12.html#1028277

[James Gill]

Well that's good to know, it takes care of my first problem

Now, on to the second. Is Applescript the only way that I'm going to be able to tell Filemaker to save something to a network fileserver?

[Fenton]

Export commands (including Export Field Contents and Save As PDF) can write to an external volume, if mounted.

[James Gill]

Are there some special file path syntax commands that have to be used that I'm not aware of?

I just tried to create a folder on my desktop, titled exactly the same as my alias folder, and I can save to it. I then made an alias folder on my desktop to the sharepoint, and it gives me the same error.

[James Gill]

Fixed my issue. Had to take out the "/Volumes/" part of my path to make it work.