Discussions

Expand all | Collapse all

Field Validation To Enter Specific Range of Values

  • 1.  Field Validation To Enter Specific Range of Values

    Posted 19 days ago
    Hi,

    I would like to know if there is a way that when i am entering data in the numeric field, i would like to have a validation that the user i allowed to enter only specific values and no other values.

    Ex:- I want the user to enter values between 1 and 31 only.



    ------------------------------
    Gunsham Lakhiani
    ------------------------------


  • 2.  RE: Field Validation To Enter Specific Range of Values

    Posted 19 days ago
    yes Quick Base now supports Custom data Rules. https://help.quickbase.com/user-assistance/formulas_custom_data_rules.html

    You enable that feature on the Advanced Properties page for the table and then write an error message formula.  If the error message is not blank, then it will block the save both for saving vi a form or grid edit, or importing.

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



  • 3.  RE: Field Validation To Enter Specific Range of Values

    Posted 19 days ago
    Hi Mark,

    Thanx a lot. It worked.

    Regards
    Gunsham

    ------------------------------
    Gunsham Lakhiani
    ------------------------------



  • 4.  RE: Field Validation To Enter Specific Range of Values

    Posted 18 days ago
    Note that the custom data on the table rules supersedes dynamic form rules ( When the record is save and condition is not met, abort the save).

    ------------------------------
    Babi Panjikar
    ------------------------------