Scripting file name for export to Excel
I want to be able to use the content of a field in a found set to build a scripted file name for an export to Excel. I just don't seem to get how to do that. I inherited a script that sets a complex variable and does so using GetDesktopPath to name the file to be exported. However, my user wants to chose their own path for saving, but keep the scripted file name based upon a field in the found set.
I'm certain I just am missing something that is staring me right in the face. I haven't been able to find an example to use to understand. I'm attaching a screenshot.