Custom Form Calculated Fields



Status Timestamp

Capture a timestamp of when a status is selected. Please note that if this status is changed to another status and then back to this status, the original timestamp will remain intact. In this case, the status code is PRR for “Pending Review”, a custom status.



Executive Update

Prefix an update with an exclamation point “! This is my executive update…” to store it in a custom field on the object (project, task, issue, etc.) for use in “Executive” status reporting. All other updates will be ignored.

IF(LEFT(Last Note.Note Text,2)="! ",CONCAT(SUBSTR(Last Note.Note Text,1,LEN(Last Note.Note Text))," --- ",Last Note.Owner.Name," on ",Last Note.Entry Date),Executive Update)

Pseudo Code: If the last note contains !, show me the last note without the first character but with all subsequent characters, followed by the owner of the note and when it was entered. Otherwise, keep the last official status value intact.

2 thoughts on “Custom Form Calculated Fields

  1. Hi
    I have a recommendation in regard to sharing and creating good knowledge in regard to Calculated field. It will be very helpful to add some easy example in regard to some of formulas and how to write expressions in the calculated field area.
    Have a nice day!
    With best regards,

Leave a Reply