Hi everyone,

I've been trying (for some time now) to figure out a way to automate the naming of an exported file from a calculated field, without the user having to paste the information in themselves. Is there a simple way to do this without using external coding ie AppleScript or VB?

Cheers all

Allan }:(

Yes, there is. See Help > Creating a database > Using variables.

Using variables, you can set a dynamic path and filename in a script, and then use the variable in your file reference.

Set Variable [$path; Get(DocumentsPath)&"/files/"&fieldName]

Then in the export dialog:

"filemac:$path" or "filewin:$path" or both depending on your platform.

Thanks Guys,

I can't believe I've not been able to find that in the help menu before...

It's so simple.

Cheers

Allan