Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've a field named Day;
And I've 5 buttons with an action "Alter Selection"
I have 5 buttons:
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...
Try this:
=If(SubStringCount(Concat(DISTINCT '|' & Day & '|'),'|M|') = 1, RGB(0,0, 0), RGB(255, 255, 255))
did u try
=IF(MATCH(Day,'M','T','W','Tu','F') ,RGB(0,0, 0), RGB(255, 255, 255))
Try this:
=If(SubStringCount(Concat(DISTINCT '|' & Day & '|'),'|M|') = 1, RGB(0,0, 0), RGB(255, 255, 255))
Try =if(max(match(Day, 'M')), RGB(0,0, 0), RGB(255, 255, 255))