Forum Discussion

Re: Looking for error message help

  1. Go to table settings
  2. Go to Advanced settings
  3. At the bottom there is a part called 'Build custom data rules for this table'
  4. Put in the following formula

If([Complete Date]<[Start Date],"Complete Date cannot occur before Start Date! Exterminate!! Exterminate!!")

  1. Check the box Turn custom data rules on?
  2. Save
Now when you go grid edit and the rule is violated you get this error message and the line is highlighted red

In the record you get this message

Obviously you might want to change that last part.


------------------------------
jason johnson
------------------------------

2 Replies

  • DonLarson's avatar
    DonLarson
    Qrew Elite
    Jason,

    Davros loves the last part.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • DelynnMontrose's avatar
      DelynnMontrose
      Qrew Trainee
      Obviously we are having way to mich fun with this one... lol



      ------Original Message------

      Jason,

      Davros loves the last part.

      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------