Expand my Community achievements bar.

Text mode to add date & name in column

Avatar

Level 2

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? 

2 Replies

Avatar

Level 3

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

Avatar

Level 6

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.

 

VictoriaLinn_1-1707421100014.png

 

Let me know if you have any problems with it!