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 isnull([workstation to be deployed-replaced]))
What this is trying to say, if "workstation plan" is replace OR add new, make "workstation to be deployed-replaced" required. This rule is at the table level but I have not been able to get it to work. 

Any help on this would be great!

------------------------------
Brandon Owens
------------------------------
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
        ------------------------------