A bit of a newbie here.
I have a field (I'll call it "Food") with values which are added via a checkbox set. So the Food field may contain, for example:
I then have a popover button that I would like to conditionally format. I'd like the button to turn red if the Food field contains "Apple".
In layout mode, when I select the button and choose Format -> Conditional, I am prompted to enter a forumula. But I'm not sure what my formula should be.
I tried this simple calculation: Table::Food = "Apple"
When only Apple is check-marked, the conditional formatting works (the button turns red). But if both Apple and Red are check-marked, the button doesn't turn red (I imagine this is because my calculation is looking for only "Apple").
Is there a formula that will turn the object red if the field contains an instance of "Apple" (even though it may contain other words)?