Multiple Choice Field Custom Data Rule
Hi, We have a Multiple Choice field (1) with values "X" and "Y". And a Multiple Choice field (2) with values "A", "B", "C", "D" & "E". We would like to create a Custom Data Rule as follows; ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
not tested but try this:
var bool ValidForX =
[Multiple Choice field (2)] = "A"
or
[Multiple Choice field (2)] = "B"
or
[Multiple Choice field (2)] = "C"
or
[Multiple Choice field (2)] = "D"
or
[Multiple Choice field (2)] = "E";
var bool ValidForY =
[Multiple Choice field (2)] = "C"
or
[Multiple Choice field (2)] = "D"
or
[Multiple Choice field (2)] = "E";
IF(
[Multiple Choice field (1)] = "X" and not $ValidForA, "Invalid Choice for X",
[Multiple Choice field (1)] = "Y" and not $ValidForY, "Invalid Choice for Y")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
not tested but try this:
var bool ValidForX =
[Multiple Choice field (2)] = "A"
or
[Multiple Choice field (2)] = "B"
or
[Multiple Choice field (2)] = "C"
or
[Multiple Choice field (2)] = "D"
or
[Multiple Choice field (2)] = "E";
var bool ValidForY =
[Multiple Choice field (2)] = "C"
or
[Multiple Choice field (2)] = "D"
or
[Multiple Choice field (2)] = "E";
IF(
[Multiple Choice field (1)] = "X" and not $ValidForA, "Invalid Choice for X",
[Multiple Choice field (1)] = "Y" and not $ValidForY, "Invalid Choice for Y")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Hi Mark,
Worked perfectly.
Thanks again.
------------------------------
Tim Egerton
------------------------------
