When saving a record layout as a PDF I would like to specify the file name of the PDF produced.

I would like to use a field from the record as the name so that the invoice produced has the name which corresponds to the contents of a field. that way I don't need to name each file as it is saved.

Is this possible ?

Set a $variable for path and filename, and then inside the export dialog just put the $ variable....

--sd

I have filemaker 9 (not advanced) where do I set the file name ?

Still posible, a writeout of the scripting:

Set Variable [ $where; Value:Get ( DesktopPath ) &  "/myName.pdf" ] 

Save Records as PDF [ File Name: “$where”; Automatically open; Current record ] 

[ Document -  Compatibility: Acrobat 5 and later ] 

[ Pages -  Number Pages From: 1; Include: All pages ] 

[ Security -  Printing: High Resolution; Editing: Any except extracting pages; Enable copying; Enable Screen Reader ] 

[ Initial View -  Show: Pages Panel and Page; Page Layout: Single Page; Magnification: 100% ] 

[ Restore; No dialog ] 

--sd

Oh actually I have done it thanks that works, I would like to add .pdf to the file name how would I append that to the variable ?

Thanks...

I don't know if you can help on another issue I have, I want to limit users ability to even see any records that are not their own...

I have created a field that holds the name of the user who created a record and want to limit their access to only their records, this does not seem simple...

Obviously admin accounts should see all records...

What do you think ?

My solution was a different database for each user but that seriously limits the ability to connect to other systems and to update 100 databases, so this has to work somehow...

Indeed, some text manipulation and you're there grapping a field value and stuffing it inside your calc. when you set the variable.

--sd