Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!
SOLVED

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? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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!

View solution in original post

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

Correct answer by
Community Advisor

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!