Contents

 
Home
PHPRunner 8.1 manual
Prev Page Next Page
 
 

Visual Editor - Lookup wizard

 

Lookup wizard is a list of values. Values can be entered manually (List of values option) or retrieved from the database table (Database table option).

lookup_5_1

List of values

Use add/delete buttons to add/delete values and up/down buttons to order them.

lookup_list_values

Database table

You can select the existing database table/custom view to retrieve values from (Table dropdown box) or create new custom view using Create new query button. For more information about creating SQL query, see About SQL query designer.

yellowbulbNote: if selected table is included in the project, the rules applied to the project tables (such as modified SQL query, Advanced Security, changes made to the SQLQuery object in the After table initialized event) will be also applied to the lookup table. For example, you can limit the list of items in dropdown with Advanced Security.

lookup_table

Display field

You can use Custom Expression for the Display field to display several values from different fields with custom design in dropdown box. Click the arrow near Display field and then <Custom expression>.

custom_lookup_field

How it looks in the browser:

custom_field

WHERE expression

The WHERE expression allows to sort dropdown box content. In our example if you put "phone like '%555%'" into WHERE box only Contacts with 555 in phone number will be displayed.

where

To use table variables of the session in a WHERE clause, table names should be written as follows:

$_SESSION["Cars_masterkey1"]

$_SESSION["_Cars_OwnerID"]

Autofill

You can auto-fill several fields on the Add/Edit pages with values from the lookup table.

lookup_autofill

Add new items on the fly

This option puts Add new link next to the dropdown box allowing to add new items right on Edit/Add page. Add new item popup is a fully-featured add page.

add_new_item

Dependent dropdown lists

You can use dependent dropdown lists, where values shown in the second dropdown list depend on the value you’ve chosen in the first one.

Let's make the Model field content depends on the Make field value:

1. Set Lookup wizard as "Edit as" type for the Make and Model fields.

2. For the Model field select This dropdown is dependent on check box. Select Make as parent field from the main table and filter field from lookup table.

lookup_dependent

3. Click Test it to check how it works.

lookup_test

An example of Edit page with dependent dropdown lists:

linked_drops

Cascading dropdown lists

You can also create chain of dependent dropdown lists where one dropdown list depends on two or more master dropdown controls. For example, Model field content depends on values of Make and YearOfMake fields. So you can select from only those models that were produced by selected company on selected year. To perform this:

1. Set Lookup wizard as "Edit as" type for the Make, YearOfMake and Model fields.

2. Make the YearOfMake dropdown list depends on Make dropdown list.

3. For the Model field select This dropdown is dependent on check box and click Advanced. Then select Make and YearOfMake fields and click OK.

lookup_dependent_adv

Click Test it to check how it works.

lookup_dependent_test

Also more than one dependent dropdown box can be tied to the same master dropdown control.

Appearance of lookup wizard

Dropdown box

List of values is displayed as a dropdown box. If you set Multiline to any value greater then one this field will appear as a listbox on Add/Edit pages. Select Allow multiple selection check box to allow users select multiple values.

lookup_mult_select

Edit box with AJAX popup

This feature is explained in AJAX-based features. Select Allow multiple selection check box to allow users select multiple values.

fasttype1

Checkbox list

List of values is displayed as set of check boxes. A user can select one or several values.

lookup_checkbox_list

If you enable Horizontal layout check box, check boxes will be placed horizontally.

lookup_checkbox_list_hor

Radio button

List of values is displayed as set of radio buttons. A user can select only one value.

lookup_radio_button

If you enable Horizontal layout check box, radio buttons will be placed horizontally.

lookup_radio_button_hor

List page with search

Once Select button is clicked user is presented with the searchable lookup table. Lookup table appearance is fully customizable in Visual Editor. Select Allow multiple selection check box to allow users select multiple values.

lookup_list

Converted from CHM to HTML with chm2web Standard 2.85 (unicode)