Open topic with navigation

Checkbox

Allows you to use an object of type checkbox in the form field.

General Settings


Image1: General Settings Interface.

Attributes:



>Figure1: Field's Behavior Interface.

Attributes:


Edition Lookup

Edition lookup is a way to display checkbox list of values on forms fields. See the image below.

It is possible to populate the checkboxes objects based on a database table (Automatic lookup ) or from custom arrays (Manual lookup)



Before Lookup
 
After Lookup

Lookup Methods

There are available two options: 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 checkbox object dynamically, based on a SQL statement. Note the SQL statement on the picture below, it is required to retrieve a key ( insert / update) and a value to display on the object as fields on the SQL command.


Image2: Automatic lookup settings.

Attributes:


Edition Lookup - Manual




Allows the developer to manually crete a list of values saved in the application when there is no table available with the information needed. See picture below.



Image1: Edition Lookup Manual Interface.

Attributes :

 Single Value 

Selects only on value on the list.


Image2: Edition lookup - Single Value 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: Edition lookup - Multiple Values (delimiter) settings.

 Multiple Values (Position)  

Saves multiple values on a single string. Using the Multiple Values (Position) mode is required to enter the label, start position in the saved string and size in bytes each item. For example, to save Gender (1byte), Civil Status(1byte) and Hobby (2bytes) in a single use the table bellow (with the positions used by each item).

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: Edition lookup - Multiple Values (position) settings

 

 Multiple Values (Binary) 

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

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

 

AttributedValue Lookup Description
1 Sports
2 Movies
4 Books
8 Traveling
16 Music

The selection is converted into an 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.

AttributedValue Lookup Description
1 Sports
2 Movies
4 Books
8 Traveling
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.

AttributedValue Lookup Description
1 Sports
2 Movies
4 Books
8 Traveling
16 Music

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


Image5: Edition lookup - Multiple Values (binary) settings

 

 


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: