Control Fields - INTEGER

General Settings

Figure1: General Settings Interface

Attributes:

• Data type - Define the application field type. When the field is defined as integer, it accepts only integer numbers.
• 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.
  
  

  

• Width - Width or chars quantity displayed on input object.
• Validation Image - Allows to show an image when validating a field.
• 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 Mask - Defines the field display mask. There are three masks types available and they can be merged:
  
  

  Character	Description
  9	Replaced by any numeric character entered by the user. (0-9)
  A	Replaced by any alpha charactere entered by the user. (A-Z,a-z)
  *	Replaced by any alphanumeric character (A-Z,a-z,0-9) entered by the user.

  Note: It is possible to combine two or more masks simultaneously, separated by semicolon with the larger mask starting it. The replacement occurs during data entry when amout of characters exceeds the smaller masks size.

  Examples:

  Field	Mask	Value entered	Value formatted
  Telephone number	+99 99 9999 - 9999	123456789012	+12 34 5678 - 9012
  Software Key (Only letters)	AAAA-AAAA-AAAA-AAAA	QWERTYUIASDFGHJK	QWER-TYUI-ASDF-GHJK
  Software Key (Letters and Numbers)	****-****-****-****	Q1W2E3R4T5Y6U7I8	Q1W2-E3R4-T5Y6-U7I8
  Car Plate	AAA - 9999	QWE1234	QWE - 1234
  Scriptcase's serial key	A999A999A999-****	D111H111G111DG2P	D111H111G111-DG2P
  Multiple Masks (Telephone)	9999-9999;(99) 9999-9999;9999 999 9999;+99 99 9999-9999

  
  
• Field size in database - Max length used when updating the table field.This value is automatically read from your DB Schema information.
  
• Hidden Field - Field is available for processing (Javascript or PHP) but it is not displayed.
• Label Field - Only displays the field value. Does not allow updates.

  Without field label attribute		Using field label attribute

• 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.

Values Format

Figure2: Values Format Interface

• Regional Settings - Apply regional settings formatting rules to the field. When selecting No the attributes Digit Grouping Separator, Negative Sign and Negative number format are displayed. (See regional settings).
• Digit Grouping - Define if the field will show the grouping separator.
• Maximum Size - Define the maximum size of the field.
• Minimum Value - Define the field minimum value.
• Maximum Value - Define the field maximum value.
• Decimal Precision - Define the field decimal precision.
• Digit Grouping Separator - Define the character used as unit separator.
• Decimal Separator - Define the character used as the decimal separator.
• Negative Sign - Define the character used as negative sign.
• Negative number format - Define the negative sign position (related to the value).
• Accept - The field can accepts only positive values, only negative values or positive and negative values.
• Show a calculator- Displays a calculator.
  

GRID LOOKUP

A resource to display a field description retrieved by SQL instruction. This resource uses AJAX technology (when exchanging information between server and browser).

See an example in the image below.

Image1: Grid Lookup.

Image2: Grid Lookup Interface.

Attributes:

• Use lookup to display field description - When selected enable the Grid lookup.
• SQL Statement - SQL statement to retrieve the data in the database. To build the statement it is possible to use the select wizard . For example, to display the customer name by the customer Id code use the following SQL statement :
  
  SELECT CompanyName FROM customers WHERE CustomerID = '{CustomerID}'
  
  

• Font - Font type used to display the lookup.
• Font Color - Font Color (in HTML format) used to display the lookup.
• Font Size - Font size used to display the lookup.
• EOFMessage - Message displayed when no info is retrieved.
• To use in Validation - Field automatic validation based in the lookup.
  

  

• Choose connection - Run SQL statement in different connection.

DISPLAY SETTINGS

Defines the CSS values for fields individually.

Figure 1: CSS Definition interface.

Title CSS

Attributes:

• 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.

Field CSS

Attributes:

• 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 that is to be applied to the font using a color palette.
• Background color - Used to select the color to be applied to the background of the application field 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 field.
• Border color - Used to select the border color to be applied to the field using a color palette.
• Horizontal Alignment - Sets the Search form field label to the desired location (left, right, center or justify).
• Vertical Alignment - Sets the Search form field label to the desired location (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
• Width - Sets the field width.
• Height - Sets the field height.
  

Object Input CSS

Attributes:

• Font - Used to select the font type that will be applied to the application object.

• Font Size - Used to select the font size that will be applied to the application object.
• Font Color - Used to select the color that is to be applied to the font using a color palette.
• Background color - Used to select the color to be applied to the background of the application object 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 object.
• Border color - Used to select the border color to be applied to the object using a color palette.
• Horizontal Alignment - Sets the Search form object label to the desired location (left, right, center or justify).
• Vertical Alignment - Sets the Search form object label to the desired location (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
• Width - Sets the object width.
• Height - Sets the object height.

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.

• Tooltip - Add text that will be displayed when the user hovers his mouse over the field.

  • Help Type:
    
    
    • Pop-up - Displays the help text in a pop-up window when the help icon displayed beside the field is clicked.
      
      
      
      
      
      
    • Hint - Displays the help text in a hint window when the mouse cursor hovers over the field.
      
      
      
      
      
      
    • Text - Display the specified help text beside the field.