Open topic with navigation

Decimal


Figure1: General SettingsInterface

Attributes:


Decimal Format


Image: Values Format Interface.

Attributes:



Grid Lookup

Used to modify the display of a grid field. For example, a field gender in the database with values M or F is displayed as Male or Female (see lookup manual) or the display values retrieve from a database table (see lookup automatic).

 

Before Lookup
After Lookup




Grid Lookup - Automatic

Lookup used to modify a field display dynamically, retrieving the values from a database table.


Figure3: Automatic Grid Lookup Interface.

Attributes :


Grid Lookup - Manual

Lookup used to modify a field display with predefined values.


Figure1: Manual Grid LookupInterface.

Attributes :

 Single Value 

Display a single value to the field by direct substitution. The value store in the database is substituted by a label defined in a list.


Figure1.1: Single Value lookup settings.



  Multiple Values (Delimiter) 

Display more than one value for the selected field by replacing the string saved in the table by full description. The string values are separated by a defined delimiter. For example, the stored value S;M is displayed Sports(S) and Movies(M) in a list.


Figure1.2: Multiple Value lookup settings (delimiter).



 Multiple Values (Position) 

Display more than one value for the selected field by replacing the string saved in the table by full description. The values are retrieved based on the string position and size.

For example, in a string to save Gender (one byte), Marital Status (one byte) and Hobby (two bytes) the information stored includes label, start position in the string and size in bytes that each info occupies in the list:

Label Value Start Size
Male M 1 1
Female F 1 1
Married C 2 1
Single S 2 1
Sports SP 3 2
Movies MO 3 2
Books BO 3 2
Traveling TR 3 2

A string saved as MMBO is displayed: MaleMarried Books .


Figure1.3: Multiple Value lookup settings (position).

 



 Multiple Values (Binary) 

Display more than one value for the selected field by replacing the string saved in the table by full description. In this options the values are stored as decimal and retrieved by specific algorithm.

For example, the following information list has the data and the value automatically attributed relative to the position that each value occupies. (the values are displayed):

Attributed Value Lookup Description
1 Sports
2 Movies
4 Books
8 Traveling
16 Music

To display the info 11 and 12 (stored in the database), according to the list above, use the following algorithm:

11 = 1 + 2 + 8 = (Sports - Movies - Traveling)

Attributed Value Lookup Description
1 Sports
2 Movies
4 Books
8 Traveling
16 Music


12 = 4 + 8 = ( Books - Traveling)

Attributed Value Lookup Description
1 Sports
2 Movies
4 Books
8 Traveling
16 Music


Figure1.4: Multiple Value lookup settings (Binary).

Label - Text displayed in the grid.

 

 


DISPLAY SETTINGS

Scriptcase will attribute to the field the options bellow.


Figure5: Display Settings

Attributes:


Line Chart


Image: Line Chart.

Attributes:



Note: Chart width 200px.


Note: Icon Quantity is 1000, thus, the amount of stars beside, is display value divided by 1000.


Column Chart

Display an icon on the side of the Field Title to display a chart.

Column Chart Interface.



Attributes: