Forum Discussion

TimEgerton's avatar
TimEgerton
Qrew Trainee
4 years ago

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;

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
------------------------------
  • 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 Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • TimEgerton's avatar
      TimEgerton
      Qrew Trainee
      Hi Mark,

      Worked perfectly.

      Thanks again.

      ------------------------------
      Tim Egerton
      ------------------------------