build apps by user

Define List View and Filter Properties

List View is one part of a worksheet. It displays a list of record entries for selection or reporting purpose. Multiple views can be created on a worksheet for different use cases and scenarios. Let’s see how to create a list view.

Basic Column Properties

Column is the basic element of a list view. Each column is associated with a database table and field. These are the basic properties that define a list view.
define the basic properties of list view in browse pane.
 View
Since multiple views can be created, it assigns the unique view names to a Column. A short view name is enough since it is for internal use.
 View Caption
It is the display caption of a view. It lets user knows about the content of the view. Although there is a number of columns in a view,  View Caption   is defined in Column 0. If it is left blank, no view caption is displayed.
 Column Caption
It defines the description to be displayed in the header of a Column.
 Column
The position of a Column inside a View.  Column   starts from 0, 1, 2, 3, … Please notes that Column 0 must be associated with the  Key Table.Field  of the record entry in the worksheet, and it is hidden in the list view. Therefore the first visible column in the list view is Column 1.
 Width
Defines the Width of a Column. It’s basic value is 1000. You can define a value less than or greater than 1000. If you want to hide a column, define its value with 0. No matter what is the Width value in Column 0, it is always hidden in the View.
 Table
Defines the name of the database Table that is associated with the Column. You can define the Columns to be associated with the Key Table, and/or another Table of multiple value cells. It is not allowed to define more than one Table of multiple value cells in the same View.
 Field
Defines the name of the associated Field in Table, which values are to be displayed in the Column. Each column must be associated with a table field.

View Filter and Display Order

After defining the Table Fields for each Column, all records (or rows) inside the defined Table(s) is displayed. You may like to display certain records only, and control its displaying order. It is defined in  View Filter .
define the limiting condition and displaying order of list view in browse pane.
 View Filter
It is a text string that defines the conditions for the records to be displayed, and the sorting order for the set of records to be displayed.
For example : DocType=”ODR” Order By tblInv.InvNo Desc. DocType=”ODR” means Only the records with DocType equal to “ODR” is displayed. Order By is the start of the sorting string. tblInv.InvNo Desc means the table field tblInv.InvNo is sorted in Descending (from large to small) order. If no Desc is specified, the field is sorted in ascending (from small to large) order.

Some Visual Properties

Let’s learn some properties about display of the List View.
define the visual properties of list view in browse pane.
 Row Height
It defines the default height of the rows in the List View. Its basic value is 500.  Row Height  is defined in Column 0.
 Divider
If No is defined in a Column, the vertical divider in the right hand side of the Column does not appear. Leave it blank to shows the divider. It is a handy feature to group some columns together visually.
 Formatting
Defines the displaying format of the numeric values in the Column. For example : ##,##0.00 adds thousand separators to the numeric values and display 2 decimal digits only.

It is a convenient feature to let user click on a row in the list view and display some useful data related to that row. It can be easily done by adding a formula.
define the formula to display related information in list view.
 Function
It defines the type of display formula, title, row height and column widths of the display data.
i.e. : Type; Display Title; Rowheight|Colwidth1|Colwidth2|…
Type of Display Formula
There are 2 types of formula – Multi and Summary.
Type Description
Multi It displays in the style of multiple rows of data. It is used to display information related to the current Row in the List View. Single quoted table field (i.e. ‘table.field’) can be applied in the formula so that the displayed data are related with the current Row in the List View.
Summary It is used to display summary info of all Rows in the current List View.
Display Title
A title description about the content of the displayed data. It can be defined in these methods:
Method Description
Fixed Text Any text to be displayed directly as the title caption.
Replacing Value Define a table and field name enclosed in single quote – ‘table.field’, so that the value of the cell associated with the table field is displayed. It can be used combined with fixed text.
Formula Define a Select query to generate a value as the title.
Row Height and Column Widths
Define the height of the rows and the width of columns of the displayed data. Each value is separated by the divider character “|”.
In a multiple row table, you can define row height and column widths of more than one column. For example : 500|1200|3000 means row height is 500, the 1st column width is 1200 and the 2nd column width is 3000.
 Display Formula
It’s a Select query. If single quoted field (i.e. ‘table.field’) is used in the formula as replacing value, the table field must be present in the List View.

Define Filter Boxes

Let’s create some on-screen search and filtering boxes so that user can select the rows to be displayed on the list view dynamically.
define the properties of filter boxes.
 Filter Tooltips
It is the description of the Filter Box that is shown in its tool tips.
 Position
It is the location of the Filter Box starting from 1, 2, 3, …
 Type
There are 2 types of Filter Box – Search and Filter.
Filter Type Description
Search It is a text box for input of search text. The rows that have the search text in the List View are displayed.
Filter It is a combo box with a selection list of values. The selected value is matched with the table field associated with the Filter Box. Only Rows with matched value are displayed in the List View.
 Table.Field
It defines the associated table field with the Filter Box. It’s input format is Table.Field – a single string with table name combined with a dot “.” and field name. There is no need to define table field for Search Box.
 Initial Value
It defines the default initial value of the Filter Box. The initial value is different for different data types of the associated Table Field.
For associated Table Field of Date value:
Initial Value Description
All It means no filtering. If it is defined in From Date, it means no lower bound for the date range. If it is defined in the To Date, it means no upper bound for the date range.
Month (Short Name) It creates a fixed period from Month A to Month B.
It’s either one of these values : Jan/Feb/Mar/Apr/May/Jun/Jul/Aug/Sep/Oct/Nov/Dec. If it is defined in From Date, it is the first day of the month of the year. If it is defined in To Date, it is the end of the month of the year.
Number It creates a dynamic period relative to the current month.
It’s value is either of these …, -4, -3, -2, -1, 0, 1, 2, 3, … The displayed initial value is a month value calculated from the current month. -1 means the last month, 0 means the current month and 1 means the next month.
For associated Table Field of Text value:
Initial Value Description
All It means no filtering on the associated Table Field. It is any text starting with “All”. It can be All or All Something.
Fixed Value The initial value can be any value that matched with the associated Table Field.
 Width
The width of the Filter Box. It’s basic value is 1000. Usually, it can be 2000, or 3000.
 Input Box
It defines the Input Box for the Filter.
Input Box Description
Text A text box is displayed. It is used for the Search Box.
Combox It is used for filtering on Date value. A list of fixed items is displayed in the selection list.
CmbFilter It is used for filtering on Text value. Only values that exist in the current List View are displayed in the selection list.
 Property
These are the options of Porperty:
Property Description
Date1 It is the starting value of a date range.
Date2 It is the ending value of a date range.
Single It is used for filtering on text value.