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

[CathyKe1]

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?

[AnthonyIm · Accepted solution]

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 🙂

[CathyKe1]

OMG @Anthony Imgrund‚ ! Thank you. I swear I tried that, but obviously had something wrong.

It's showing exactly how I want now!!