Add latest update/comment on a task into project task view | Community
Skip to main content
S
SeanMe1
New Member
February 18, 2025
Solved

Add latest update/comment on a task into project task view

  • February 18, 2025
  • 2 replies
  • 996 views

Hi All, 

 

I am trying to create a project task view where I have a column pulling in the latest update/comment on its related task. Could anyone assist me in doing this?

Best answer by Madalyn_Destafney

Adding another option for you - this doesn't have any coloring/limits, just has the update, date made and by whom, stacked. Add this to your views, note the column numbers (if it's at the end of the view and you have fewer columns then it'll work but if you want it mid-view you'll need to adjust column numbers):

column.13.displayname=Last Update
column.13.sharecol=true
column.13.textmode=true
column.13.valuefield=lastNote:noteText
column.13.valueformat=HTML
column.14.sharecol=true
column.14.textmode=true
column.14.value=<br>
column.14.valueformat=HTML
column.14.width=1
column.15.linkedname=lastNote
column.15.namekey=view.relatedcolumn
column.15.namekeyargkey.0=lastNote
column.15.namekeyargkey.1=entryDate
column.15.querysort=lastNote:entryDate
column.15.sharecol=true
column.15.textmode=true
column.15.valuefield=lastNote:entryDate
column.15.valueformat=atDate
column.16.sharecol=true
column.16.textmode=true
column.16.value=<br>
column.16.valueformat=HTML
column.16.width=1
column.17.linkedname=lastNote
column.17.namekey=view.relatedcolumn
column.17.namekeyargkey.0=lastNote
column.17.namekeyargkey.1=owner:name
column.17.querysort=lastNote:owner:name
column.17.textmode=true
column.17.usewidths=true
column.17.valuefield=lastNote:owner:name
column.17.valueformat=HTML
column.17.width=160

2 replies

lgaertner
lgaertner
Level 9
February 19, 2025

Hello Sean,

 

If I am understanding you right, this should be possible using this text mode:

linkedname=direct namekey=lastNoteID querysort=lastNoteID valuefield=lastNote:noteText valueformat=HTML

 

 

Regards

Lars

R
rebeccabirkholz47
March 24, 2025

Is there a way to make this an editable field in the project task view? I'd like to be able to leave task comments/notes from that view versus having to go into the task itself. 

 

Thanks!

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity AdvisorAccepted solution
Community Advisor
February 19, 2025

Adding another option for you - this doesn't have any coloring/limits, just has the update, date made and by whom, stacked. Add this to your views, note the column numbers (if it's at the end of the view and you have fewer columns then it'll work but if you want it mid-view you'll need to adjust column numbers):

column.13.displayname=Last Update
column.13.sharecol=true
column.13.textmode=true
column.13.valuefield=lastNote:noteText
column.13.valueformat=HTML
column.14.sharecol=true
column.14.textmode=true
column.14.value=<br>
column.14.valueformat=HTML
column.14.width=1
column.15.linkedname=lastNote
column.15.namekey=view.relatedcolumn
column.15.namekeyargkey.0=lastNote
column.15.namekeyargkey.1=entryDate
column.15.querysort=lastNote:entryDate
column.15.sharecol=true
column.15.textmode=true
column.15.valuefield=lastNote:entryDate
column.15.valueformat=atDate
column.16.sharecol=true
column.16.textmode=true
column.16.value=<br>
column.16.valueformat=HTML
column.16.width=1
column.17.linkedname=lastNote
column.17.namekey=view.relatedcolumn
column.17.namekeyargkey.0=lastNote
column.17.namekeyargkey.1=owner:name
column.17.querysort=lastNote:owner:name
column.17.textmode=true
column.17.usewidths=true
column.17.valuefield=lastNote:owner:name
column.17.valueformat=HTML
column.17.width=160
If this helped you, please mark correct to help others : )
    S
    SeanMe1Author
    New Member
    February 27, 2025

    Thank you! This helped! Is there a way to shorten text in this column if the update is very long? 

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    March 25, 2025

    It's the IF(LEN( and the CONCAT( part of this:

    column.26.valueexpression=IF(LEN({project}.{lastNote}.{noteText})>140, CONCAT(SUBSTR({project}.{lastNote}.{noteText},0,139),"... "), IF(LEN({project}.{lastNote}.{noteText})>0, CONCAT({project}.{lastNote}.{noteText}," ")))

    If the length of the post is longer than 140 characters, it cuts it off and adds an elipses. There is another line that adds a "more" link to the comment. This relies on calc field that has that link formulated already.

    column.28.link.url=customDataLabelsAsString(project.Project Updates_)
    Terms & ConditionsAccessibility statement

    Loading footer...