How to get duration in a certain status

Posted by Rollbase User on 07-Nov-2012 22:21

I have a column with multiple status's, i want to time stamp how long each record is in a status for. What is the best way to accomplish this?

All Replies

Posted by Admin on 07-Nov-2012 22:31

Rollbase does not provide built-in support for duration of statuses. However you can define Date fields and populate them (using triggers) when particular status is set. Say, populate "closed_date" field by current date when status is changed to "Closed".

Posted by Admin on 10-Nov-2012 20:32

Hi Chris,



For this type of requirement, we use two fields saved on a record to get it's duration. say, Open Date and Close date.

You can have values fed into these fields using server-side triggers (when conditions are met) or client-side operations like manual input.



Ex. Open Date can automatically have the value when a record is created. (object definition > go to the field and click on the edit link, you will see two or three checkboxes and input boxes there at the top asking if you want values on-create and on-update / status change of the record)



When setting the close date you have two paths, server-side and client-side



- Server-side: automatically populate the Close Date field with an Update Field Value trigger. For cleanliness, you can leave trigger timing BLANK (after create,update,delete), instead, you can append specific triggers to run on specific workflow actions, go to your action (Closed) and edit it, you'll see a list of triggers there that will run when the action is used.

-

This thread is closed