Calculating the numbers of days a field has a specific content

Hi,

I'm ask to add a field that indicates how many days another field (Status) has a specific selection ('New' => 'WIP' => 'Completed').

Is there a way to implement this without 'programming' ?

Thanks for your advice,

Hugo

Parents Reply Children
  • Thanks André for the incredible quick response ;-)

    Do I need to worry about this prerequisite on top of the article you referenced ? 

    • In the SugarBPM settings, there is a setting called "Error Number of Cycles" that specifies how many times a process can loop before the system stops the process definition. By default, this is set to 10. As we are counting days, this number should be increased to allow the process to run for more than ten days. Please note that in some circumstances, increasing the number of cycles could negatively affect performance.

    In our business we have sales cycles that can run over months , years...?

    Thanks again 

    Hugo

  • Hi André,
    That solution from last year works as charme since then.

    Now I have a slightly different version of that question.

    We have a custom text field 'Next Step' which our sales should regularly update. I'm ask to put a custom numeric field next to it, to show how many days ago this Next Step was updated.
    Is there an easy way to achieve this ?
    I was thinking about storing the actual text content and check each day via a BPM timer if it has changed. If not , counter goes up by 1, if it did, counter is reset to zero. Only thing is : how can I create this in BPM...

    Thanks,

    Hugo