Web App Generator

Code On Time web applications offer rich data lookup capabilities.

Fields with an Items Style of Lookup render as link within a textbox. The Eraser icon to the right of the link will clear the field. The New Record icon to the right of the textbox will create a new lookup item.

When the link is clicked on, a lookup window will open. Users can perform Quick Find or use Advanced Search Bar.

A lookup field can be configured as an Auto Complete text box. When a user types in a value, the list of lookup items will be filtered. If an item is selected, it is inserted in the field. If no item is selected, the field value will revert.

Both Lookup and Auto Complete styles do not prefetch data items when the form view is loaded.

A lookup field can also be configured as a Check Box List. The values can come from a static list or a many-to-many table.

Data lookup fields can be rendered as a Radio Button List.

Consult the following list of properties when configuring a lookup field.

By default, grid and data sheet views will open the first page of records.

If the number of records is small, then it works great. If the number of records is very large, then it is pointless to display the first page before the users specify what they are looking for. The data view can be configured to not request any records and have Advanced Search Bar open by default.

Start the Project Designer. Double-click on Region / Suppliers / container1 / view1 data view node.

Change the following property:

Press OK to save the data view, and click on Browse to generate the web application.

When the web page opens in the browser, navigate to the Suppliers page. The data view will open in search mode.

You can pull the first page of data by pressing the Search button without specifying any search parameters. If you enter parameters, then the matching records will show up.

If the search bar is disabled, then the Quick Find will be available to enter the initial search criteria.