Row formatting in datagrids
Row formatters define conditional formatting for rows of a datagrid.
►IMPORTANT◄ When working out row formatters for a given datagrid in an iterative approach (toggling between settings and results), it is important to stick to the following routine:
Click List: Edit in the Preferences tab of the overview that contains the datagrid.
Apply changes to Row formatters in Datagrid preferences as described below.
Save data grid preferences after changing settings.
Select Back to return to the overview that contains the datagrid.
Select Reload in the Preferences tab to update the datagrid definition in the opened overview.
Switch to the Common tab in the ribbon and select Search to refresh search results.
Review the effect of the current row formatter configuration and go to Step 1 to apply further changes, if any.
Skipping steps in this routine may create misleading impressions regarding the effects of the changes, as only the combination of Save→Reload→Search guarantees 'what-you-see-is-what-you-get' in step 7. However, it is an option to replace steps 5 and 6 by closing and reopening the overview.
Example:
In an overview for users the datagrid rows for 'active' users should appear with white text over cyan background.
The Row formatter tab lists all formats for a datagrid on the left. The 
and 
symbols add and remove formats. Entries can also be copied and the order can be manipulated using the "up"/"down" buttons.
►IMPORTANT◄
If several formatting options have been defined, all matching formattings (condition) are combined from top to bottom if they do not have the "Dominant" option set. If the "Dominant" option is set for a matching formatting, it will be used directly. The dominant entry that is higher up in the list "wins".
In our example, there is only one format ('Highlight active') which is selected, so details appear to the right of the list.
As a condition a simple property restriction, property restriction or sub search can be defined. In the example, a simple property restriction seeks rows (here: Users) with the 'Active' property checked (true). See Search builder for more details on defining restrictions.
In Format settings, the 'Preview text' row visualizes the format settings by example. These settings are specified below.
Result:
'Active' users are highlighted, 'inactive' users show standard format.