On a project report, I included these columns:Last Note: Note TextLast Note: Entry Dateand it appears that Last Note: Owner ID is the person that entered the last noteCan I get to the name of the person that entered the last note, rather than their ID?

Level 5

Solved

On a project report, is it possible to get to the user name that entered the "last note"?

On a project report, I included these columns:

Last Note: Note Text
Last Note: Entry Date
and it appears that Last Note: Owner ID is the person that entered the last note

Can I get to the name of the person that entered the last note, rather than their ID?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by imgrund

Hi - yep! You just need to change the field into text mode and replace ID with :name

valuefield=lastNote:owner:name

querysort=lastNote:owner:name

valueformat=HTML

displayname=Last Note Owner

linkedname=lastNote

namekey=view.relatedcolumn

namekeyargkey.0=lastNote

namekeyargkey.1=ownerID

Hope that helps :)

Accepted solution

Adobe Employee