Feedback Print

Fields

In the menu item “Fields”, only the fields that were selected in the menu item “Select fields” will be displayed to configure.

List of application fields List of application fields

For each selected field will be displayed some atributes to be changed according of the data type selected.

Text

General Settings

Text field configuration Interface. Text field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Text, you can inform a Text value to the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Password Field : Formats the input of the field to have a password mask (*).

Password configuration Interface. Password configuration Interface.

  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field Mask : Defines the mask for field display. There are three types of masks that can be merged.
Character Description
9 Replaced by any numeric character entered by the user. (0-9)
A Replaced by any alpha character entered by the user. (A-Z,a-z)
* Replaced by any alphanumeric character (A-Z,a-z,0-9) entered by the user.

It is possible to merge two or more masks simultaneously, separated by a semi coma with the smallest mas at start. The replacement occurs when the user is typing in the number of characters form the smallest mask.

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
  • Validate with mask : Displays an error if the user does not complete the value based on the mask.
  • Complete to the Left : Allows to define the character that will be used to complete the value to the left that the user typed in to the max size of the field defined in the Field size in database option.
  • Field size in database : Determines the field size in bytes. It is used to determine the max size of characters that is allowed to type in.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through JavaScript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Save HTML tags : This option allows to save the HTML content of the field to the database.
  • Text input in Javascript : Allows to save javascript code informed in the field to the database.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values Format

Format of Values Interface. Format of Values Interface

  • Case Settings : Allows to convert the letters of the field when losing the focus. The options are:
    • Upper Case : All in Upper Case.
    • Lower Case : All in Lower Case.
    • Capitalize first word : Capitalizes the first letter of the word.
    • Capitalize all words : Capitalizes the first letter of all the words.
  • Minimum Size : Allows to define the minimum amount of characters accepted for the field.
  • Maximum Size : Allows to define the maximum amount of characters accepted for the field.
  • Allowed Characters : Allows to select a set of characters that can be typed into the field. The options are:
  • All : Allows any type of character to be typed into the field Characters configuration Interface.

  • Selected : Defines a set of characters allowed. Using the configuration below, will be allowed to type letters, numbers and other characters (defined in the attribute More). The letters a, b and c (defined in the Less Attribute) are not allowed. Characters configuration Interface.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Ajax Processing

Ajax Processing configuration Interface. Ajax Processing configuration Interface.

Allows to define the field that will be reloaded when selecting a value that has the (onChange) trigger.

For example: a field of the type select with a list of states, and another select field with a list of cities. When selecting a state, the cities list is reloaded.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Multiple Lines Text

General Settings

Multiple Lines Text field configuration Interface. Multiple Lines Text field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Multiple Lines Text , you can inform a Text value to the field in multiple lines.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : you will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Lines : Allows to define the amount of lines that the field will have at start.

  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field size in database : Determines the field size in bytes. it is used to determine the max size of characters that is allowed to type in.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through JavaScript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Save HTML tags : This option allows to save the HTML content of the field to the database.
  • Text input in Javascript : Allows to save javascript code informed in the field to the database.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values Format

Format of Values Interface. Format of Values Interface

  • Case Settings : Allows to convert the letters of the field when losing the focus. The options are:
    • Upper Case : All in Upper Case.
    • Lower Case : All in Lower Case.
    • Capitalize first word : Capitalizes the first letter of the word.
    • Capitalize all words : Capitalizes the first letter of all the words.
  • Minimum Size : Allows to define the minimum amount of characters accepted for the field.
  • Maximum Size : Allows to define the maximum amount of characters accepted for the field.
  • Allowed Characters : Allows to select a set of characters that can be typed into the field. The options are:
  • All : Allows any type of character to be typed into the field Characters configuration Interface.

  • Selected : Defines a set of characters allowed. Using the configuration below, will be allowed to type letters, numbers and other characters (defined in the attribute More). The letters a, b and c (defined in the Less Attribute) are not allowed. Characters configuration Interface.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Number

General Settings

Integer field configuration Interface. Integer field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Integer, you can inform number values to the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it’s not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field Mask : Defines the mask for field display. There are three types of masks that can be merged.
Character Description
9 Replaced by any numeric character entered by the user. (0-9)
A Replaced by any alpha character entered by the user. (A-Z,a-z)
* Replaced by any alphanumeric character (A-Z,a-z,0-9) entered by the user.

It is possible to merge two or more masks simultaneously, separated by a semi coma with the smallest mas at start. The replacement occurs when the user is typing in the number of characters form the smallest mask.

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
  • Validate with mask : Displays an error if the user does not complete the value based on the mask.
  • Complete to the Left : Allows to define the character that will be used to complete the value to the left that the user typed in to the max size of the field defined in the Field size in database option.
  • Field size in database : Determines the field size in bytes. It is used to determine the max size of characters that is allowed to type in.
  • Hidden Field : This option makes the field hidden, but still allows it is value to be processed through JavaScript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the number of the field. When not enabled, the attributes Digit Grouping Separator, Decimal Separator, Negative sign and Negative number format.
  • Digit grouping : Defines if the field will display the digits separator.
  • Maximum Size : Determines the max size of the field.
  • Minimum Value : Determines the min value of the field.
  • Maximum Value : Determines the max value of the field.
  • Digit Grouping Separator : Defines the character that is used to seperate the thousand.
  • Negative sign : Defines the chatacter that will be used to display negative numbers.
  • Negative number format : Defines the position of the Negative sign em relation to the value.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.
  • Show a calculator : Displays an icon next to the field, which alles the user to calculate a value for the field.
  • Use Spin : Atives an option to increment and decrement values from the field.
    • Smaller increment of Spin : Defines the min range of the Spin.
    • Increase higher Spin : Defines the max range of the Spin.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Decimal

General Settings

Decimal field configuration Interface. Decimal field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Decimal, you can inform decimal values to the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it’s being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that’ll receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the number of the field. When not enabled, the attributes Digit Grouping Separator, Decimal Separator, Negative sign and Negative number format.
  • Digit grouping : Defines if the field will display the digits separator.
  • Maximum Size : Determines the max size of the field.
  • Minimum Value : Determines the min value of the field.
  • Maximum Value : Determines the max value of the field.
  • Decimal Precision : Defines the amount of decimal places for the field.
  • Digit Grouping Separator : Defines the character that is used to seperate the thousand.
  • Decimal Separator : Defines the decimal separator.
  • Negative sign : Defines the chatacter that will be used to display negative numbers.
  • Negative number format : Defines the position of the Negative sign em relation to the value.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.
  • Show a calculator : Displays an icon next to the field, which alles the user to calculate a value for the field.
  • Auto-complete with zeros : If enabled, it automatically informs the decimal places when not specified. If disabled, the user needs to always inform the decimal value.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Currency

General Settings

Currency field configuration Interface. Currency field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Currency, you can currency values to the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the number of the field. When not enabled, the attributes Digit Grouping Separator, Decimal Separator, Negative sign and Negative number format.
  • Digit grouping : Defines if the field will display the digits separator.
  • Currency symbol usage : Defines if the field will display the Currency Symbol of the Regional Settings.
  • Maximum Size : Determines the max size of the field.
  • Minimum Value : Determines the min value of the field.
  • Maximum Value : Determines the max value of the field.
  • Decimal Precision : Defines the amount of decimal places for the field.
  • Digit Grouping Separator : Defines the character that is used to separate the thousand.
  • Decimal Separator : Defines the decimal separator.
  • Negative sign : Defines the character that will be used to display negative numbers.
  • Negative number format : Defines the position of the Negative sign em relation to the value.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.
  • Show a calculator : Displays an icon next to the field, which aids the user to calculate a value for the field.
  • Auto-complete with zeros : If enabled, it automatically informs the decimal places when not specified. If disabled, the user needs to always inform the decimal value.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Date

General Settings

Date field configuration Interface. Date field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Date, you can inform a date.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it is value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the dates of the field. When not enabled, it will be displayed the date separator attribute.
  • Date separator : Allows you to inform the separator symbol for the date.
  • First Day : Define the first day of the week.
  • Display : Select the format of the day for display.
  • Internal Format : Allows to define the format the field when the SQL type is different from Date. You need to use the characters Y, M and D that correspond to Year, Month and Day.
  • Use Combo-box : Allows you to select the date using a combo-box.
  • Minimum Date :
    • Fixed Date : Inform the minimum date allowed presented in the selected date format.
    • Current Date : Clicking on the icon next to the text field, ScriptCase offers the following options:
      • Actual date : It will place the current date as the max allowed date.
      • Actual date with increment : The minimum date will be the current date (+) the days or months or years that you want to increment.
      • Actual date with decrement : The minimum date will be the current date (-) the days or months or years that you want to decrement.
  • Maximum Date :
    • Fixed Date : Inform the minimum date allowed presented in the selected date format.
    • Current Date : Clicking on the icon next to the text field, ScriptCase offers the following options:
      • Actual date : It will place the current date as the max allowed date.
      • Actual date with increment : The minimum date will be the current date (+) the days or months or years that you want to increment.
      • Actual date with decrement : The minimum date will be the current date (-) the days or months or years that you want to decrement.
  • Display Format : Enables the Date format beside the field when informing the date.
  • Display Calendar : Enables the a calendar icon beside the field, this allows to select the date from a calendar with the format already setup.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Hour

General Settings

Time field configuration Interface. Time field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Time, you can inform a time to this field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the data type of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the dates of the field. When not enabled, it will be displayed the date separator and time separator attributes.
  • Time separator : Allows you to inform the separator symbol for the time.
  • Display : Select the format of the time for display.
  • Internal Format : Allows to define the format the field when the SQL type is different from TIME. You need to use the characters HH, II, and SS that correspond to Day, Hour, Minutes and Seconds.
  • Display Format : Enables the Time format beside the field when informing the time.
  • Use Timepicker : Use the JQuery plugin to choose the time.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Date and Hour

General Settings

Date and Time field configuration Interface. Date and Time field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Datetime, you can inform a date and time to this field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it is value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values format

Format of Values with Regional Settings. Format of Values with Regional Settings.

  • Regional Settings : Allows to apply the Regional Settings to format the dates of the field. When not enabled, it will be displayed the date separator and time separator attributes.
  • Date separator : Allows you to inform the separator symbol for the date.
  • Time separator : Allows you to inform the separator symbol for the time.
  • Display : Select the format of the day/time for display.
  • Internal Format : Allows to define the format the field when the SQL type is different from DATETIME. You need to use the characters Y, M, D , HH, II, and SS that correspond to Year, Month, Day, Hour, Minutes and Seconds.
  • Display Format : Enables the Date and Time format beside the field when informing the date.
  • Group Date and Time : Groups the date and time in the same field.
  • Display Calendar : Enables the a calendar icon beside the field, this allows to select the date from a calendar with the format already setup.
  • New Calendar : Show the new jquery calendar, or the old calendar.
  • Years Limit : The amount of years that will display in the calendar.
  • View week number : Display the week number in the calendar.
  • Additional months : Display additional months in the calendar.
  • Show Combo year and month : Allows you to select the year and month using a combo-box.
  • Decimal of seconds : Defines the amount of decimals for the seconds.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

HTML Image

General Settings

HTML Image field Configuration Interface. HTML Image field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as HTML Image, it allows to place an image to the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Image : Defines an image that will be displayed. The icon “Select Image”, lists all the standard images from scriptcase and also the image that you have uploaded to scriptcase. The icon “Upload an image” allows the developer to send an image to the server which is from another machine.
  • Border : Border size for the image in Pixels.
  • Width : Define the width of the image in Pixels.
  • Height : Define the height of the image in Pixels.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Label

General Settings

Label field Configuration Interface. Label field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as label, the field only display the output of the value .
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Text : You can inform the text that will display beside the field.
  • Reload : When enabled, make the text informed for the field to become a link to reload the form when clicked.
  • Position : Allows to position the field in the chosen block.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Card

General Setting

Credit Card Number Configuration Interface. Credit Card Number Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Credit Card Number, the field verifies if the value is valid.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : It is created a placeholder on the field with the text informed.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field size in database : Determines the size in bytes of the fields. It is used to determine the max amount of characters to be typed in.
  • Field Mask : Defines the display mask for the field. There are three types of masks that can be merged.
Character Description
9 Represents a numeric character (0-9)
A Represents an alpha numeric character (A-Z,a-z)
* Represents any alpha numeric character (A-Z,a-z,0-9) typed by the user.

It is possible to merge two or more masks simultaneously, separated by a semi coma with the smallest mask at start. The replacement occurs when the user is typing when the lowest amount of character exceeds.

Examples of Masks

Field Mask Informed Value Formatted Value
Telephone Number +99 99 9999 - 9999 123456789012 +12 34 5678 - 9012
Software Key (Only Numbers) AAAA-AAAA-AAAA-AAAA QWERTYUIASDFGHJK QWER-TYUI-ASDF-GHJK
Software Key (Letters an Numbers) **---** Q1W2E3R4T5Y6U7I8 Q1W2-E3R4-T5Y6-U7I8
License Plates AAA - 9999 QWE1234 QWE - 1234
ScriptCase License A999A999A999-** D111H111G111DG2P D111H111G111-DG2P
Multiple Masks (Telephone) 9999-9999;(99)9999-9999; 9999 999 9999 +99 99 9999-9999
  • Hidden Field : This option makes the field hidden, but still allows it is value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Card type

General Settings

Credit Card field configuration Interface. Credit Card field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Credit Card , it’ll setup a combo-box for you to select a creditcard type.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it’ll be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that’ll receive the field value.
  • Field size in database : Determines the field size in bytes. It’s used to determine the max size of characters that’s allowed to type in.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through JavaScript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that’ll be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values Format

Format of Values Interface. Format of Values Interface.

  • Credit Card : Allows to define which cards will be listed and their internal value.
  • Use Title/Deny : Allows to inform a new value if the one of the previous options (American Express, Diners, MasterCard and Visa) wasn’t chosen. The label and the value of this option are defined as the Negative Value and the Title.
  • Negative value : Value of the new option if the one of the previous options (American Express, Diners, MasterCard and Visa) wasn’t chosen.
  • Title : Label of the new option if the one of the previous options (American Express, Diners, MasterCard and Visa) wasn’t chosen.
  • Related Field : You’ll inform which of the fields contains the values of a Credit Card Number so that the validations can be done correctly.
  • Reload Form : Reloads the form when the field’s value is modified.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

E-mail

General Settings

Email field configuration Interface. Email field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Email, the field applies validations for an email format.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Display Icon : Displays the Email icon next to the field.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the data type of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

URL

General Settings

URL field configuration Interface. URL field configuration Interface.

  • Data Type : Define the type of field for the application. When set to URL, you can inform a Link value to the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through JavaScript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Display Icon : Displays an icon beside the field.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • Show the URL as a clickable link : Sets the content of the field to clickable link.
  • Target handling where the link will open : Target where the the lick will direct to after being clicked
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

HTML Color

General Settings

HTML Color field configuration Interface. HTML Color field configuration Interface.

  • Data Type : Define the type of field for the application. When set to HTML Color, you can select a color to be used in the form.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Validation Image : Allows to display an image next to the field when it is being validated.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Use lookup to display the field description. : When enabled, the lookup settings is enabled and opens more settings.
  • SQL Command : Defines the SQL command that is going to recover the vales from the database. To build a SQL command, it is possible to use the SQL Builder tool. The SQL format needs to have the following format:

SELECT Field_displayed FROM table WHERE Key_Field = '{Form_Field}'

The Form field needs to be referenced buy the curly brackets {}. While running the application, the field within the curly brackets is replaced by it’s value in the table.

  • Font : Defines the font used to display the lookup.
  • Font Color : Defines the color in HEX for the lookup display.
  • Font Size : Defines the font’s size in the lookup display.
  • EOF Message : Defines a message that will be displayed if there is not any results for the record.
  • Use in validation : When enabled, it will generate an automatic validation based on the lookup, in case there is not any records found, the message will display as a warning (when Updating or Including a record).

Lookup Settings validation Interface. Lookup Settings validation Interface.

  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

HTML Editor

Settings

HTML Editor field configuration Interface. HTML Editor field configuration Interface.

  • Data Type : Define the type of field for the application. When set to HTML Editor, you can inform any type of character and they will be saved in HTML form.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Height : Inform the Height in pixels for the HTML Editor.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • SQL Type : Informs the data type of field in the database.

Toolbar

HTML Editor toolbar settings Interface. HTML Editor toolbar settings Interface.

  • Properties
    • Position : Location of the HTML Editor toolbar
    • Alignment : Toolbar button alignment
    • Status : Status Bar Display (Do not Display, Top and Bottom).
    • Amount : The Amount of lines of the HTML Editor toolbar.
  • Button Organization : Allows to position the toolbar buttons.
  • Preview : You can visualize the toolbar according to the previous settings.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Localization

General Settings

Location field Configuration Interface. Location field Configuration Interface.

  • Data Type : Define the type of field for the application. When it’s defined as Location, you will see a combobox with the Languages that are part of the Project Properties.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Reload : When enabled, make the text informed for the field to become a link to reload the form when clicked.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Theme

General Settings

Theme field configuration Interface. Theme field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Theme, you view a combo box with the list of themes that are set to your project.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Reload : Reload the form after modifying the value.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Youtube

General Settings

YouTube field Configuration Interface. YouTube field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a YouTube, it allows to display a video from youtube on the field.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Display Mode : Defines how the you video will display in the application.
  • Width : Width of the video in pixels.
  • Height : Height of the video in pixels.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • SQL Type : Informs the datatype of field in the database.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Google Maps

General Settings

Google Maps field Configuration Interface. Google Maps field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as Google Maps, it will use the Google Maps API to display the map in the Form Applications
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Home : Defines what type of parameters will be used in the API.

Home Configuration Interface. Home Configuration Interface.

  • Display Mode : Indicates the display of the map. It can be opened in a Modal or in a new Window.
  • Width : Defines the width of the map that is going to be displayed.
  • Height : Defines the height of the map that is going to be displayed.
  • Zoom : Defines the initial Zoom (available from the Google API) of the Map location.
  • API Key : API Key for authorization to use Google Maps in the Application. (Required only for the versions 2 or earlier of the Google API.)

The API Key is a unique key, composed by a string(text) alphanumeric, which is the license to use the service. When you subscribe to use the service, the key is tied to the domain and the directory of the server. All the pages that use the API needs to be in the same directory that was used for the subscription. In case you have a web server on your local machine, you just need to possess a key for testing, and to do this you only need to place http://localhost in the domain of the subscription.

To get your API Key access the site by clicking here

  • Link Type : Defines how the link will be displayed.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Image (Database)

General Settings

Image (Database) field Configuration Interface. Image (Database) field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as an Image ( Database), all the Images files are stored and loaded directly from the Database.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Image Border : Width of the Image border. Value in Pixels.
  • Image Height : Image height size. Value in Pixels.
  • Image Width : Image width size. Value in Pixels.
  • Progress bar : Displays a progress bar when sending the files to the server.
  • Upload area : Displays a drag and drop area to upload the file.
  • Maintain Aspect : Maintains the original aspect ratio of the image when resizing it.
  • Display link only : When enabled, you will be presented with a link to open the image in another image with the original size of the image ( without using the redimensioning ).
  • Open in Another Window : Allows to open the image in another window.
  • Extensions to allow : Extensions allowed to upload, separated by a semi coma (;). If left in blank, all the extensions are allowed. e.g. docx;jpg;png;xls
  • Hidden Field : This option makes the field hidden, but still allows its value to be processed through JavaScript or PHP.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Multi-Upload

This option allows to upload multiple files and store them on a table referencing a record from another table. To use this option you first need to create a virtual field._

Multi-Upload Configuration. Multi-Upload Configuration.

  • Amount of columns : Amount of columns to displays the files in the Field.
  • Position of the delete : Checkbox option to delete files position.
  • Position on the upload : Position of the records when uploading.
  • Show status : Display the upload status.
  • Table : Select the table that will store the information of the files when uploading.

After selecting the table, you will see a list of all the fields of the chosen table, where you will associate the parameters for each field when inserting a new record or updating an existing record.

Multi-Upload fields of the table Configuration. Multi-Upload fields of the table Configuration.

  • File Name : Obtains the name of the file that is being loaded.
  • Upload : Obtains the binary value of the file.
  • Auto Increment : Used only when field in the database in an auto increment or similar.
  • Manual Increment : The form will be responsible for managing the auto-increment, calculating the value of the field before inserting the record.
  • Foreign Key : Associates the file with a value of a field in the current form.
  • Defined : You can specify a constant value or use a global variable. [global_var]
  • Date of Insertion : Obtains the data of the server when inserting the record.
  • Datetime de Insertion : Obtains the data and time of the server when inserting the record.
  • User IP : The field will contain the IP of the computer that is accessing the application.
  • Calculated by the Database : The value of the field is applied in the database.
  • Calculated by the Database if empty : The value of the field is applied in the database if not informed by the application.
  • Null : The field will the null value.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Imagem (File Name)

General Settings

Image (File Name) field Configuration Interface. Image (File Name) field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as an Image (File Name), all the images files are stored and loaded in a directory of the server (Only the image name is stored in the database).
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Image Border : Width of the Image border. Value in Pixels.
  • Image Height : Image height size. Value in Pixels.
  • Image Width : Image width size. Value in Pixels.
  • Maintain Aspect : Maintains the original aspect ratio of the image when resizing it.
  • Progress bar : Displays a progress bar when sending the files to the server.
  • Upload area : Displays a drag and drop area to upload the file.
  • Increment file : Increments the file name if the theirs an existing one with the same name in the upload folder.
  • Subfolder : Subfolder’s name that the files are stored. The is sub folder is relative to the directory defined for the Document upload (see the Settings). It is possible to use global variables or local variables to format the name of the subfolder.
  • Create Subfolder : When enabled, it creates the subfolder if not already created.
  • Image Caching : Time in minutes that the image cache will be stored.
  • Hide image name: When enabled, only the image will be displayed without it is name.
  • Files Deletion: Deletes the files from the directory when the record is deleted from the database.
  • Display link only : WHen enabled, you will be presented with a link to open the image in another image with the original size of the image ( without using the redimensioning ).
  • Open in Another Window : Allows to open the image in another window.
  • Extensions to allow : Extensions allowed to upload, separated by a semi coma (;). If left in blank, all the extensions are allowed. e.g. docx;jpg;png;xls
  • Hidden Field : This option makes the field hidden, but still allows its value to be processed through JavaScript or PHP.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Multi-Upload

This option allows to upload multiple files and store them on a table referencing a record from another table. To use this option you first need to create a virtual field._

Multi-Upload Configuration. Multi-Upload Configuration.

  • Amount of columns : Amount of columns to displays the files in the Field.
  • Position of the delete : Checkbox option to delete files position.
  • Position on the upload : Position of the records when uploading.
  • Show status : Display the upload status.
  • Table : Select the table that will store the information of the files when uploading.

After selecting the table, you will see a list of all the fields of the chosen table, where you will associate the parameters for each field when inserting a new record or updating an existing record.

Multi-Upload fields of the table Configuration. Multi-Upload fields of the table Configuration.

  • File Name : Obtains the name of the file that is being loaded.
  • Upload : Obtains the binary value of the file.
  • Auto Increment : Used only when field in the database in an auto increment or similar.
  • Manual Increment : The form will be responsible for managing the auto-increment, calculating the value of the field before inserting the record.
  • Foreign Key : Associates the file with a value of a field in the current form.
  • Defined : You can specify a constant value or use a global variable. [global_var]
  • Date of Insertion : Obtains the data of the server when inserting the record.
  • Datetime de Insertion : Obtains the data and time of the server when inserting the record.
  • User IP : The field will contain the IP of the computer that is accessing the application.
  • Calculated by the Database : The value of the field is applied in the database.
  • Calculated by the Database if empty : The value of the field is applied in the database if not informed by the application.
  • Null : The field will the null value.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Document (Database)

General Settings

Document (Database) field Configuration Interface. Document (Database) field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Document ( Database), all the document files are stored and loaded directly from the Database.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Icon : Displays an icon beside the field to identify the type of document.
  • Progress bar : Displays a progress bar when sending the files to the server.
  • Upload area : Displays a drag and drop area to upload the file.
  • File Name : Defines the field that contains the name of the document stored in the database ( the field that contains this information also needs to be stored in the database).
  • File Size : Defines the field that conatins the file size.
  • Extensions to allow : Extensions allowed to upload, separated by a semi coma (;). If left in blank, all the extensions are allowed. e.g. docx;jpg;png;xls
  • Hidden Field : This option makes the field hidden, but still allows its value to be processed through JavaScript or PHP.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Multi-Upload

This option allows to upload multiple files and store them on a table referencing a record from another table. To use this option you first need to create a virtual field._

Multi-Upload Configuration. Multi-Upload Configuration.

  • Amount of columns : Amount of columns to displays the files in the Field.
  • Position of the delete : Checkbox option to delete files position.
  • Position on the upload : Position of the records when uploading.
  • Show status : Display the upload status.
  • Table : Select the table that will store the information of the files when uploading.

After selecting the table, you will see a list of all the fields of the chosen table, where you will associate the parameters for each field when inserting a new record or updating an existing record.

Multi-Upload fields of the table Configuration. Multi-Upload fields of the table Configuration.

  • File Name : Obtains the name of the file that is being loaded.
  • Upload : Obtains the binary value of the file.
  • Auto Increment : Used only when field in the database in an auto increment or similar.
  • Manual Increment : The form will be responsible for managing the auto-increment, calculating the value of the field before inserting the record.
  • Foreign Key : Associates the file with a value of a field in the current form.
  • Defined : You can specify a constant value or use a global variable. [global_var]
  • Date of Insertion : Obtains the data of the server when inserting the record.
  • Datetime de Insertion : Obtains the data and time of the server when inserting the record.
  • User IP : The field will contain the IP of the computer that is accessing the application.
  • Calculated by the Database : The value of the field is applied in the database.
  • Calculated by the Database if empty : The value of the field is applied in the database if not informed by the application.
  • Null : The field will the null value.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Document (File Name)

Multi-Upload

This option allows to upload multiple files and store them on a table referencing a record from another table. To use this option you first need to create a virtual field._

Multi-Upload Configuration. Multi-Upload Configuration.

  • Amount of columns : Amount of columns to displays the files in the Field.
  • Position of the delete : Checkbox option to delete files position.
  • Position on the upload : Position of the records when uploading.
  • Show status : Display the upload status.
  • Table : Select the table that will store the information of the files when uploading.

After selecting the table, you will see a list of all the fields of the chosen table, where you will associate the parameters for each field when inserting a new record or updating an existing record.

Multi-Upload fields of the table Configuration. Multi-Upload fields of the table Configuration.

  • File Name : Obtains the name of the file that is being loaded.
  • Upload : Obtains the binary value of the file.
  • Auto Increment : Used only when field in the database in an auto increment or similar.
  • Manual Increment : The form will be responsible for managing the auto-increment, calculating the value of the field before inserting the record.
  • Foreign Key : Associates the file with a value of a field in the current form.
  • Defined : You can specify a constant value or use a global variable. [global_var]
  • Date of Insertion : Obtains the data of the server when inserting the record.
  • Datetime de Insertion : Obtains the data and time of the server when inserting the record.
  • User IP : The field will contain the IP of the computer that is accessing the application.
  • Calculated by the Database : The value of the field is applied in the database.
  • Calculated by the Database if empty : The value of the field is applied in the database if not informed by the application.
  • Null : The field will the null value.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Barcode

General Settings

Configuration Interface of the Barcode Field. Configuration Interface of the Barcode Field.

  • Data Type : DataType of the field for the application.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Disabled Field : Defines if the field will be disabled in the “Insert Mode” , “Update Mode” or in “Insert and Update Mode”.
  • SQL Type : Database field type.

Barcode

Configuration Interface of the Barcode Field. Configuration Interface of the Barcode Field.

  • Type : Type of Barcode.
  • Text : Barcode Text for illustration purposes.

  • There are 18 types of barcodes, that are listed below:

Barcode configuratio interface. Barcode configuratio interface.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Select

General Settings

Select field configuration Interface. Select field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Select, you can select multiple option from a combobox (Select Field).
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.
  • Use Select2 : Uses the new component for data selection, allowing searches within the select.
  • Display Select2 search area : Sets whether to display the search field within Select2.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field size in database : Determines the field size in bytes. It is used to determine the max size of characters that is allowed to type in.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query).

    Selecting the lookup type.

    • Lookup Method - Automatic

      Lookup used to list the values that will be displayed on the Checkbox field. These values will be recovered dynamically using the Select command.

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure “SELECT key_field , display_field FROM table”.

      The value of the key_field will be stored in the table field.

      • Multiple Values : When enabled, allows to select more than one item from the list, separated by a delimitator.

        Seleção de multiplos valores em campo select.

        • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Height : Defines the height for the select object.
      • Use title : Allows to display a line of a title on the select object (Title Attribute) associated to a value informed manually (Title internal value).

        Selecting and using the title on the select field.

        • Title internal value : Value Saved to the field when the line of the title is selected in the object.
        • Title : Text displayed on the title of the Select object.
      • Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.
      • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

        Displaying the original lookup.

        • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

      • Link : Allows to create a link to another form allowing to manipulate the list displayed on the select field. After the manipulation, the select object it updated automatically.

        Displaying link to automatic lookup.

    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

          Manual Lookup Interface Setting up Single Value Lookup

          • Label : Text that will be displayed in the item list of the select field.
          • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
          • Default : With this option enabled, the selected item will be inserted to the table when committed.
          • Height : Defines the height for the select object.
        • Multiple Values (delimiter)

          You can store various values for the select field. The values are separated by the informed delimiter. For example: the combination Sport, Cinema and Tourism selected in form will be stored like E;C;T in case the delimiter is ; (semi coma).

          Interface de configuração de Lookup de edição manual Setting up Multiple Values (delimiter)

          • Label : Text that will be displayed in the item list of the select field.
          • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
          • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
          • Height : Defines the height for the select object.
        • Multiple Values (position)

          Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.

          For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.

          The example below:

          Label Valor Inicio Tamanho
          Man M 1 1
          Women W 1 1
          Divorced D 2 1
          Single S 2 1
          Study SD 3 2
          Sports SP 3 2
          Read RD 3 2

          Example: Of you choose Man, Single and Read, no banco de dados seria armazenado o seguinte valor MSRD.

          Manual Lookup Interface Setting up Multiple Values (position)

          • Label : Text that will be displayed in the item list of the select field.
          • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
          • Negative : Value to be saved in the table in case there is not any valued selected on the field.
          • Start : Starting position of the string that is going to be stored. The first position is always 1.
          • Size : Amount of bytes that is going to occupy in the string.
          • Height : Defines the height for the select object.
        • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.

          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):

          Attribute Value Lookup Description
          1 Sports
          2 Culture
          4 Pleasure
          8 Reading
          16 Music

          To store the data, it is done an internal sum of the decimal number. See the examples below.

          Example 1: If the options Sports and Culture were selected, the number stored in the table would be 3.

          Attribute Value Lookup Description
          1 Sports
          2 Culture
          4 Pleasure
          8 Reading
          16 Music

          1 (Sports) + 2 (Culture) = 3

          Example 2: If the options Sports, Pleasure and Reading were selected, the number stored in the table would be 13.

          Attribute Value Lookup Description
          1 Sports
          2 Culture
          4 Pleasure
          8 Reading
          16 Music

          1 (Sports) + 4 (Pleasure) + 8 (Reading) = 13

          Interface de configuração de Lookup de edição manual Configuração do lookup de edição Múltiplos Valores (Binário)

          • Label : Text that will be displayed in the item list of the select field.
          • Height : Defines the height for the select object.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use title : Allows to display a line of a title on the select object (Title Attribute) associated to a value informed manually (Title internal value).

        Selecting and using the title on the select field.

        • Title internal value : Value Saved to the field when the line of the title is selected in the object.
        • Title : Text displayed on the title of the Select object.
      • Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.
      • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

        Displaying the original lookup. Displaying the original lookup.

      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Lookup Method - Actual value

This lookup is used to list all the values in the selected field.

This lookup will apply a “distinct” to your SQL query.

Ajax Processing

Ajax Processing configuration Interface. Ajax Processing configuration Interface.

Allows to define the field that will be reloaded when selecting a value that has the (onChange) trigger.

For example: a field of the type select with a list of states, and another select field with a list of cities. When selecting a state, the cities list is reloaded.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Double Select

General Settings

Double Select field configuration Interface. Double Select field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Double Select, your allowed to have multiple options selected.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field size in database : Determines the size in bytes of the fields. It is used to determine the max amount of characters to be typed in.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP. .
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the data type of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field. Automatic Lookup Interface. Automatic Lookup Interface..

  • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure “SELECT key_field , display_field FROM table”.

The value of the key_field will be stored in the table field.

  • Height : Allows to define the height(lines) of the field interface.
  • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
  • Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.
  • Display original and lookup value : Displays the value of the field and the value returned from the lookup. Displaying the original lookup.
  • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Ajax Processing

Ajax Processing configuration Interface. Ajax Processing configuration Interface.

Allows to define the field that will be reloaded when selecting a value that has the (onChange) trigger.

For example: a field of the type select with a list of states, and another select field with a list of cities. When selecting a state, the cities list is reloaded.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

CheckBox

General Settings

Checkbox field configuration Interface. Checkbox field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Checkbox, your allowed to have multiple options selected.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field size in database : Determines the size in bytes of the fields. It is used to determine the max amount of characters to be typed in.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP. .
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query). Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Lookup used to list the values that will be displayed on the Checkbox field. These values will be recovered dynamically using the Select command.

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure “SELECT key_field , display_field FROM table”.

      The value of the key_field will be stored in the table field.

      • Delimiter : Defines the character used to separate the values selected in the form. Only inform a value to this field if you need to separate the selected options with a different delimiter then (;).
      • Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.
      • Option check all : Displays two options on the field to check and uncheck all.

        Automatic Lookup Interface.

      • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

        Displaying the original lookup.

        • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Lookup Type : Define the functionality of the lookup, being: Single Value, Multiple Values (delimiter), Multiple Values (position) and Multiple Values (binary).
        • Single Value :

          Manual Lookup Interface Setting up Single Value Lookup

          • Label : Text that will be displayed in the item list of the checkbox.
          • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
          • Default : With this option enabled, the selected item will be inserted to the table when committed.
          • Columns : Allows you to inform the amount of columns, for the list of items.
        • Multiple Values (delimiter)

          You can store various values for the checkbox field. The values are separated by the informed delimiter. For example: the combination Sport, Cinema and Tourism selected in form will be stored like E;C;T in case the delimiter is ; (semi coma).

          Manual Lookup Interface Setting up Multiple Values (delimiter)

          • Label : Text that will be displayed in the item list of the checkbox.
          • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
          • Delimiter Characters used to separate Multiple Values in the table field. If not informed, the default delimiter is a semi coma (;).
          • Columns : Allows you to inform the amount of columns, for the list of items.
        • Multiple Values (position)

          Allows to store a diversity of information selected on the field in only one string. For this information to be added, you need to inform the label, initial position and the number of bytes that each information occupies on a string.

          For this example, Gender, Marital status and Hobby were used. Gender uses one byte as does the Martial Status, the Hobby will use two bytes.

          The example below:

          Label Value Start Size
          Man M 1 1
          Women W 1 1
          Divorced D 2 1
          Single S 2 1
          Study SD 3 2
          Sports SP 3 2
          Read RD 3 2

          Example: Of you choose Man, Single and Read, no banco de dados seria armazenado o seguinte valor MSRD.

          Manual Lookup Interface Setting up Multiple Values (position)

          • Label : Text that will be displayed in the item list of the checkbox.
          • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
          • Negative : Value to be saved in the table in case there is not any valued selected on the field.
          • Start : Starting position of the string that is going to be stored. The first position is always 1.
          • Size : Amount of bytes that is going to occupy in the string.
          • Columns : Allows you to inform the amount of columns, for the list of items.
        • Multiple Values (binary)

          Allows to store a diversity of information selected on the field in only one value.

          In this example uses the following list (although it is not informed when inserting values to the list, each item has a value applied automatically according to the order):

          Attribute Value Lookup Description
          1 Sports
          2 Culture
          4 Pleasure
          8 Reading
          16 Music

          To store the data, it is done an internal sum of the decimal number. See the examples below.

          Example 1: If the options Sports and Culture were selected, the number stored in the table would be 3.

          Attribute Value Lookup Description
          1 Sports
          2 Culture
          4 Pleasure
          8 Reading
          16 Music

          1 (Sports) + 2 (Culture) = 3

          Example 2: If the options Sports, Pleasure and Reading were selected, the number stored in the table would be 13.

          Attribute Value Lookup Description
          1 Sports
          2 Culture
          4 Pleasure
          8 Reading
          16 Music

          1 (Sports) + 4 (Pleasure) + 8 (Reading) = 13

          Manual Lookup Interface Setting up Multiple Values (Binary)

          • Label : Text that will be displayed in the item list of the checkbox.
          • Columns : Allows you to inform the amount of columns, for the list of items.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on Load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.
      • Option check all : Displays two options on the field to check and uncheck all.

        Manual Lookup Interface.

      • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

        Displaying the original lookup.

      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Ajax Processing

Ajax Processing configuration Interface. Ajax Processing configuration Interface.

Allows to define the field that will be reloaded when selecting a value that has the (onChange) trigger.

For example: a field of the type select with a list of states, and another select field with a list of cities. When selecting a state, the cities list is reloaded.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Radio

General Settings

Radio field configuration Interface. Radio field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Radio, your allowed to select one of the options listed.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Field size in database : Determines the size in bytes of the fields. It is used to determine the max amount of characters to be typed in.
  • Hidden Field : This option makes the field hidden, but still allows it’s value to be processed through Javascript or PHP. .
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • Lookup Methods

    You will have available two types of lookup methods: Manual (informing manually the conditions of the select) or Automatic (using a database query). Selecting the lookup type. Selecting the lookup type.

    • Lookup Method - Automatic

      Lookup used to list the values that will be displayed on the Checkbox field. These values will be recovered dynamically using the Select command.

      Automatic Lookup Interface. Automatic Lookup Interface.

      • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field. The command needs to have the following structure “SELECT key_field , display_field FROM table”.

      The value of the key_field will be stored in the table field.

      • Columns : Allows you to inform the amount of columns, for the list of items.

        Selecting multiple values in a radio field.

      • Use title : Allows to display a line of a title on the select object (Title Attribute) associated to a value informed manually (Title internal value).

        Selecting and using the title on the radio field.

        • Title internal value : Value Saved to the field when the line of the title is selected in the object.
        • Title : Text displayed on the title of the Select object.
      • Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.
      • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

        Displaying the original lookup.

        • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.
      • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.
    • Lookup Method - Manual

      This method is used so that the developer can create manually the list of values that will be saved to the generated application. This method is mostly used when the database does not have a table that contains this information.

      Manual Lookup Interface. Manual Lookup Interface.

      • Label : Text that will be displayed in the item list of the radio.
      • Value : Attribute that corresponds to the value that is stored in the table field. For example, the value M will be included into the table when the user will view in the list Man.
      • Default : With this option enabled, the selected item will be inserted to the table when committed.
      • Insert Button : Adds to the list the values informed on the fields Label and Value.
      • Update Button : Modifies the attributes of the selected item.
      • Remove Button : Remove the selected item from the list.
      • Clear Button : Clear the Fields.
      • Save Button : Allows the user to save all the items of the list, to use on other fields, just click on load lookup definition.
      • Load lookup definitions : Allows to refresh the list of values predefined when using the lookup. It will be listed the existing definitions in ScriptCase and the ones saved by the user.
      • Use title : Allows to display a line of a title on the select object (Title Attribute) associated to a value informed manually (Title internal value).

        Selecting and using the title on the radio field.

        • Title internal value : Value Saved to the field when the line of the title is selected in the object.
        • Title : Text displayed on the title of the Select object.
      • Reload form when value has changed : With this option selected, the form will refresh if there is a change to the selected object in the field.
      • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

        Displaying the original lookup. Displaying the original lookup.

      • Separated by : Defines which character will be used to separate the values of the field with the value returned from the lookup. It is only necessary to inform this value of the option Display original and lookup value is enabled.

Ajax Processing

Ajax Processing configuration Interface. Ajax Processing configuration Interface.

Allows to define the field that will be reloaded when selecting a value that has the (onChange) trigger.

For example: a field of the type select with a list of states, and another select field with a list of cities. When selecting a state, the cities list is reloaded.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Text Auto-Complete

General Settings

Text auto complete field configuration Interface. Text auto complete field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Text auto complete, you can inform a value based on the select statement of the lookup settings and it will manipulate an internal Text for the data.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You’ll inform the Defined Value here.
  • Use Select2: Uses the new component for data selection, allowing searches within the select.
  • Amount of characters for the Select2: Sets the number of characters to start the search in Select2.
  • Amount of lines for the Select2: Sets the maximum number of rows to list the search result in Select2.
  • Width for the Select2: Sets a width for the area for the Select2.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Complete to the Left : Allows to define the character that will be used to complete the value to the left that the user typed in to the max size of the field defined in the Field size in database option.
  • Field size in database : Determines the field size in bytes. it is used to determine the max size of characters that is allowed to type in.
  • Hidden Field : This option makes the field hidden, but still allows its value to be processed through JavaScript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Validate on submit : Validate the field only when the form is submitted.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Values Format

Format of Values Interface. Format of Values Interface

  • Case Settings : Allows to convert the letters of the field when losing the focus. The options are:
    • Upper Case : All in Upper Case.
    • Lower Case : All in Lower Case.
    • Capitalize first word : Capitalizes the first letter of the word.
    • Capitalize all words : Capitalizes the first letter of all the words.
  • Minimum Size : Allows to define the minimum amount of characters accepted for the field.
  • Maximum Size : Allows to define the maximum amount of characters accepted for the field.
  • Allowed Characters : Allows to select a set of characters that can be typed into the field. The options are:
  • All : Allows any type of character to be typed into the field Characters configuration Interface.

  • Selected : Defines a set of characters allowed. Using the configuration below, will be allowed to type letters, numbers and other characters (defined in the attribute More). The letters a, b and c (defined in the Less Attribute) are not allowed. Characters configuration Interface.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field.
  • Rows : Allows to define the amount of records displayed in the field.
  • Width : Defines the width the size of capture box (Capture Text).
  • Search options : Allows to define the search settings of the field(Start equal to, Any part and End equals to).
  • Capture Text : When not enabled, you will only view the field to inform the data. See an example below. Lookup Settings configuration Interface. lookup Settings configuration Interface.

  • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

    Lookup Settings configuration Interface. lookup Settings validation configuration Interface.

  • Show label with the description : Displays a label with the description.
  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Number Auto-Complete

General Settings

Number auto complete field configuration Interface. Number auto complete field configuration Interface.

  • Data Type : Define the type of field for the application. When set to Number auto complete, you can inform a value based on the select statement of the lookup settings and it will manipulate an internal number for the data.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Watermark : Create a placeholder for the selected field.
  • Initial Value (type) : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
    • System Date : The field will receive the current server date.

If you select the System Date, then it is not necessary to inform the Initial Value attribute.

  • Initial Value : You will inform the Defined Value here.

Initial Value Configuration Interface. Initial Value Configuration Interface.

  • Amount of characters : Define the amount of characters allowed for the field.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Complete to the Left : Allows to define the character that will be used to complete the value to the left that the user typed in to the max size of the field defined in the Field size in database option.
  • Field size in database : Determines the field size in bytes. It is used to determine the max size of characters that is allowed to type in.
  • Hidden Field : This option makes the field hidden, but still allows its value to be processed through JavaScript or PHP.
  • Label Field : This options make the field behave as a Read Only field, not allowing modifications to its value while in Insert or Update Mode.

Label Configuration Interface. Label Configuration Interface.

  • Validate on submit : Validate the field only when the form is submitted.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Database Value

Allows to define a value to be saved to the database.

Database Values configuration Interface. Database Values configuration Interface.

  • Defined Value : Allows to specify the fixed value associated to global variables.

Defined Value configuration Interface Defined Value configuration Interface.

  • Auto Increment (automatic) : Allows to use the increment generated by the database. Used only when the field of the database is the type AUTO INCREMENT or similar. For the databases that use sequence like Oracle, PostGres and Firebird, it is necessary to inform the name of the sequence.

Auto Increment configuration Interface. Auto Increment configuration Interface.

  • Auto Increment (manual) : The application generated simulates an auto increment on the field. To include a value to the field it will automatically calculate the next id.
  • Date of Insertion : When inserting a record, the field will contain the server date as a value.
  • Data of Update : When updating a record, the value of the field will be the date of the server.
  • User IP : The field will receive the IP of the machine that the application is be accessed by.
  • Calculated by the database : The value of the field will be applied by the database. The field will not be used in update processes. For example: it will be updated by a Trigger.
  • Null : The field will be informed the value null.

Lookup Settings

A method used to offer the user a list of values that can be selected in the form applications. For example, the gender field in the Database with the values M or W can be presented like Man or Women or in a dynamic way, having these values recovered from the database.

Lookup Settings Display for the field. Lookup Settings Display for the field.

  • SQL Select Statement : Define the SQL command that will recover the values that will be displayed on the form field.
  • Rows : Allows to define the amount of records displayed in the field.
  • Width : Defines the width the size of capture box (Capture Text).
  • Search options : Allows to define the search settings of the field(Start equal to, Any part and End equals to).
  • Capture Text : When not enabled, you will only view the field to inform the data. See an example below. Lookup Settings configuration Interface. lookup Settings configuration Interface.

  • Display original and lookup value : Displays the value of the field and the value returned from the lookup.

    Lookup Settings configuration Interface. lookup Settings validation configuration Interface.

  • Show label with the description : Displays a label with the description.
  • Choose connection : Allows you to select another specific connection existing in the project. The select command will be done on the second connection.

Display Settings

The Display Settings allows to deifne the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this interface.

Display Settings Interface. Display Settings Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.
  • CSS of the Field
    • Font : Allows to choose the font type, that will be applied to the application field.
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the field.
    • Horizontal Alignment : Allows to position the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the field.
    • Height : To define a height for the field.
  • CSS of the Input Object
    • Font : Allows to choose the font type, that will be applied to the Input Object. For example: Radio, Select, Text, etc
    • Font Size : Allows to choose the the font size, that will be applied to the application field.
    • Font Color :Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the Input Object, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border Size : Applies the border size to the Input Object.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the Input Object.
    • Horizontal Alignment : Allows to position the Input Object in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the Input Object in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the Input Object.
    • Height : To define a height for the Input Object.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.

Signature

General Settings

Configuration Interface of the Signature Field. Configuration Interface of the Signature Field.

  • Data Type : Define the type of field for the application. When it is defined as a text, it accepts letters, numbers and special characters.
  • Label : Defines the title of a field in the application. For example: if the field is defined in the database as cmp_name_client, it will be more clear for the comprehension of the user if the name would be “Client Name”.
  • Background color : Allows to apply a color to the field background by choosing a color from the color palette.
  • Pen color:
  • Width : Allows to define a width to the field.
  • Height : Allows to define a height to the field.
  • Subtitle : Allows to define the subtitle that will be displayed beside the field.
  • Signature line : Sets whether to display the guide line inside the canvas to assist in signing.
  • Initial Value : Allows you to define the initial value for the field when in insert mode. The options are:
    • Defined Value : The field will receive the value from the text field of the defined value option.
  • Save Variable : Allows to save a variable in the session with the value of the field, that can be used in other applications. For example, in the login form the user name can be saved in the session so that it can be displayed on the header of other applications.
  • Variable Name : Allows to define the name for the session variable that will receive the field value.
  • Disabled Field : Defines if the field will be disabled in “Insert Mode”, “Update Mode” or in “Insert and Update Mode”.
  • HTML Type : HTML Object that will be used to display the field in the form.
  • SQL Type : Informs the datatype of field in the database.

Display Settings

The Display Settings allows to define the CSS values individually for each field. For each Display schema of scriptcase, there are the same attributes available in Interface.

Display Settings configuration Interface. Display Settings configuration Interface.

  • CSS of the Title
    • Font : Allows to choose the font type, that will be applied to the application field title.
    • Font Size : Allows to choose the the font size, that will be applied to the application field title.
    • Font Color : Allows to choose a color for the font from the color pallete.
    • Background Color : Allows to define the color for the field, the color can be seleted from the color pallete.
    • Bold : Applies the bold style to the font.
    • Underline : Applies the underline style to the font.
    • Border style : Allows to choose a style for the border.
    • Collapse : Allows to define the collapse for the border.
    • Border Size : Applies the border size to the title of the field.
    • Border Color : Allows to choose a color for the border, using a color pallete to apply to the title.
    • Horizontal Alignment : Allows to position the label of the field in the desired position (left,rigth,center and justify).
    • Vertical Alignment : Allows to position the label of the field in the desired position (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Width : To define a width for the title of the field.
    • Height : To define a height for the title of the field.

Help Settings

This feature allows that the instructions are documented to be used for the generated application, this helps the end user to understand better how the system works.

Help configuration Interface Help configuration Interface.

  • Help Description : Allows to inform a text that will presente to the user when he positions the mouse over the field.
  • Help Type
    • Pop-Up : Selecting the popup type, it will display an icon beside the field that when clicked, you will view a popup with help description.

    Help type configuration Interface. Help type - Popup configuration Interface.

    • Hint : Passing the cursor over the field, you will view a hint with the help description.

    Help type configuration Interface. Help type - Hint configuration Interface.

    • Text : It will display the help description beside the field.

    Help type configuration Interface. Help type - Text configuration Interface.