Feedback Print

Card

General Settings

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

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

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

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

Initial Value Configuration Interface. Initial Value Configuration Interface.

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

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

Examples of Masks

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

Label Configuration Interface. Label Configuration Interface.

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

Lookup Settings

Method used to place a description next to the field.

Lookup Settings Display for the field.

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

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

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

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

Lookup Settings validation Interface.

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

  • 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

Allow the developer to set up instructions and hints about the field’s use, allowing the developer to help the users about the system usage.

Interface de configuração da ajuda.

Description of the settings attributes.

Help Description

In this area, you can set up a text that will be shown in the application according to the type of help selected below.

Help Type


Pop-up - Display a default icon ! beside the field. To display the message just click in the icon that a Pop-up will be displayed with the help text.

Interface de configuração do tipo de exibição da ajuda.


Hint - Display a default icon ! beside the field. When the mouse is above the icon a help text will be displayed.

Interface de configuração do tipo de exibição da ajuda.

The icon displayed when selecting the types Hint or Popup vary according to the theme that is being used in the application. This icon can be modified in the CSS Buttons.


Text - Display a text inside of a <span></span> beside the field.

Interface de configuração do tipo de exibição da ajuda.

Help button position

Allow to set up where the help button will be displayed in the field, there are two options:

Beside: The help icon will be displayed beside the field.
Column: The help icon will be displayed beside the label of the field.