How can I set up a script to save as pdf with a field date as the pdf filename?

here's an example from a modified FM template. Click the view purchase order button in the upper right corner. The date had to be reformatted without the slashes, since those are path separators.

Purchase_Orders.fp7.zip

I don't know how reed did it (at work and can't download)

but i found a nifty way to do it in fmp8

in my script, i set a variable $filename to database::invoice field & ".pdf" so the entire filename was one variable

and then i did save pdf as...

and i put in the directory of where to save, ie:

c:whatever$filename

Thats all i had to do, the fun part was inserting that file as an obect embedded into the database : but i figured that out a few minutes later

apologies for my lack of understanding scripting nomenclature but can anyone post an exact verbatim scripting procedure for this? I'd like to have my pdf's saved too, not with a field date, but rather with my invoice id number on my main layout. Scripting where it saves to would be nice not necesarily.

-brian

Edited June 2, 200619 yr by Guest