Text mode to add date & name in column | Community
Skip to main content
K
KimberlyHo1
Level 2
February 8, 2024
Solved

Text mode to add date & name in column

  • February 8, 2024
  • 2 replies
  • 637 views

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? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by VicSellers

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!

2 replies

N
nryan2
Level 3
February 8, 2024

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

VicSellers
Community Advisor
VicSellersCommunity AdvisorAccepted solution
Community Advisor
February 8, 2024

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!

Terms & ConditionsAccessibility statement

Loading footer...