Colours
may vary slightly subject to brand and type of display.Screen Builder Add List View
List View Name
The name of the List View.
Sort Function
The initial sort ordering of the List View. The sort ordering can be later changed by the user when they press the button.
The available sort order options are determined by the list of sorted fields in the database. For more information see the topic: Screen Builder Field Entry.
Minimum Value
The first or minimum entry to appear on the List View when it is selected. For example, if you only wanted account codes between L-Z to appear on the list, you might enter "L" here. The minimum value is determined by the sort order. If the list is sorted by account code, then the minimum value refers to the first account code to display. If the sort order refers to a date, then the minimum value refers to the earliest date to display. Leave this field blank if you want the first entry in the list to be included.
The minimum value will not apply if the user changes the sort order by selecting a different sort order using the button.
See the next section for tips on setting minimum and maximum range values.
Maximum Value
The last or maximum entry to appear on the List View when it is selected. For example, if you only wanted account codes between L-Z to appear on the list, you might enter "Z" here. The maximum value is determined by the sort order. If the list is sorted by account code, then the maximum value refers to the first account code to display. If the sort order refers to a date, then the maximum value refers to the oldest date to display. Leave this field blank if you want the last entry in the list to be included.
The maximum value will not apply if the user changes the sort order by selecting a different sort order using the button.
See the next section for tips on setting minimum and maximum range values.
Colour Rule
You may specify the colour of the text based on a condition using CAPITAL Business Script. The script must return a number between 0 and 15 to set the colour of the row.
|
Colour |
Number |
|
System Default |
0 |
|
Black |
1 |
|
Grey |
2 |
|
Aqua |
3 |
|
Magenta |
4 |
|
Green |
5 |
|
Cyan |
6 |
|
Brown |
7 |
|
Dark Red |
8 |
|
Dark Green |
9 |
|
Blue |
10 |
|
Medium Green |
11 |
|
Yellow |
12 |
|
Dark Grey |
13 |
|
Red |
14 |
|
Dark Blue |
15 |
Colours
may vary slightly subject to brand and type of display.
This script sets the colour to dark red if a customer account is on hold:
If(Cushold == "Y", 8, 0)
Setting Minimum & Maximum Range Values
Range values are converted internally by CAPITAL to uppercase if not specified as uppercase to begin with.
When specifying date ranges use the format: YYYYMMDD. For example, to specify the 10th of August 2004, enter:
'20040810'
Do not specify numbers unless the field is a number type. For example, postcodes are not number types, so to list all entries between 2000-2999, quotes must be used to surround the value. (This assumes that the database in question is sorted by postcode to begin with.)
You would enter the minimum value as:
'2000'
and the maximum value as:
'2999'
____________________________
Related Topics:
 |