Open topic with navigation

Control Fields - Select

Use a select (combobox)) object in form field.

General Settings


Figure1: General Settings Interface

Attributes:


Edition Lookup

Edition lookup enables a a list of values display on forms fields. Note on the screen below the State field, before and after enabling the edition lookup to display a select object containing a custom list of KEYS / VALUES. These lists of KEYS / VALUES can be defined in two ways: based on a database table (Automatic lookup ) or from custom arrays (lookup manual).



Before Lookup
After Lookup

Lookup method

There are two options available: Automatic, based in a SQL statement to feed the list of values or Manual which is based on a custom entered list of values.


Image1: Lookup method selection.


Edition Lookup - Automatic

Populates the select object dynamically, based on a SQL statement, note the SQL statement on the picture bellow, it is required to retrieve a key (insert / update) and a value to display on the object field on the SQL command.


Image1: Automatic lookup settings.

Attributes :


Edition Lookup - ManuaL


Enables a select object based on a list of values filled manually as an array. See picture bellow.


Image1: Manual edition lookup.

Attributes:

 Single Value  

Creates a simple select object, allows only one item selection.


Image2: Single value lookup settings.

 

 Multiple values (delimiter) 

Saves a single string on the table's field based on a list of values displayed. For example the selection: Sports, Movies and Traveling is saved on the table's field as a string like S;M;T. Note the default delimiter ( ; ) semicolon.


Image3: Multiple values lookup (delimiter)

 Multiple Values (Position) 

Saves on a string type field a list of values, for example it is possible to save answers to the topics: Gender , Civil Status and Hobby in only one table field. See in the table bellow the positions used by each answers on the saved string.

Label Value Start Size
Male M 1 1
Female F 1 1
Single S 2 1
Married M 2 1
Sports SP 3 2
Movies MO 3 2
Books BO 3 2
Traveling TR 3 2

Example: By selecting on the generated form: Male, Married and Books, the table's value saved a string is MMBO


Image4: Multiple Values lookup settings (position).

 

 Multiple Values (Binary)   

Allows to save a multiple selection as an integer value on a table field

See the examples bellow. On this lookup field interface the Value to each item is a integer number generated automatically.

Implicit Value Item Description
1 Sports
2 Movies
4 Traveling
8 Books
16 Music

The selection is converted into a integer which is the sum of the items implicit values before saving.

Example 1: By selecting Sports and Movies on the list of values, the saved value on table field is 3.

Implicit Value Item Description
1 Sports
2 Movies
4 Traveling
8 Books
16 Music

1 (Sports) + 2 (Movies) = 3

Example 2: By selecting Sports, Traveling and Books on the list of values, the saved value on table field is 13.

Implicit Value Item Description
1 Sports
2 Movies
4 Traveling
8 Books
16 Music

1(Sports) + 4 (Traveling) + 8 (Books) = 13

Image5: Multiple Values settings(Binary)

 


AJAX PROCESSING

Reloads other selection type fields (Select, CheckBox, Radio and DoubleSelect) when the field onChange event occours.
For example: a Select field "list of states", and a second one list of cities. It is possible to reload a cities list field by changing the state selected.


DISPLAY SETTINGS

Defines the CSS values for fields individually.




Figure 1: CSS Definition interface.

Title CSS

Attributes:

Field CSS

Attributes:

Object Input CSS

Attributes:


Help Settings

Documents the application. Create on-line instructions, describe business rules and save comments in the System Help to allow users to better understand the system and instruct them in the best way of interacting with the applications.


Figure 1: Help Configuration using a pop-up window.



Attributes: