Forum Discussion

BrianneJacobsen's avatar
BrianneJacobsen
Qrew Trainee
2 years ago

Due Date cannot be today

Good Morning,

Is there a way to restrict a date field?

So there is a table for Task Z.  Dept. A creates new tasks, however, once created the second step in the process is done by Dept. B and there is a Due Date field to let Dept. B know when their step needs done.  Dept. A has a habit of just putting today's day as Due Date.  Dept. A has been told multiple times not to do this but still does it anyway.  Is there a way to restrict that field so that Due Date cannot equal Today?

(I don't need or want it to auto calculate based on a set time frame, like today is 3/15 so the due date is automatically 3/16.  The due date could be 3/16 or it could be 3/21 or it could be 4/28, as long as it is a least 1 day in the future so that Dept. B actually has time to work on it.)



------------------------------
Brianne Jacobsen
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger

    Try this

    Make a new  formula numeric field called [Record ID# mirror] with a formula of

    [Record ID#]

    That will give us a hook we can use in a form rule to determine if the record has been saved yet.

    Then make a formula like this. 

    When the record is saved

    Conditions:

    all of:

    [Record ID# mirror] is (blank)

    [Due date] is "the current date"

    ACTION:

    Abort the save with message.

    Sorry, but you cannot inflict a date of Today as the Due Date for your co-workers.  They need more time than that :) 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BrianneJacobsen's avatar
      BrianneJacobsen
      Qrew Trainee

      That did it.  Thank You!



      ------------------------------
      Brianne Jacobsen
      ------------------------------