Ignoring Saturdays and Sundays

Hi Jerome

Can you be little bit clear on your question so that i can help you. Sugar version you are working on, what Process you have created and what actually you want to do.

Best Regards

S Ramana Raju

Hello Jerome,

I have not tested this but I think it will work for you...

1. Create a custom field in the module called 'thisday' that has a calculated value of dayofweek(today()). This will return an integer value from 1 to 7 where 1=Monday. When a record is updated, the custom field will recalculate to the current day's number.
2. In the process, put a gateway that reads the value of this field as follows.
   • Day= 1 or 2 >> Wait 3 days
   • Day= 7 >> Wait 4 days
   • outcome 3: (set this as the default flow, no criteria needed) >> Wait 5 days

Note: Make sure in your process that the evaluation of 'thisday' occurs on the same day that the process begins

 {SugarClub Administrator Edit: We're sorry, but this image is no longer available}  

Please let me know if this works for your use case.

Best Regards,

Jill

Jeff Bickart / Jeff Bickart / Jeff Bickart - see my reply above in response to your recent support site feedback.

-Jill

How does the field thisday get updated? Does it need to change every day? Sugar doesn't currently have a method to keep all calculated fields up to date, does it?

How does the field thisday get updated? Does it need to change every day? Sugar doesn't currently have a method to keep all calculated fields up to date, does it?

HiJeff Bickart,

A process definition is triggered by a save event, and calculated fields are updated during save events. Therefore, the same mechanism that triggers a process of this definition automatically updates the calculated field, which is why it is essential that the gateway evaluating the calculated field occurs on the same day the process is triggered.

You are accurate that there is not a stock scheduler that updates calculated fields in Sugar regular, but this scenario does not appear to call for that.