...
In the application, open the document or item list that you would like to configure. To view the configuration options, click the More button on the form toolbar and then select Configure list.
The List Options dialog box opens. Depending on the particular document type or item type, the dialog box can include the following tabs:
- Main: This tab presents the date format, currency visibility, and applied filters.
- Filter: Using this tab, you can define filters.
- Order: This tab can be used for changing the order of documents or items in the list. For example, the documents can be listed according to their dates: from earlier to later ones.
- Conditional Appearance: Using this tab, you can change the appearance of specific columns based on conditions.
- Grouping: Using this tab, you can select how to group the data.
...
For more detailed descriptions of conditional list formatting options, refer to List Formatting Options for Lists.
Example of Conditional Formatting
...
- On the Appearance tab, set the Background color parameter to the desired color (as on the screenshot above).
- Select the Horizontal position parameter and select Align right option.
- Open the Conditions tab.
The Edit conditional appearance item dialog box. The Conditions tab
...
- Add the Document Currency field to table, set condition type to Equal to and set the value to EUR.
...
- Add the Amount field, select Greater Than as condition, and enter the lower limit.
...
- On the Formatted Fields tab, select specific fields to which the formatting will be applied. In our case, make no selections, and the formatting will be applied to all columns on the lines where Amount (EUR) >5.
The Edit conditional appearance item dialog box. The Formatted Fields tab
...
- Click ОК to save the appearance settings and close the Edit conditional appearance item dialog box.
...
- To apply these settings to the document list, click the Finish editing button in the List Options dialog box.
The Invoices list with the applied formatting
...