Feedback Print

Fields

Text

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows the field to use the same title defined in the Grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of a field in the database.

Field Behavior

Text Field Behavior Interface of the Search Configuration. Text Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • Amount of characters : Sets the amount of characters to start the search.
  • Amount of rows : Sets the maximum number of rows to list the search result.
  • Width : Sets the width in pixels for the result box.
  • Search options : Defines the validation that will be made to fetch the search result.
  • 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.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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.

Integer

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of field in the database.

Field Behavior

Integer Field Behavior Interface of the Search Configuration. Integer Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • Amount of characters : Sets the amount of characters to start the search.
  • Amount of rows : Sets the maximum number of rows to list the search result.
  • Width : Sets the width in pixels for the result box.
  • Search options : Defines the validation that will be made to fetch the search result.
  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • OnChange Submit : When enabled, it submits the Search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the Search in the Grid, it will only work if there is at least one option selected.

Values format

Integer Field Format of Values with Regional Settings. Integer Field Format of Values with Regional Settings.

  • Use Regional Settings : Allows to apply the Regional Settings to format the field.
  • Digit grouping : Defines if the field will display the digits separator.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.

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

Decimal field configuration Interface. Decimal field configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Decimal, it is allowed to define the format of a decimal number.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the datatype of field in the database.

Field Behavior

Decimal Field Behavior Interface of the Search Configuration. Decimal Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • Amount of characters : Sets the amount of characters to start the search.
  • Amount of rows : Sets the maximum number of rows to list the search result.
  • Width : Sets the width in pixels for the result box.
  • Search options : Defines the validation that will be made to fetch the search result.
  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

Values format

Decimal Field Format of Values with Regional Settings. Decimal Field 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.
  • Decimal Precision : Defines the amount of decimal places for the field.
  • Digit grouping : Defines if the field will display the digits separator.
  • Decimal Separator : Defines the decimal separator.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.

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.

Percent

Percentage field Configuration Interface. Percentage field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Percentage, it is allowed to define the format of a percentage.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of field in the database.

Field Behavior

Percentage Field Behavior Interface of the Search Configuration. Percentage Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

Values format

Percentage Field Format of Values with Regional Settings. Percentage Field 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.
  • Decimal Precision : Defines the amount of decimal places for the field.
  • Digit grouping : Defines if the field will display the digits separator.
  • Decimal Separator : Defines the decimal separator.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.

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

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of field in the database.

Field Behavior

Currency Field Behavior Interface of the Search Configuration. Currency Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • Amount of characters : Sets the amount of characters to start the search.
  • Amount of rows : Sets the maximum number of rows to list the search result.
  • Width : Sets the width in pixels for the result box.
  • Search options : Defines the validation that will be made to fetch the search result.
  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

Values format

Currency Field Format of Values with Regional Settings. Currency Field 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.
  • Decimal Precision : Defines the amount of decimal places for the field.
  • Digit grouping : Defines if the field will display the digits separator.
  • Decimal Separator : Defines the decimal separator.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.

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.

Percent ( Calculated )

Percentage field Configuration Interface. Percentage field Configuration Interface.

  • Data Type : Define the type of field for the application. When it is defined as a Percentage, it is allowed to define the format of a percentage.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of field in the database.

Field Behavior

Percentage Field Behavior Interface of the Search Configuration. Percentage Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the datatype of field in the database.

Values format

Date Field Format of Values with Regional Settings. Date Field 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.
  • 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 A, M and D that correspond to Year, Month and Day.
  • Use Combo-box : Allows you to select the date using a combo-box.
    • Year as Combo : Allows to use the year combo to select the date.
      • Initial Year : First year displayed in the combo.
      • Actual Year + : Display the current plus the amount of years informed.
  • Month in full textual : Displays the Month format in Full.
  • 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 : Defines if the JQuery calendar (New Calendar) is going to be displayed or the old format.
    • Years Limit : Amount of years displayed in the calendar.
    • View week number : Displays the number of the week in the application.
    • Additional months : Displays the additional months of the calendar.
    • Show Combo year and month : Displays the year and month of the calendar in the combo box.

Field Behavior

Date Field Behavior Interface of the Search Configuration. Date Field Behavior Interface of the Search Configuration.

  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

Special Conditions

Date Field Special Conditions. Date Field Special Conditions.

  • All Period : Searches for all periods of dates.
  • Today : Searches in today’s date.
  • Yesterday : Searches in yesterday’s date.
  • Last 7 days : Searches the last 7 days. Ex: ((01/01/2017 01/07/2017).
  • This month : Searches the dates from the first day of the current month.
  • Last month : Searches the dates from the first day of lasts month.

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.

Time

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the datatype of field in the database.

Values format

Time Field Format of Values with Regional Settings. Time Field 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.

Field Behavior

Time Field Behavior Interface of the Search Configuration. Time Field Behavior Interface of the Search Configuration.

  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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.

Datetime

Datetime field Configuration Interface. Datetime 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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the datatype of field in the database.

Values format

Datetime Field Format of Values with Regional Settings. Datetime Field 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 A, M, D , HH, II, and SS that correspond to Year, Month, Day, Hour, Minutes and Seconds.
  • Use Combo-box : Allows you to select the date using a combo-box.
    • Year as Combo : Allows to use the year combo to select the date.
      • Initial Year : First year displayed in the combo.
      • Actual Year + : Display the current plus the amount of years informed.
  • Month in full textual : Displays the Month format in Full.
  • 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 : Defines if the JQuery calendar (New Calendar) is going to be displayed or the old format.
    • Years Limit : Amount of years displayed in the calendar.
    • View week number : Displays the number of the week in the application.
    • Additional months : Displays the additional months of the calendar.
    • Show Combo year and month : Displays the year and month of the calendar in the combo box.

Field Behavior

Date Field Behavior Interface of the Search Configuration. Date Field Behavior Interface of the Search Configuration.

  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

Special Conditions

Datetime Field Special Conditions. Datetime Field Special Conditions.

  • All Period : Searches for all periods of dates.
  • Today : Searches in todays date.
  • Yesterday : Searches in yesterdays date.
  • Last 7 days : Searches the last 7 days. Ex: ((01/01/2017 01/07/2017).
  • This month : Searches the dates from the first day of the current month.
  • Last month : Searches the dates from the first day of lasts month.

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

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 combo box (Select Field).
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the datatype of field in the database.

Field Behavior

Select Field Behavior Interface of the Search Configuration. Select Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the datatype of field in the database.

Field Behavior

Double Select Field Behavior Interface of the Search Configuration. Double Select Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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.

Check box

Check box field Configuration Interface. Check box field Configuration Interface.

  • Data Type : Define the type of field for the application. When set to Check box, your allowed to have multiple options selected.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of field in the database.

Field Behavior

Check box Field Behavior Interface of the Search Configuration. Check box Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the datatype of field in the database.

Field Behavior

Radio Field Behavior Interface of the Search Configuration. Radio Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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

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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of field in the database.

Field Behavior

Text Auto-Complete Field Behavior Interface of the Search Configuration. Text Auto-Complete Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • 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.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

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

! ![Number Auto-Complete Field Behavior Interface of the Search Configuration.][filtro_cons_número_auto] Number Auto-Complete Field Behavior Interface of the Search Configuration.

  • 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.
  • Search 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”.
  • Use same label used on the Grid : When this option is enabled, it allows to field to use the same title defined in the grid, in this case the Search Label is not used.
  • Amount of characters : Define the amount of characters allowed for the field.
  • Maximum Size : Defines the size of the field.
  • SQL Type : Informs the data type of field in the database.

Field Behavior

Number Auto-Complete Field Behavior Interface of the Search Configuration. Number Auto-Complete Field Behavior Interface of the Search Configuration.

  • Use autocomplete : The field behaves as an autocomplete according to the values existing in the database.
  • Position between values : This option sets the position that objects will be displayed.
  • Text between values : Text that will appear between values.
  • OnChange Submit : When enabled, it submits the search when there is modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it will only work if there is at least one option selected.

Values format

Number Auto-Complete Field Format of Values with Regional Settings. Number Auto-Complete Field 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.
  • Decimal Precision : Defines the amount of decimal places for the field.
  • Digit grouping : Defines if the field will display the digits separator.
  • Decimal Separator : Defines the decimal separator.
  • Accept : Determines if the field, will accept only negative, positive or both numbers.

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.