Multiple Choice Field Custom Data Rule

Question

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;If value the in Multiple Choice field (1) is "X" the values in Multiple Choice field (2) can only be "A", "B","D" & "E" otherwise error message.If value the in Multiple Choice field (1) is "Y" the values in Multiple Choice field (2) can only be "C", D" & "E" otherwise error message.Any assistance would be welcome.Thanks------------------------------Tim Egerton------------------------------

MarkShnierYou · Answer

np,  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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community