Sage 200 UKI Ideas Portal
Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.
Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.
It would be useful to be able to define multiple conditional format options, each with their own set of conditional properties
Note an alternative option would be able to embed font properties in expressions
We have a site with 3 main companies, they have a single layout for invoices / credit notes
I am using conditional formatting to set the colour of some text
Luckily two of the companies use blue and one uses green
I would not be able to do this if one company used blue, another green, and another yellow
| Idea Benefit | Allows for a cleaner design and easier maintenance3 |
| How do you solve for this problem today? | The alternative is to have multiple objects, all with Suppress Print = True and each with a conditional format to dictate when each is printed - Overlapping all these objects is very time consuming |
| Product Variant | Sage 200 Professional |
Already possible. Use Tools / Options / Use Advanced Conditional Formatting, then look up SWITCH in the help files.; eg.
Switch SYSCountryCodes.Code
Case "DE": TextStyle->Color:=NamedColor("Red")
Case "FR": TextStyle->Color:=NamedColor("Blue")
Default: TextStyle->Color:=NamedColor("Green")