3 Replies Latest reply: Apr 11, 2016 7:23 AM by Gysbert Wassenaar RSS

    How to identify that field have multiple values selected

    A v

      I've a field named Day;

       

      And I've 5 buttons with an action "Alter Selection"

       

      I have 5 buttons:

      • Monday
        • Alter Selection -> W_Day = ‘M’
      • Thursday
        • Alter Selection -> W_Day = ‘T’
      • Wednesday
        • Alter Selection -> W_Day = ‘W’
      • Tuesday
        • Alter Selection -> W_Day = ‘Tu’
      • Friday
        • Alter Selection -> W_Day = ‘F’

       

      I want now that my buttons change it colour based on selection. For example, for the first button I'm trying:

      =IF(MATCH(Day,'M') ,RGB(0,0, 0), RGB(255, 255, 255))

       

      If I only have the value 'M' selected, it works fine but I select other values it changes... I already try with Day = ('M' | 'T') but it do what I want...