Feedback Print

Integer

On this page, you will learn how you can configure settings related to the Number field. From the use of specific symbols display to the mode in which they are displayed. And thus, boost the application.

Number field settings interface.

Data type:

It sets the application field type. When the field is set as Number, it is permissible to define formatting rules of integers.

Label:

It sets the title that will be displayed in the field when you run the application. The terminology used in the interface is fundamental for your system has a good usability. In this case, we recommend you to use names and terms familiar to the end user of the application, instead of using terms originated in the system.

Field Mask Input:

It sets the mask input for the field. There are two types of mask as described in the table below:

Character Description
X It is overridden by any characters returned by the database. Filled is required and the value will be completed with leading zeros when there are fewer characters than the size of the mask.
Z It is overridden by any characters returned by the database. Its filling is optional and when there are fewer characters than the mask size, nothing will be done about the characters that are missing. In addition the leading zeros will be suppressed. When used in conjunction with the X necessarily the use of this character is to the left of the mask.
9 It represents any numeric character (from 0-9)
A It represents an alpha numeric character (A-Z,a-z)
* It represents any alpha-numeric character (A-Z,a-z,0-9)entered by the user.

Mask Input Examples:

Field Mask Input Typed Value Formatted Value
Phone Number +99 99 9999 - 9999 123456789012 +12 34 5678 - 9012
Phone Number (xx) xxxx - xxxx 12345678 (00) 1234 - 5678
Phone Number (xx) xxxx - xxxx 1234567890 (12) 3456 - 7890
Phone Number (zz) xxxx - xxxx 12345678 ( ) 1234 - 5678
Software Key (Letters only) AAAA-AAAA-AAAA-AAAA QWERTYUIASDFGHJK QWER-TYUI-ASDF-GHJK
Software Key (Letters and numbers) xxxx-xxxx-xxxx-xxxx Q1W2E3R4T5Y6U7I8 Q1W2-E3R4-T5Y6-U7I8
License Plate AAA - 9999 QWE1234 QWE - 1234
Scriptcase Serial Key A999A999A999-** D111H111G111DG2P D111H111G111-DG2P
Multiple masks (Phone Number) 9999-9999;(99)9999-9999; 9999 999 9999 +99 99 9999-9999

Repeat value:

This option when enabled will allows you to repeat the field value if it is equal to the value of the previous record in the database.

Example:

Display of repeating values.

Tipo SQL:

Reports the SQL type of the field as it is configured in the database.

Values Formating Interface.

Use regional settings:

It allows you to apply regional settings to the number fields formating. When this option is not selected it will be displayed the attributes group, minus sign and negative number format.

Grouping:

It allows you to define which character is used to separate thousands. This option is only available when the option to use regional settings is disabled.

Negative sign:

It allows you to define which character will be used for the display of negative numbers. This option is only available when the option to use regional settings is disabled.

Negative number format:

It allows you to define the placement of the negative sign in relation to value. This option is only available when the option to use regional settings is disabled.

Color for the negative values:

It allows you to define a color when the value is negative, improving the understanding of the end user about that kind of value.

Example:

Negative value color

c

Display the value in words:

The value of the field will be displayed in full on application. This feature can facilitate the comprehension and understanding of the user.

Example:

Display value in words

Line size:

Maximum size in characters to be displayed in the value cell, in full. When this value is exceeded the line will break within the cell.

Lookup Settings

The Lookup is a way used to provide the end user a list of values description/name where the items can be selected and used in the application. For example, for a field sex that in the database is represented with M or F values can be presented as male or female dynamically with the lookup. So you will be able to retrieve these values from a database table or manually, if the reference table does not exist.

Example:

Grid field lookup settings.

Lookup Methods

There are two lookup methods available:

Manual: To use this method it is necessary to inform the selection conditions manually to the Lookup.

Automatic: To use this method it is necessary to use a lookup query from the database to access the reference table.

Selecting the lookup method

Editing-automatic lookup:

Grid automatic lookup interface

Select Command:

It sets the SQL command that will retrieve the value to display inside the Grid field. The command must have the following format ‘SELECT field_to_be_diplayed FROM table WHERE key_field = {grid_field} ‘.

The Grid field must be always referenced between curly braces {}, So at run time, the field braces will be replaced by its value in the table.

Multiple Options:

When the Select command informed return multiple values, the option must be selected.

Delimiter:

It sets the tab of values returned by the Select command, this option should be filled when the “Yes” option is checked in the multiple attribute options.

Use the lookup in:

Grid: It applies the lookup in all Grid modules (HTML, PDF, XML, CSV, and RTF).

Summary: It applies the lookup only to the Summary (HTML and PDF).

Both This is equivalent to check Grid and Summary options.

Default Value:

Defines a default value, used in cases where the stored value does not match any value from the list.

Display original value and lookup:

When selected No, is only displayed the value returned by the Select command. Otherwise, it returns the original value of the field and the value that is returned by the Select command separated by character set in separated by.

Separated By:

Sets the character(s) that will be used to separate the original value of the field and the value that is returned by the Select command. This option should be filled when is checked Yes in the Show original value and lookup.

Use a specific connection:

This option allows you to select another existing connection in the project, other than the current connection, to select the values for the lookup.

Edit Lookup - Manual:

Lookup used to modify the display of the field with predefined values.

Grid manual lookup interface.

Lookup Types

It sets the operating mode of the lookup can be: single value, multiple values (delimiter), multiple values (position) and multiple values (binary).

Single value: it will be displayed only one value for the field. There is a direct replacement of the value stored in the Bank for a label defined in a list.

Single lookup configuration

Label: Text that will be displayed in the Grid.

Value: Attribute that matches the value stored in the table. For example, the value of “M” will be replaced by “Male”.

Multiple Values (Delimiter):

By using this option it will be displayed multiple values for the selected field. The values must be separated by a delimiter to be informed. A replacement of parts from a string stored in the field, separated by a delimiter for values contained in a list.

Multivalued lookup configuration (delimiter)

Label: Text that will be displayed in the Grid.

Value: Attribute that matches the value stored in the table. For example, the value S;M will be replaced by Sports and Movies.

Delimiter: Character used to separate the values within the same string.

Multiple Values (Position)

Allows you to recover information stored in a single string of the selected field. In order for this information to be retrieved must be informed, in addition to the label, the starting position and the number of bytes that each information occupies within the string.

As an example we will use a string to store Sex, Marital status and Hobby respectively. Sex occupies one byte, Status one byte and Hobby two bytes .

For this purpose we define the list as:

Label Value Start Size
Male M 1 1
Female F 1 1
Married M 2 1
Single S 2 1
Study ST 3 2
Sportes SP 3 2
Reading LE 3 2

Example: the string MMST would be presented in the query as: Male Married Study

Multivalued lookup configuration (position)

Label: Text that will be displayed in the Grid.
Value: Attribute that matches the value stored in the table. For example, the value M will be replaced by Male.
Start: : Starting position in the string where the information is recorded. The first position is always 1.
Size : Number of bytes that the information occupies in the string.

Multiple values (binary):

It allows you to retrieve several information stored in decimal form of the selected field.

As examples we will use the following list (although not informed in the interface of inclusion of values in the list, each item has a value assigned automatically according to the order):

Assigned value Description in Lookup
1 Sports
2 Culture
4 Leisure
8 Reading
16 Music

To display the data, a decomposition of the decimal number stored in the bank is performed. For example, numbers 11 and 12 (written in the database) would be decomposed as follows:

11 = 1 + 2 + 8 = (Sports - Culture - Reading)

Assigned value Description in Lookup
1 Sports
2 Culture
4 Leisure
8 Reading
16 Music

12 = 4 + 8 = ( Leisure - Reading)

Assigned value Description in Lookup
1 Sports
2 Culture
4 Leisure
8 Reading
16 Music

Multiple value lookup configuration (binary).

Label:

Text that will be displayed in the Grid.

Include Button:

Includes in the list the values populated in the Label and value fields.

Alter Button:

It changes the attributes of the selected item.

Delete Button:

Deletes the selected item.

Clean Button:

It cleans the fields

Save Button:

Allows the user to save the entire list, for later use using the Load Lookup definition option.

Load Lookup definition:

Allows you to load a predefined value list for use as a lookup.

Use the lookup in:

Grid: It applies the lookup in all Grid modules (HTML, PDF, XML, CSV, and RTF).

Summary: It applies the lookup only to the Summary (HTML and PDF).

Both This is equivalent to check Grid and Summary options.

Default Value:

Defines a default value, used in cases where the stored value does not match any value from the list.

Display original value and lookup:

When selected No, is only displayed the value returned by the Select command. Otherwise, it returns the original value of the field and the value that is returned by the Select command separated by character set in separated by.

Separated By:

Sets the character(s) that will be used to separate the original value of the field and the value that is returned by the Select command. This option should be filled when is checked Yes in the Show original value and lookup.

Display Settings

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

Display Settings configuration Interface. Display Settings configuration Interface.

  • Field Settings
    • Font Style : Allows to select the font family, that will be applied to the application field.
    • Font Size : Allows to choose the font size, that will be applied to the application field.
    • Italic Text : Formatting the Text to be Italic.
    • Bold Text : Formatting the Text to be Bold.
    • Don’t truncate : Do not truncate by the amount of bytes or by the Grid columns.
    • Number of characters : Amount of characters in bytes to display.
    • Horizontal Alignment : Allows to position the label of the filter in the desired location (left right, center and justify).
    • Vertical Alignment : Allows to position the label of the filter in the desired location (baseline, sub, super, top, text-top, middle, bottom, text-bottom).
    • Background Image : Background Image of the field.
    • Line Break : Allows the Line Break.
    • Font Color : Allows to apply a color to the font by choosing a color from the color palette.
    • Background Color : Allows to apply a color to the field background by choosing a color from the color palette.
    • Width : Allows to define a width to the field.
    • Height : Allows to define a height to the field.
    • Title Horizontal Alignment : Define the Title Horizontal Alignment of the field.
    • Title Vertical Alignment : Define the Title Vertical Alignment of the field.
    • Bold : Applies the bold type font to the field.

Line Chart

Using this guide, you can define ac chart for each line.

Line Chart Interface.

  • Line Chart Type : There are two types of charts that can be used. Below you can see their description:
  • Bar Chart : This option allows to display a bar chart relating to the column that you are working with. The size of the bars is done by math relating to the Grand Total of the column. The value informed in the width of the chart defines the size of the images that will be displayed.

    Bar Chart Display.

In the example shown above, the width of the Chart is 200 pixels.

  • Line Chart : This option allows to display a Line Chart relating to the column that you are working with . The amount of lines are done by dividing the value of a column by the value informed to the number of icons.

    Line Chart Display.

    In the example above, the field Number of Icons, it was informed the value 1000, so the number of stars besides, it determined by dividing the displayed value by 1000.

  • Display Value : It will display the value and the chart at the same time, the value being on the left or right side of the bar or lines.
  • Number of Icons : Determines the amount of icons (figures) that will appear for each value on this field. This value will be presented by the dividing the value of the column by the Number of Icons.
  • Chart width : Width of the chart in pixels. This field is used by the option Bar Chart. In case it is not informed, the value used is 200 pixels.
  • Chart height : Height of the chart in pixels. This field is used by the option Bar Chart.
  • Margin : Charts margin. This option is only used by the bar chart.
  • Image / Positive Color : The way that it is informed will variate depending on the options below:
    • Bar Chart : Inform a color for the field that will be used to form the chart image. Click the icon beside to choose the color.
    • Line Chart : Inform an image name for the field that will be used like an icon. Click the icon beside to choose the image “Icon”.
  • Image / Negative Color : The information passed to this field follows the same criteria as the Image / Positive Color field. This parameter will be used in the case the value is negative.

PDF Configuration

PDF Configuration

Line Break

This option allows breaking the line in the PDF file when exported.

Charts Settings

By using this option, you will see an icon on the Field Title, this icon displays a chart relating to the field.

On this type option you need to choose two columns to build the chart. The first one is the field its self that you are working with, and the second one is the you chose and is called “Column for Label”.

Bar Chart Interface. Bar Chart Interface.

  • Group by Label : Groups the values of the column by the label. Similar to the effect of the group by of the a Select.
  • Summary Function : Function that summarizes the data applied to the column. The functions that can be used on the field are the following: Count, Sum, Max, Min and Avg.
  • Configurable Chart : Allows the user to setup the parameters of the chart creation when the application is running.
  • Display Values : Displays the values of the generated chart.
  • Column for Label : Selecting the column that will be the label for the field.
  • Chart Width : Width of the chart, in pixels.
  • Chart Height : Height of the chart, in pixels.

Chart Layout

Chart layout settings interface Chart layout settings interface.