Hi!

I have a document type that allows a person to select a campus from my Campuses Custom Table. I load that campuses into the New Document form with a simple SQL query:

SELECT ItemID, Name
FROM general_campuses;

Simple enough. I want it to store the ItemId value just for clarity and not relying on strings.

The issue is, I want the document name to be the Name field from the Query. Now, I can set "Document name source field" to "CampusID" but then it's the ItemId, not Name.

Is there a way to set the Document name to the Name value?

Thanks!

-Eric