In the Abra Flexi web interface, it is possible to color-code items in most databases based on one or more configured conditions. Practical examples include distinguishing a bank account in the Bank module, a price group in the address book, or a payment method in received/issued invoices.
How to configure row color conditions
The field for configuring row color conditions is located in the upper section of the column settings panel, which can be accessed by clicking the Settings option (the gear icon in the bottom-right corner).
Example 1 (Issued Invoices)
We want to color a row when the condition is met that the invoice is paid and has the label "Important" assigned to it. The condition configuration will look as follows:
Using the "Add condition" option, you can gradually add any number of conditions for row coloring.
As a demonstration, we will add another condition — invoices with a cash payment method.
After saving the row color settings, the invoice list will look like this:
This method allows you to color-code rows based on any field included in the form for the given document type.
Example 2 (Issued Invoices):
As we can see, one row color (pink) was applied as a result of the conditions for the Company Name and Bank Account fields being met. Conversely, the row for document VF3-0013 was not colored because the condition for Bank Account was not satisfied.
A different color (yellow) was applied as a result of the condition for Invoice Type (Advance) being met. Since the conditions for Company and Bank Account were defined first in the condition settings, those documents that were simultaneously of the Invoice Type "Advance" were colored pink.
Note: From the above, it follows that when two conditions are met simultaneously, the row will always be colored according to the order in which the conditions are listed in the row color settings.
Example 3 (Price List)
In this example, we can see that rows (price list items) meeting the condition for Stock Type - Goods and Product Group - Packaging were highlighted in green. These price list items have a stock level of 0, so even if the order of the conditions were swapped, they would not be colored orange — unlike the other items that did meet that condition.