Forum Discussion

BrandonOwens's avatar
BrandonOwens
Qrew Member
5 years ago

Table level rules to make field required

Hello, I am attempting to make a field required based on the entry of another field, please see below for the example code. if(([workstation plan]="replace")or([workstation plan]="add new"),NOT is...
Custom Data Rules
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
You can go to the Advanced Settings for the table and enable Custom Data Rules.  If there is a calculated message then the record save will blocked with the message.

IF(
([workstation plan]="replace" OR [workstation plan]="add new") 

AND 

Trim([workstation to be deployed-replaced])="", "Sorry but when blah blah is blah blah blah, you must provide the  workstation to be deployed-replaced")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • BrandonOwens's avatar
    BrandonOwens
    Qrew Member
    5 years ago
    Thank you! I am guessing that making a field required is not available?
    This is a good option to use if that is the case. Thank you for your time!!

    ------------------------------
    Brandon Owens
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      if you want to use form rules, then just make a formula and include hat formula field on the form.  
      Then have a form rule to make the field required if the formula is not blank.

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