Forum Discussion

Qrew Captain

5 years ago

Setup "Tomorrow" in automation as next work day

Hi an automation which creates a bunch of new tasks that are X days in the future.... It is assigning them on weekends. How do I set the automation to only create tasks with a due date X work days ...

Formulas and functions

Quickbase Automations

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

You should be able to make a formula field to calculate the next work day and set the Automation to use that field. assuming that it is on the Trigger record.

The formula is WeekDayAdd(Today(),1)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

IvanWeiss
Qrew Captain
5 years ago
So the problem is it is not always 1 day. That is just one example. It is all over the place in terms of "how many days"

------------------------------
Ivan Weiss
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  var number WeekDaysToAhead = ... some complicated formula goes here;
  
  The formula is WeekDayAdd(Today(), $WeekDaysToAhead )
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  markshnier2@gmail.com
  ------------------------------
  - IvanWeiss
    Qrew Captain
    5 years ago
    Not sure I understand the "complicated formula".... I need to set this in the automation.... So how am I doing that in a formula?
    
    ------------------------------
    Ivan Weiss
    ------------------------------