Feedback Print

Search

Settings

In the area below you can define all the options that’ll be part of the of the Search Form.

Search configuration Interface. Search configuration Interface.

  • Attributes

  • Search Criteria : Allows to select the SQL command AND or OR to define the criteria of the search used;
  • Display Condition : Displays the condition of the search for the user to choose. In this case “AND” or “OR” will display in the search form, so that the user can choose the desired option.
  • Use auto-complete in the fields : The field turns into an autocomplete automatically according to the existing values in the database, If the user chooses Yes, the autocomplete will enable automatically in all the fields that contain a relationship. If the user chooses No no autocompletes will be displayed. In the case the option selected is Defined in the field it’ll respect the configuration individually for each field.

Search Criteria

Search configuration Interface. Search configuration Interface.

In this interface, you can configure the conditions for each field of the Search form when filtering the SQL, on the left combo is displayed the field. The combo on the right are listed the options for filtering the selected field, to select the options just click on them (Equal to, Beginning with, Contains and etc.) and the button On/Off. The arrows on the right allows to alter the order of the fields.

For the Date type fields, you can define special conditions for the search, accessing the field configurations and editing the Special Conditions Settings.

Below the list are the buttons to enable the selected options:

  • On/Off : Enables or disables the field or the selected option.
  • All : Marks all fields or options.
  • None : Un marks all the fields or options.

Settings

Through the table below we set all the options that will be part of the application Grid Search.

  • Margins : Allows to position the margins of the Search Form.
  • Keep Values : When enabled, the values from the search is maintained when the user returns to the search form.
  • Keep Columns and Order Selection : allows you to determine whether, at each filter, the values selected for the query and sort fields must be preserved, that is, at each filter, these values return to the original condition.
  • Use Enter to : Allows you to define the action that the Enter Key will have on the Search screen. Tabulate allows you to navigate between fields and Submit performs the search(activates the Search button).
  • Display Tags : Allows to display the Searches used for the Grid in the form of tags.
  • Display after filtering: When enabling, tags will be displayed after performing an advanced search, if disabled, tags will always be displayed regardless of performing an advanced search.
  • Unify results : Sets the number of characters to group the result of the tags. This option should be used when the field type is multiple-select.
  • Treeview in the Tags : Sets the use of Treeview for tags.
  • Initial status of the Treeview : This option works only if the Treeview is being used and it sets the initial state of the Treeview.
    • Start open : Displaying the tags Etiquetas com treeview aberto
    • Start close : Showing full description as text Etiquetas com treeview fechado.

Select fields

Interface for filter fields selection. *Interface for filter fields selection.

Required

Defines which fields of application will be required for the search.

Required fields interface. Required fields interface.

The application generated will be displayed a bullet (*) next to the field and an error message is generated if not assigned no value.

Configuration interface of the marker placement. Configuration interface of the marker placement.

  • Marker position : Marker’s position relative to the field.
  • Display message : Displays whether or not the validation error message.

Toobar

Desktop

The Search toolbar is divided in two parts: Top and Bottom, in a way that is possible to define the buttons that will be displayed in both bars. The selection of buttons in the top and bottom toolbar works independently, allowing the buttons to be displayed in both bars at the same time.

Toolbar Interface. Toolbar Interface.

  • Search: Execute the search.
  • Clean: Clean the all the search fields.
  • Edit: Enable the Save Tag option.
  • Exit: Exit the application.

Others: Groups a diversity of options relative to the application.

  • Languages: Displays a combobox with the names available, defined in the project properties.
  • Themes: Displays a combobox with the themes available, defined in the project properties.
  • HelpCase: Displays a button to redirect to the help page.

Separator

  • —————–: Dispays a line separating the buttons, when used the Group Buttons.

Use in-line buttons: Allows the alignment of the filter buttons next to the fields.

  • __ Inline buttons__: Allows you to select which buttons will be displayed next to the field, and you can sort them according to your wishes. This option is available by enabling Use Online Buttons in the button settings.

Button Settings

Button Settings Interface. Button Settings Interface.

  • Hotkey: Allows you to set keyboard hotkeys to a button.
  • Use Inline Buttons: Allows alignment of the filter buttons next to the fields.
  • Position of the in-line buttons: Sets the positioning of the buttons to the right or left of the fields.
  • Column Quantity: Sets the number of display columns of the buttons, allowing you to configure whether they will be displayed side-by-side or distributed in columns.

Options

Options Interface. Options Interface.

  • Button Position(Top/Bottom) Positioning the buttons of the toolbar Top/Bottom.

This feature allows to organize search profiles, it creates an option Save Filter in a Search application, this way it is possible to save the search done previously. You can add some rules. With these details you can save a search done by the user login.

Save Filter Interface. Save Filter Interface.

Save Filter Interface. Save Filter Interface.

Events

In event blocks can be used global variables, local, JavaScript code, CSS codes and Scriptcase macros.

onScriptInit

This event occurs when the application scripts are started. It runs before the OnLoad events(when present), however, it will always be executed when running, reloading or navigating the application.

onRefresh

This event runs when the refresh option of the application is enabled.

onSave

This event runs when the application saves the record.

onValidate

This event runs when validating the information of the fields, when submitting the form.

Layout

On this module are available the features of editing, attributes and display of the application, in a way that you can apply display themes, organize blocks, define values and the format of the Header/Footer and etc.

Blocks

Conceptually a block is a “container” where you can position the fields of the Applications: Form, Control or Grid with Slide orientation.

By default, the applications created in ScriptCase are built with a only one block, with the same name as the application. You can add the amount of blocks that you want to organize in a more convenient way. The page below, observe that theirs a column Organization, and that is where you’ll define if the next block will be set beside or below the current one.

Application Block configuration Application Block configuration

On the left side of each block there are two icons, first Application Block configuration has the function to edit all the information relative to the block and the second Application Block configuration is to delete the block.

  • Organizing the position of the Blocks
    • See below how to modify the display order of the Blocks in one Page.

    Click and drag the block that you desire to modify to its new position.

    Application Block Display configuration Application Block Display configuration

    • See how to remove a block from display

    Click on the block desired and drag it to the item “Blocks not Shown”. This way, you can also drag the block to another page if desired. See the images below.

    Application Block Display configuration Application Block Display configuration

    Application Block Display configuration Application Block Display configuration

    • Attributes
      • Block
        • Name : Name of the Block.
        • Label : Title of the block that’ll be displayed in the application.
      • Title
        • Display : Flag that controls the title display of the block.
      • Label
        • Display : Flag that controls id the label of the fields will be displayed in the block.
        • Position : Options to display label :
          • Above : The label will be displayed above the field.
          • Beside : The label will be displayed beside the field.
          • Below : The label will be displayed below the field.
      • Fields
        • Columns : Amount of columns that are displayed side by side in the block.
        • Position : The way that the fields are displayed in the block :
          • Below : The fields are displayed one below the other respecting the amount of columns.
          • Beside : The fields are displayed one beside the other respecting the amount of columns.
          • Line : The fields are displayed one beside the other without the tabulation.
      • Organization
        • Next : The way that the blocks are displayed in the page:
          • Below : Indicates that the next block will be placed below the current one.
          • Beside : Indicates that the next block will be placed beside the current one.
          • Tabs : Indicates that the next block will be placed in a different tab then the current one.
        • Width : Specifies the width that block will occupy in pixels or percentage, in case the value is in percentage, inform the (%).
        • Collapse : Enables the option to close the block.
  • Create New Block

    To include new blocks in an Application, click on the button Creating application blocks configuration. Next, you’ll see the following interface to define the name and label of the block. At the end click on Create.

    Creating application blocks configuration Creating application blocks configuration

    • Attributes
      • Name : Name of the Block.
      • Label : Title of the block that’ll be displayed in the application.
  • Edit Blocks

    To edit a block just click on the icon Creating application blocks configuration, that is on the left side of the block. Next, you’ll see the following interface to define the parameters of the blocks. At the end click on save.

    Application Block editing interface Application Block editing interface

    • Attributes
      • Name : Name of the block.
      • Title : Block title for display.
      • Display Title : This option, when active, allows to display the block title.
      • Title Font : Font applied to the block title.
      • Font Size : Size of the font applied to the block title.
      • Font Color : Font color for the block title.
      • Background Color : Background Color of the block title.
      • Background image : Background image for the block title.
      • Title Height : Height in pixels of the block title line.
      • Horizontal Alignment : Horizontal Alignment of the block title (Left, Center and Right).
      • Vertical Alignment : Vertical Alignment the block title (Top, Middle and Bottom).
      • Display Label : Display the labels of the fields in the block.
      • Columns : Amount of field columns in a block.
      • Columns Width : How the width of the block is defined.
      • Label Color : Color of the field labels.
      • Fields Organization : How the fields are organized in the block.
      • Label Position : Position of the field labels relating to the data.
      • Next Block : Position of the next block relating to the current block.
      • Border Color : Border color for the block.
      • Border Width : Border Width for the block.
      • Block Width : Width for the block.
      • Block Height : Height for the block.
      • Cell Spacing : Cell Spacing in the block.
      • Collapse : Enables the option to close the block.

Layout Settings

On this interface, you can define the theme for display of a specific application, this being because ScriptCase uses a Standard Definition of Values per project, that besides the Display Theme, allows to define values for other attributes on a Project level.

Application Display Theme Configuration Application Display Theme Configuration

  • Display Configuration
    • Header Template : Allows to choose the template that’s going to be used as the Header of the application.
    • Footer Template : Allows to choose the template that’s going to be used as the Footer of the application.
    • Button : Allows to choose the button theme for the application.
    • Themes : Choose one of the existing themes, it’ll load the display mode (colors ,fonts, etc.) that’ll be part of the application.

In this block, it’s the definition of the variables content that’ll be part of the header.

Application Header Configuration Application Header Configuration

This page may change depending on the header format chosen in the Layout Settings.

  • Display Header : This option determines if the header will display.
  • Title : Allows to inform the title displayed in the application.
  • Header Variables : The field variables can be informed with anyone of displayed in the Combo box. Depending on the type, it’ll be necessary to associate the content with the field. Below there are the types of content:
    • Field : When you choose the option “Field”, it’ll open a Combo box beside to choose the field you want. Selecting the desired field, it’ll associate the value of the field with the header.
    • Title : This option when selected it’ll display in the header the value informed in the “Application Title”.
    • Date : When selected the “Date” type, it’ll display the system’s date in the header. There are a diversity of formats using the date and time of the server. The format can be informed in the text field that appears beside the field. To access the existing formats, click on the icon and you’ll view a page display the formats.
    • Image : When selecting the image type, it displays a field to inform the name of the existing image in the server. To locate the images existing and selecting one, click the icon “Choose Image” and to upload new images click on the button “UploadApplication Footer configuration.
    • Value : When selecting the type “Value”, the content informed in the text field that appears beside, it’ll be displayed in the header, you can inform texts and “Global Variables”. e.g. “Employee Name: [v_name]”.

Depending on the Application, you may have more than one title option.

Application Footer Configuration Application Footer Configuration

This page may change depending on the footer format chosen in the Layout Settings.

  • Display Footer : This option determines if the footer will display.
  • Footer Variables : The field variables can be informed with anyone of displayed in the Combo box. Depending on the type, it’ll be necessary to associate the content with the field. Below there are the types of content:
    • Field : When you choose the option “Field”, it’ll open a Combo box beside to choose the field you want. Selecting the desired field, it’ll associate the value of the field with the footer.
    • Date : When selected the “Date” type, it’ll display the system’s date in the footer. There are a diversity of formats using the date and time of the server. The format can be informed in the text field that appears beside the field. To access the existing formats, click on the icon and you’ll view a page display the formats.
    • Image : When selecting the image type, it displays a field to inform the name of the existing image in the server. To locate the images existing and selecting one, click the icon “Choose Image” and to upload new images click on the button “Upload” .
    • Value : When selecting the type “Value”, the content informed in the text field that appears beside, it’ll be displayed in the footer, you can inform texts and “Global Variables”. e.g. “Employee Name: [v_name]”.

This feature allows the user to search records the application without leaving the current screen, the developer needs to indicate which fields will be available.

Settings

Dynamic Search configuration Interface. Dynamic Search configuration Interface

  • Use the ENTER key to : Use the Enter key to tabulate from one field to the other, or to submit the search.

Select Fields

Dynamic Search Field Selection. Dynamic Search Field Selection.

QuickSearch

Quick Search is an option that allows to search data in various fields of the application, by using the text box in the toolbar.

Application running QuickSearch. Application running QuickSearch.

QuickSearch Settings

In the quicksearch settings are the following options:

QuickSearch Configuration Interface. QuickSearch Configuration Interface.

Button within the search - An option to inform if the search button will be in the text area of the box. Quicksearch show combo box - Displays a combo box if there is only one option in the quicksearch. Quicksearch Watermark - Displays a Placeholder in the quicksearch. Quicksearch width - Defines the width of the Quicksearch field. Display the Quick search old format - Displays in the old format with the selection of the fields in the Quick search. Search anywhere - If enabled, QuickSearch will search each part of the String for the data informed in the field.

Select Fields

You need to define the fields that are part of the search in the Quicksearch Settings .

QuickSearch selecting fields Interface. QuickSearch selecting fields Interface.

And you can select various criteria of the search.

QuickSearch search criteria configuration Interface. QuickSearch search criteria configuration Interface.

You need to add the QuickSearch button in the toolbar in order to use it.

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’ll 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 isn’t 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

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.
  • 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’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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 isn’t 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

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.
  • OnChange Submit : When enabled, it submits the search when there’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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
  • 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’s defined as a Decimal, it’s 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’ll 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 isn’t 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.
  • OnChange Submit : When enabled, it submits the search when there’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’s defined as a Percentage, it’s 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’ll 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 isn’t 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

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.
  • OnChange Submit : When enabled, it submits the search when there’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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 isn’t 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

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.
  • OnChange Submit : When enabled, it submits the search when there’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’s defined as a Percentage, it’s 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’ll 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 isn’t 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

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.
  • OnChange Submit : When enabled, it submits the search when there’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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 isn’t 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’ll 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.

  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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 isn’t 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’ll 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’ll only work if there’s 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’ll 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 isn’t 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’ll 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.

  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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 isn’t 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’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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 isn’t 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’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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.

Checkbox

Checkbox field Configuration Interface. Checkbox field Configuration Interface.

  • Data Type : Define the type of field for the application. When set to Checkbox, your allowed to have multiple options selected.
  • 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’ll 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 isn’t 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

Checkbox Field Behavior Interface of the Search Configuration. Checkbox 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’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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 isn’t 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’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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.

Grid Fields

Grid fields Configuration Interface. Grid fields Configuration Interface.

  • Data Type : Define the type of field for the application. When set to “Grid Fields”, you can set the fields that’ll be part of the Grid table.
  • 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’ll 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 isn’t 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.

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.

Sorting

Sorting field Configuration Interface. Sorting field Configuration Interface.

  • Data Type : Define the type of field for the application. When set to “Sorting”, you can set the sorting of the fields that’ll be part of the Grid table.
  • 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’ll 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 isn’t 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.

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’ll 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’ll 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 isn’t 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

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 seach when there’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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’ll 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’ll 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 isn’t 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’s modifications to the field.
  • Show Condition : When enabled, it displays the condition of the search in the Grid, it’ll only work if there’s 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.