Text Mode - Task Report - Latest update by task | Community
Skip to main content
MegSVT
February 26, 2025
Solved

Text Mode - Task Report - Latest update by task

  • February 26, 2025
  • 1 reply
  • 442 views

I'm wondering if anyone has a text mode column for the last update on a task, however, the text mode that I have created shows the last update for the entire project on the report, and I'm just looking to see a single update on an individual task. Can anyone help me out here?

 

displayname=Latest Update
namekey=latest update
shortview=true
valueexpression=CONCAT({project}.{lastNote}.{noteText}," -- ",{project}.{lastNote}.{owner}.{name}," on ",{project}.{lastNote}.{entryDate})
valueformat=HTML

 

Best answer by Alex_Di

Hi MegSVT, 

 

Since you are already on a task report this should work.  You were getting the Project information by having {project} in your expression. 

displayname=Latest Update
namekey=latest update
shortview=true
valueexpression=CONCAT({lastNote}.{noteText}," -- ",{lastNote}.{owner}.{name}," on ",{lastNote}.{entryDate})
valueformat=HTML

 

Hope this helps. 

1 reply

Alex_Di
Alex_DiAccepted solution
Level 3
February 27, 2025

Hi MegSVT, 

 

Since you are already on a task report this should work.  You were getting the Project information by having {project} in your expression. 

displayname=Latest Update
namekey=latest update
shortview=true
valueexpression=CONCAT({lastNote}.{noteText}," -- ",{lastNote}.{owner}.{name}," on ",{lastNote}.{entryDate})
valueformat=HTML

 

Hope this helps. 

MegSVT
MegSVTAuthor
March 4, 2025

Good catch! Thank you, this worked!