Question

Due to calculation

  • 29 January 2021
  • 8 replies
  • 186 views
Ezequiel Souza
Userlevel 7
Badge +13

Hi

 

I have a Service Catalog with SLAs used to calculate the Due to.  But the calculation in calendar days, but I need to calculate in Business day.  Is there a way to do this?

 

Thanks

Ezequiel Souza
This topic has been closed for comments

8 replies

Ezequiel Souza
Userlevel 7
Badge +13

Hi Lucas,

 

Unfortunately I’m very disappointed with Pipefy.  There some issues so basic and the way to fix it is using third-party solution involving more costs.

 

Maybe I need to review the continuity of this platform.

 

Thanks.

Ezequiel Souza
Lucas Democh
Userlevel 7
Badge +15

Ezequiel, 

 

Unfortunately Pipefy's native automations do not allow this type of configuration, but you will be able to configure this and other types of more advanced automations in Integromat.

Integromat

 

An example of how you can configure:

 

 

Democh
Ezequiel Souza
Userlevel 7
Badge +13

Let the screenshot 

 

Ezequiel Souza
Ezequiel Souza
Userlevel 7
Badge +13

Hi Lucas,

 

You ideia sound good, but I didn’t find any option in the Automation that permit identify which day is today to be used in my logic.  Could you tell me how to do this, please?

 

Thanks.

Ezequiel Souza
Lucas Democh
Userlevel 7
Badge +15

Hello,

I believe that this function does not exist yet.

An idea: In your automation, add weekends in the SLA.

For example:

If the request date is Monday, the SLA would be equal to 5 days. In other cases, it would be 7 days. With a more elaborate code, you can do the same with holidays, adding an extra day when there is a holiday halfway.

Democh
Ezequiel Souza
Userlevel 7
Badge +13

Hi Eduardo,

 

Additional details 

The services has SLA

This is calculated using a automation based on created datetime add 5 days, but can’t in count Saturday and Sunday.

 

Best regards.

Ezequiel Souza
Ezequiel Souza
Userlevel 7
Badge +13

Hi Eduardo.

 

Yes I had configured as mentioned, but this is applicable for Expiration Alert

 

I’m talking about the for each card that I have a due to to get done

Best regards.

Ezequiel Souza
Eduardo Kano
Userlevel 7
Badge +8

Hi @Ezequiel Souza !

Did you try the “Count weekdays only” on the Pipe settings?

Hope this helps you! Let me know if it worked! :grin:

 

Eduardo Kano, Projects Coordinator at TRR.
Terms & ConditionsCookie settings