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