Calendar: Form Fields - Double Select
Resource to display two values: A list with values to select and a list with selected values.
Image1: Interface of General Configuration.
- Data type - The data type double select is a drop-down object which allow the
multiple selection through two window of selection and a navigator
between them( << < > >> ).
- Label - Field title in application. For
example: a field is defined as client_name_fld in the table is displayed as Client Name.
- Initial Value (Type)- Fills the field with a pre defined value when the final user clicks in the "new" button.
- Defined Value - Uses the value entered on the Initial Value attribute. It is possible to recive parameters by using this funtionality. Example: By entering [var_logged_user] it is possible to use a session variable created on a login screen.
- System Date - Uses the server date.
Note: Using System Date option it is not required to enter a Initial value.
- Initial Value - The value displayed on field when using Defined Value option.
- Save Variable - Saves a session variable with a field value (to use in other applications). For example, in the login form the username is saved as a session variable and displayed in all the applications.
- Variable Name - Session variable name in which to save the field value (as defined above).
- Field size in database - Max length used when updating the table field.This value is automatically read from your DB Schema information.
- Disable Field - Define whether the field will be disabled in "insert mode", "update mode" or in "insert and update mode".
- HTML Type - HTML object used to display the field on generated form.
- SQL Type - Define the field type in the database.
It is possible to define a value saved for each table's field. It is frequentlly used when not displaying the field to the final user.
Image1: Database value interface.
- Defined value - You can specify a constant value or use global variables [global_var]. Very useful to passing parameters.
- Auto increment (automatic) - Used just when the database field is AUTO INCREMENT or similar, if your SGDB uses sequences to implement auto increment a field to enter the sequence name is displayed
- Auto increment (manual) - The generated form will handle the auto-increment feature by calculating the field's value automatically before inserting a record.
- Insert Date - When upgrading the field will be filled with data from the server.
- User IP - The field will get the IP of the machine that is accessing the application.
- Database Defined - The field value is assigned by the database . The field is not used in the process of updating. For example: will be updated through a trigger.
- Null - The field in SQL table is filled with (null).
Edition lookup enables a list of values display on forms fields.
Figure1: Edition lookup Interface
- SQL Select Statement - The query used to feed the select object on the form application. The developer shall use the pattern: "SELECT key_field , display_field FROM table ", retrieving always two fields.
NOTE: The key_field will be stored on the current field when updating / inserting a row.
It is possible to use complex SQL commands using many tables , views on it.
- Height - Select object rows quantity
- Delimiter - The character used to separate the items on generated string, the default delimiter is semicolon ( ; ).
- Reload form when value has changed - Forces a form reload upon selected field update.
- Display original and lookup value - Displays the field value and the lookup return value.
Original Value and lookup
- Separated by - Character used to separate the field value and the lookup return value. Only applicable when using the option Display original and lookup value.
- Use specific connection - Allows to run the SQL statement in other connection available on current project.
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.
Defines the CSS values for fields individually.
Figure 1: CSS Definition interface.
- Font - Used to select the font type that will be applied to the application field.
- Font Size - Used to select the font size that will be applied to the application object.
- Font Color - Used to select the color to be applied to the font using a color palette.
- Background color - Used to select the color that applies to the background of the application title using a color palette.
- Bold - Used to apply bold type to the font.
- Underlined - Used to apply an underlined type to the font.
- Border Size - Used to increase the border size of the title.
- Border Color - Used to select the border color to be applied to the title using a color palette.
- Horizontal Alignment - Sets the Search form label to the desired location (left, right, center or justify).
- Vertical Alignment - Sets the Search form label to the desired location (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
- Width - Sets the title width.
- Height - Sets the title height.
Object Input CSS
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.