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