Text mode to add date & name in column

[KimberlyHo]

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? 

[nryan2]

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

[VictoriaLinn · Accepted solution]

Hi @KimberlyHo - 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!