Automatically naming output file

[Toni]

Hello

Is it possible to automatically name the output file based on the value of a field?

Let's say I have text field with value 4512 (which is a code) and I want to export a tab-sparated file

with name m124512, where m indicates the department, 12 indicates the year, and 4512 is the value of the field.

Thank you, Toni

[comment]

You can create a variable with the path for the exported file, then use the variable in the export script step.

[Toni]

Thanks for pointing that option. I haven't seen that.

It took a while to figure it out, but finally got it working. At first I thought that I should have specified the whole path and filename within the variable. But it wasn't working that way.

So I defined only filename on the variable, and the path in the export step of the script.

[comment]

I thought that I should have specified the whole path and filename within the variable. But it wasn't working that way.

it should have.

[Toni]

it should have.

Well it didn't, but now that I am thinking I didn't put "filewin:" in the variable calculation which probably caused the problem.

I will try once more tomorrow. Thank you again.

[Toni]

Yes comment, you are right, it worked. I did forgot to put filewin: at the begging of the calculation. what I finally did was:

"filewin:/D:/Desktop/m"&Right (ComNuovo::Data Fattura;2)&ComNuovo::Fatt nr&"."&"txt"

ComNuovo is the database, Data Fattura and Fatt nr are the two fields of the database which I use to name the file.

Best regards, Toni