I’m working on an updatable dashboard for our purchasing department. The request is to highlight lines as stated below. I tried to use the rule wizard and it does work up until the CheckBox01 field is checked as true. It did turn the line green as soon as the box was checked, however, after I updated the dashboard, the box remained checked, but then the rule took over and turned it back to either yellow or red.
If PartWhse.OnHandQty < PartWhse.MinimumQty and PartWhse.CheckBox01 = false then Yellow else
If PartWhse.OnHandQty = 0 and PartWhse.CheckBox01 = false then Red else
If PartWhse.OnHandQty < PartWhse.MinimumQty and PartWhse.CheckBox01= true then Green else
If PartWhse.OnHandQty = 0 and PartWhse.CheckBox01 = true then Green
I can handle the wizards, but code is a bit out of my realm. How would I go about doing something like this?
Thanks for any help!!