Text mode to add date & name in column

Question

I have the Last Note column in my project view, I'd like to add the date & name of who entered the last update. Can anyone help with the expression needed in text mode?

VicSellers · Accepted Answer

Hi @kimberlyho1 - Here you go!

To pull who the last note was entered by, do Last Note > Owner ID and then switch it to name in text mode:

valuefield=lastNote:owner:name
querysort=lastNote:ownerID
valueformat=HTML
displayname=Last Note Entered By
linkedname=lastNote
namekey=view.relatedcolumn
namekeyargkey.0=lastNote
namekeyargkey.1=ownerID

To pull the last note update time, do Last Note > Entry Date and then set it to also show time, if needed.

Let me know if you have any problems with it!

nryan2 · Answer

This is one way you can do that:

displayname=Last Note | Entered By | Date
linkedname=lastNote
namekey=view.relatedcolumn
namekeyargkey.0=lastNote
namekeyargkey.1=noteText
querysort=lastNote:noteText
textmode=true
valueexpression=CONCAT({lastNote}.{noteText}," -- ",{lastNote}.{owner}.{name}," -- ",{lastNote}.{entryDate})
valueformat=HTML

Sign up

Login with SSO

Login to the community

Login with SSO