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

Qrew Captain

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

Icon for Qrew Legend rank

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
  ------------------------------
  - IvanWeiss
    Qrew Captain
    5 years ago
    That is the challenge.... There is nowhere to pull that information from. I built a template of tasks in the automation and they are being assigned via the automation. The triggering data just starts the creation of those tasks. But the template is predetermined in there....
    
    I guess the only other way I could do that is to make a template table with the tasks and store the number of days ahead in there. But that means rebuilding this functionality so hoping to avoid that :(
    
    ------------------------------
    Ivan Weiss
    ------------------------------