Good evening all
hopefully a quick question for you all.
I have an initial main form with several buttons on it linked to another screen (data on that screen depends on the label of the button). I have a connector setup which loads the relevant data from ListA on the screens the buttons are linked to.
What I would like to do is have the buttons on the main screen change colour (on form load) depending on the value of one of the columns in the ListA. This would give the users an immediate visual identification of what is working and what isn't
For example
| Box_name_column | Serviceability_column |
| 1 | Works |
| 2 | Partial |
| 3 | U/S |
Works=Green, Partial=Yellow, U/S=Red
Many thanks for you help