Last Updated by - amend so only picks up when the task is changed to complete | Community
Skip to main content
C
CharlieHam
Level 2
September 5, 2024
Question

Last Updated by - amend so only picks up when the task is changed to complete

  • September 5, 2024
  • 1 reply
  • 710 views

I've added Last Updated by to my view but i want to change this so it only picks up when the task is changed to complete. ie when it's changed to In progress or an Update is added for the task the Last Updated field is blank but when it's changed to Complete the field has the name of the person who did this. Is this possible?

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

1 reply

lgaertner
lgaertner
Level 9
September 5, 2024

Hello Charlie,

 

One approach could be the following:

 

valueexpression=valueexpression=IF({status}="CPL",{lastUpdatedBy}.{name},"") textmode=true valueformat=HTML displayname=completed by

 

alternatively you could also use the following valueexpression:

IF({percentComplete}=100,{lastUpdatedBy}.{name},"")

 

 

But on the other hand I would be careful with this, as the field lastUpdatedById will be changed with any modification on that task.

 

So, if someone changes anything else, but the status / percentage, you could run the risk of having the wrong person displayed here.

 

 

Regards

Lars

 

    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity Advisor
    Community Advisor
    September 5, 2024

     

    Hi @charlieham,

     

    Further to the drawbacks @lgaertner mentioned, I invite you to consider avoiding them by using my Targeted Auditing technique.

     

    Regards,

    Doug

    C
    CharlieHamAuthor
    Level 2
    September 6, 2024

    Thanks Doug - i'll give this a try

    Terms & ConditionsAccessibility statement

    Loading footer...