Skip to main content
Question

Table level rules to make field required

  • January 11, 2021
  • 0 replies
  • 22 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement