Example 2

You want to prevent users from saving a value in a date field if the value falls after tomorrow's date. Display an alert if the rule is violated.

To accomplish this, do the following:

  1. Create a hidden field for "tomorrow's" date on the request type.

  2. Set a SQL defaulting "Apply on page load" rule to set the value of the hidden field based on the following SQL statement:

    select trunc(sysdate+1),
    from dual
  3. Create an "Apply before save" rule with a dependency that checks to determine whether the value the user provided in the date field is later than the value in the "tomorrow" field, and then, if rule fires, shows the alert message and stops the event.