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

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
------------------------------

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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    I am making the assumption that the trigger record that is triggering the Automation can have a field with a formula to calculate how many days ahead you want. The automation will just use that field.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------