Export PDF using FieldName

[Reid]

Is it possible to export to PDF and name the file based on a field name? I have a daily report that I want to save as a PDF with a name "PDF Export For (table::DateField)".

[VincentO'B]

Reid

1. Make a calc field = "PDF Export For" & Get ( CurrentDate )

2. In the 'Save records as PDF' script step.

Under the 'Specify output file' option you can name the file with your calc field and save it to a location of your choosing.

Vincent

[Reid]

Reid

1. Make a calc field = "PDF Export For" & Get ( CurrentDate )

2. In the 'Save records as PDF' script step.

Under the 'Specify output file' option you can name the file and save it to a location of your choosing

Vincent

How do I name the file using the calc field I just created? All I see is "Output File Path List" and then pick a filename.

[comment]

Use a script variable, e.g.:

Set Variable [ $myPath; Value:Get (DesktopPath) & "/" & MyTable::MyField & ".pdf" ]

Save Records as PDF [ File Name: “$myPath”; Records being browsed ]

No calculation field is required.

[Reid]

Use a script variable, e.g.:

Set Variable [ $myPath; Value:Get (DesktopPath) & "/" & MyTable::MyField & ".pdf" ]

Save Records as PDF [ File Name: “$myPath”; Records being browsed ]

It says it is an invalid Get Function. This is what I put in for the $myPath variable

Get (filewin:/C:/Folder/Folder/Folder) &"/" & MFSDItems::SavePDFfileTitle &".pdf"

[comment]

Get (DesktopPath) is a valid function. If you want another location, try:

"filewin:/C:/Folder/Folder/Folder/" & MFSDItems::SavePDFfileTitle & ".pdf" 

[Reid]

Get (DesktopPath) is a valid function. If you want another location, try:

"filewin:/C:/Folder/Folder/Folder/" & MFSDItems::SavePDFfileTitle & ".pdf" 

Thanks...this works but now the PDF can't be created because my field MFSDItems::SavePDFfileTitle has a date in it (i.e. 2/17/2011)

I'm trying to create a calculation field that equals my date field with the intention to change the format. Is there a way to change the "/" to "-"?

A calculation like MFSDItems:date FormatChange(**-**-****)

[comment]

Try the Substitute() function. Or extract the date elements using Year(), Month() and Day() functions - this will enable you to rebuild the format to say yyyy-mm-dd, so that the files can be sorted properly.

[bruceR]

Use a script variable, e.g.:

Set Variable [ $myPath; Value:Get (DesktopPath) & "/" & MyTable::MyField & ".pdf" ]

Save Records as PDF [ File Name: “$myPath”; Records being browsed ]

No calculation field is required.

The slash is not required; it is part of get( desktopPath).

Set Variable [ $myPath; Value:Get (DesktopPath) & MyTable::MyField & ".pdf" ]