Blog Elements

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

Knowledge Base, Lookup Controls, PowerForms HTML

Define Hierarchical Comboboxes

In common scenarios, there are linked lists that need to be included as hierarchical comboboxes in your forms. For example a typical Country/City scenario would include 2 lists. – Countries (ID, Title) – Cities (ID, Title, Country) where the Country field is a lookup for the Country List. In order to declare the comboboxes for […]

August 13, 2017/by Konstantinos

Knowledge Base, Lookup Controls, PowerForms HTML

Declaring a Lookup/Combobox Control

Available options: Choice Control (Single Selection) Declare a new ComboBox or LookupPicker control. Set the Target Field Name and in the Lookup Details tab, set the Lookup Static Values property adding all the required values concatenated by semicolon (;). For example for a rating field : Low;Medium;High During initial form customization, the form designer identifies […]

August 13, 2017/by Konstantinos

Knowledge Base, Lookup Controls, PowerForms HTML

Define Hierarchical Comboboxes

August 13, 2017/by Konstantinos

Knowledge Base, Lookup Controls, PowerForms HTML

Declaring a Lookup/Combobox Control

August 13, 2017/by Konstantinos

Define Hierarchical Comboboxes

In common scenarios, there are linked lists that need to be included as hierarchical comboboxes in your forms.

For example a typical Country/City scenario would include 2 lists.

– Countries (ID, Title)

– Cities (ID, Title, Country) where the Country field is a lookup for the Country List.

In order to declare the comboboxes for these lookups, you must follow the normal procedure to declare the combobox lookups (list url, list name, display field, value field) and then for the City combobox in the Lookup Details tab, you must select the Constraint By field (it is the field in the current form where the Country is stored) and the Match To (it is the Country field inside the Cities list).

After configuration, the form automatically identifies changes in the constraint fields and reloads the depedent list using the criteria provided.

For example, selecting France as country loads only the relevant cities in the CityForCascade combobox:

In our second example, we select USA as country and observe how CityForCascade loads the relevant cities once more:

Additional criteria can be applied to the list query by using the “Lookup Criteria” property. Instructions on how to add criteria can be found using the following links:

List Criteria

August 13, 2017/by Konstantinos

Declaring a Lookup/Combobox Control

Available options:

Choice Control (Single Selection)

Declare a new ComboBox or LookupPicker control. Set the Target Field Name and in the Lookup Details tab, set the Lookup Static Values property adding all the required values concatenated by semicolon (;).

For example for a rating field : Low;Medium;High

During initial form customization, the form designer identifies the choice controls and prepares the values for you.

Choice Control (Multiple Selections)

Declare a new MultiLookupPicker control, set the Target Field Name and set the Lookup Static Values property (values concatenated by semicolon). The MultiSelect propertyin the General tab should be checked.

For example : SALES;SUPPORT;SERVICE;MARKETING

Lookup Control (Single Selection)

Declare a new ComboBox or LookupPicker control

In the Lookup Details tab, set the Lookup Url (for example http://servername). As soon as the property is updated, the Lookup List combobox is filled with the available lists found. Select the required List and the required view (optional).

If you need you may set criteria to query the list in the field Lookup Criteria. The criteria are defined using the Criteria Editor.

Available values for the Operator are : Equals, NotEquals, Greater, GreaterOrEqual, Less, LessOrEqual, IsNull, IsNotNull, BeginsWith, Contains.

Available values for the type are : Text, Counter, DateTime, Lookup, Number

Next, select the Lookup Display Field (usually Title) and the Lookup Value Field (usually ID, unless you have selected to store a different field in your form).

If you decide to create a ComboBox field, all values are loaded during startup. For long lists, you should select the LookupPicker control. The LookupPicker allows the user to search for the required value by opening a popup dialog. If you still decide to present all the values during popup loading, you should check the Preload Lookup Data checkbox.

August 13, 2017/by Konstantinos

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

Full Sized Blog Element (Big Preview Pic)