Skip to main content
Question

Due Date cannot be today

  • March 15, 2023
  • 0 replies
  • 43 views

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement