Forum Discussion

GunshamLakhiani's avatar
GunshamLakhiani
Qrew Cadet
6 years ago

Field Validation To Enter Specific Range of Values

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
------------------------------
Custom Data Rules
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years 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
    ------------------------------
    • GunshamLakhiani's avatar
      GunshamLakhiani
      Qrew Cadet
      6 years ago
      Hi Mark,

      Thanx a lot. It worked.

      Regards
      Gunsham

      ------------------------------
      Gunsham Lakhiani
      ------------------------------
      • BabiPanjikar's avatar
        BabiPanjikar
        Qrew Assistant Captain
        6 years 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
        ------------------------------