Assuming that you have lots of unused space on your hard dirve, some part of your computed file path is invalid. I'd guess that the folder named by this part of the expression: Year ( Coverage Reports::End Date ) either
1) does not exist
2) does not have a name exactly matching the value returned by this expression
3) is not a folder to which the current user has "write" access permission
You may want to temporarily use a Show Custom Dialog step to pop up with $Save path in it to display the contents of this variable so that you can compare the computed file path to that actually present on your computer.
Just spotted something. I think you need to append a ".pdf" to the end of your file name in the path calculation.
If you want to maintain the found set you originally had, you don't need to do the FindAllOmitShowOmitted trick. You can simply choose to print the current record.
can actually pull up a found set of more than one record if the database is hosted over a network and another user creates a new record in just that tiny instant after Find Alll , but before Show Omitted.
Thanks for all your help. I have got rid of the FindAllOmitShowOmitted trick. which tidies things up a little, i have now ticked the append box. The Folder Year ( Coverage Reports::End Date ) doesn't exist , I thought that it would be created. Is there any way to create a folder based on the contents of a field?
I have now changed it so that it's not trying to create a folder by basicaly removing the last /
The same message came up but a file has bean created fileName(White Space Conflict) and it's unreadable.
i have used the same script in other parts of my database without issue, only the file paths differ
Did you modify the expression to add a ".pdf" to the end of the file name?
would still be interested to know if you can create a newfolder with filemaker
There are file manipulation plug ins you can use. And there are ways to use send event to execute a system script such as a batch file to do this. An applescript on Macs is also an option.
On the windows side, a script can modify text in a text field to create a the command line entries that create a folder of the desired name at the specified location. Then it uses Export field contents to create the batch file and uses Send Event to execute it.
Thanks I'll take a look at that when i get a moment