Decimal

View video

General Settings

Decimal field Configuration Interface.

Data Type

Define the field type to Decimal. It allows defining the Decimal number format.

Label

The Label option lets you define the title of a field. Example: If the database field name is “cmp_name_client”, You can display a different name for the user, like “Client Name”.

Accumulated

It defines the field to accumulate values of another field. This option is only available for virtual fields.

Accumulator field

It is available when the option “Accumulated” is enabled. This configuration defines which field will accumulate the values. The field should be Integer, Currency, or Decimal.

Grid Mask

It defines a mask for the field value. There is two types of masks:

Mask Examples

Do Not Repeat Value

Do not repeat the value of the field if it is the same as the previous record.

SQL Type

It informs the data type of field in the database.

Field Behavior

Use autocomplete:

Field automatically turns into autocomplete according to existing values in the database.

Use Select2

Uses the new component for data selection, allowing searches within the select comboBox.

Width for the Select2

Sets a width for the area in the Select2.

Amount of characters

Sets the amount of characters to start the search.

Amount of rows

Sets the maximum number of rows to list the search result.

Width:

Defines a width in pixels for a result box.

Search options:

Defines the validation that will be made to fetch the search result.

Start equals to: Will return the records with the same start value as in the database.
Any part: Will return the records when exist the character in any part of the record.
End equals to: Will return the records with the same final value as in the database.

Position between values:

Defines the position that objects will be displayed.

Text Between Values

Text that will appear when using a filter condition between two values.

OnChange Submit:

Submit search on this field changing.

Show Condition:

To show or not the search condition. It only works if the search has at least one condition.

Values format

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 define the CSS for the fields individually. For each Display Settings of Scriptcase, exists the same attributes available for this 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 pallet.
  • Background Color : Allows to define the color for the field, the color can be selected from the color pallet.
  • 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 pallet to apply to the title.
  • Horizontal Alignment : Allows to position the label of the field in the desired position (left,right,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 pallet.
  • Background Color : Allows to define the color for the field, the color can be selected from the color pallet.
  • 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 pallet to apply to the field.
  • Horizontal Alignment : Allows to position the field in the desired position (left,right,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 pallet.
  • Background Color : Allows to define the color for the Input Object, the color can be selected from the color pallet.
  • 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 pallet to apply to the Input Object.
  • Horizontal Alignment : Allows to position the Input Object in the desired position (left,right,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 Description : Allows to inform a text that will present to the user when he positions the mouse over the field.
• Help Type
  • Pop-Up : Selecting the pop-up type, it will display an icon beside the field that when clicked, you will view a pop-up with help description.

  Help type - Pop-up configuration Interface.

  • Hint : Passing the cursor over the field, you will view a hint with the help description.

  Help type - Hint configuration Interface.

  • Text : It will display the help description beside the field.

  Help type - Text configuration Interface.