Skip to main content
MegSVT
Level 4
Feb 26, 2025 9:04 PM UTC
Solved

Text Mode - Task Report - Latest update by task

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Alex_Di
Alex_DiAccepted solution
Level 3
Feb 27, 2025 2:13 PM UTC

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. 

2 replies

Alex_Di
Alex_DiAccepted solution
Level 3
Feb 27, 2025 2:13 PM UTC

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. 

Translate
MegSVT
MegSVTAuthor
Level 4
Mar 4, 2025 2:14 PM UTC

Good catch! Thank you, this worked! 

Translate