Thanks for the link - I guess I'm just slow because the page is a bit overwhelming and I've tried many variation of whats on there, but i need a very precise answer to overcome my personal confusion on the topic. I'm not super familiar with any of the variation they mention on that page and I must be mixing up some of these terms. Help!
Here's my latest attempts:
Users should have the ability to run a report and save it as a .PDF file to their desktop. For the saved .PDF file, the user's account name and current date will comprise the file name. For this task, these Get functions may prove useful:
· Get ( DesktopPath ) - This function will reference the current user's Desktop path which I will need as the location to save the .PDF file
Set Variable [ $path; Value:Get ( DesktopPath ) & "ﬁlename.txt" ]
The above is the best solution, I think. The following was what I was replying before I remembered the Get (DesktopPath) Function...
I would suggest setting up a simple database for testing and begin with the basics.
ComputerType - Macintosh
HarddriveName - Macintosh OS
UserFolderName - Users
UserName - George
PDFFolderName - PDFs
PDFFolderLocation - MacHD - Desktop of Current User
PDFFolderLocationPath - Macintosh OS/Users/George/Desktop/PDFs
ApplicationsFolderName - Applications
FMPProgramFolderName - FileMakerPro
DatabaseName - PathTesting
DBLocationFolder - FilmakerPro Folder in Applications Folder on Mac Hard Drive
DBLocationPath - Macintosh/Applications/FilemakerPro
Filemaker Path to put PDF in PDFs Folder --- [Absolute Path - everything must be named and spelled correctly]
IF THERE IS a space after the hard drive name that must be included or it will fail
Filemaker Path to put PDF in same Folder as Database (FilemakerPro Folder) --- [Relative Path - relative to database location]
Filemaker Path to put PDF in a PDFs folder in same Folder as Database (FilemakerPro Folder) --- [Relative Path - relative to database location]
If both computers have the same hard drive name, and the other hard drive is mounted, confusion is possible. I think.
If you stored the PDF in a PDFs folder in the same location as the database, the path is simple and less prone to error.
This would require that the folder on your computer in the FilemakerPro folder in the Applications folder on your hard drive be mounted by your assistant
Are you trying to use a global variable, '$Jobs:: ' etc to build up a field reference? I don't think you can do that...
I would try binning all the calculation and variable parameters, and saving the file as a text expression to where you want it to go, say:
If that doesn't work: stop. If it does work, swop one bit for a $Variable, like the report name. If that works, swop another bit for a calculation, like the Desktop Path.
At each debug attempt I would put in a Custom Dialogue that shows what the proposed pathname will be. You can then check that against what you expected. A lot of us have been there.
Thank you so much for your patience - I clearly need to get FileMaker for Dummies - this is challenging for me.
I am working with the "Specify Output File" window., under the "Save Record as PDF" script to write this out.
Set Variable [ $path; Value:Get ( DesktopPath ) & "ﬁlename.txt" ] << This gives me then the error that says "There's a problem with one of the file paths in the list. Please correct the syntax..."
All I want to do I save the PDF to my desktop, named as "JobID.pdf" (Job ID being the records' #) - and then I want that same function to work when my assistant opens filemaker on her machine. The actual filemaker database sits on a server. Seems it would be so easy! :)
Holy cow! I did it!!! I'm beeming with pride! :-) Thank you so much everyone!
For anyone else finding this thread later, I wanted to take an opportunity to explain what I did in completely novice terms.
I have never worked with the Control function command "Set Variable" - I have gotten away with using the more obvious ones such as "Find Record" or "Go To Layout" - but that command was the key to making this work.
My mistake was trying to incorporate what everone was saying in all articles under the "Save as PDF" function. But without having set the variable seperately this did obviously not work. Here's what it looked like at the end:
Maybe just put the champagne on ice for a mo... Sorry.
I think you've tried this, and it worked. You may even have tried it on your assistant's machine, and it worked. But please note that they will not be able to open the file that you saved. The files that you save are for you, and the files they save are for them. If you want the files to be available to anyone who uses the database (a very common requirement) you have to modify the approach. (It doesn't matter that the file is hosted on a server.)
If that was what you wanted anyway, get the champers back out again.