Discussions

Expand all | Collapse all

Looking for error message help

  • 1.  Looking for error message help

    Posted 28 days ago
    I have a project table that has a Start Date and a Complete Date.
    When the user enters a project I want to make sure that the Start Date is before the Completion Date, If they enter a value that is after the completion date I want to inform them of the error.
    What is the best way to do this in Quickbase?



  • 2.  RE: Looking for error message help

    Posted 27 days ago
    Delynn,

    Do you allow the Users to Grid Edit these dates?   If the answer is no, meaning that they are always working inside of a form, you can build a form rule that will Abort the Save and Display a message when the [Completion Date] is < [Start Date].



    If you do let them Grid Edit or Import Values to the fields then this is a more complicated problem.  Reach out if you need to discuss an intricate business process.


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



  • 3.  RE: Looking for error message help

    Posted 27 days ago
    If protecting the data integrity of data entered in Grid Edit mode or importing is an issue you can use what are called Custom Data Rules.  We can explain that if you need help there.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 4.  RE: Looking for error message help

    Posted 27 days ago
    Thanks Don! That's what I needed. No I'm not Dr. Who but wouldn't that be fun!








  • 5.  RE: Looking for error message help

    Posted 27 days ago
    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
    ------------------------------



  • 6.  RE: Looking for error message help

    Posted 26 days ago
    Jason,

    Davros loves the last part.

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



  • 7.  RE: Looking for error message help

    Posted 25 days ago
    Obviously we are having way to mich fun with this one... lol