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 va...
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
      ------------------------------