Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 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
UserVoice
IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 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
------------------------------