Add a Number Field

Overview

A Number is a column input type that allows users to display and edit numeric data. You can use an existing numeric column in a view (dataset) to add a Number field to a container.

Number fields support various formatting options, including decimal precision, negative number handling, thousands separators, and percentage or grand total displays. Number fields can be linked to other pages through page bindings and support conditional visibility and display modes.

Create a Number

1. On the Cloud Construct’s home page, edit the required WebApp. The WebApp configuration page is displayed.

2. Access the Grid or Form node of your required construct page.

3. Select the Fields node and click Add Fields. The Add or Remove Fields dialog box is displayed.

4. Select the required field from the Dataset and set the column’s input type to Number.

5. Click Save.

6. In the Fields node, select the Number column input type. The Details Pane is updated with the number fields.

7. Enter the number column properties as required using the following table:

   Field Name	Description	Supported Values/Notes
   Name	The field or property name	Select the name of the column from your dataset to display in grid/form
   Ordinal	Specifies order of fields within a container	Any integer. default: 0
   Control Status	Controls the availability of the field when switching between edit/insert mode.	* Disabled: The field won’t be available for updates, but display-only * Enabled: The field will be available and displayed for updates * Hide: The field won’t be displayed and not available for updates. default: Enabled
   Control Status Field	Select the column from the same grid or form container dataset whose per-row value controls whether this field is disabled (0), enabled (1), or hidden (2).	This property offers an alternative to using a separate dataset (for example, CCD) to control the state of a field.
   Is Key	Specifies if field is a key field	default: false
   Required	Is the field required for add/update	default: false
   Required Type	* Hard: When set to hard required, the user must populate the field before saving the record. * Soft: When set to soft required, the user can save the record with an empty field, but a validation error appears after saving, indicating that the field should be populated.	default: Hard
   Default Value	Default value when adding records	A value as per the field data type to be used as a default value when adding records. maxLength: 50
   Placeholder Text	Text displayed when field is empty	Any string within length constraints. maxLength: 255

Number Display Properties

8. Configure the following properties to format how numeric fields are displayed to users:

   Field Name	Description	Supported Values/Notes
   Decimal Places	Number of decimal places to display.	Minimum: 0 and Maximum: 15
   Allow Negative	Allows negative numbers to be displayed for this number field.	default: false
   Display Thousands Separator	When enabled, a thousands separator is displayed in the numeric field, making numbers easier to read by visually grouping them into thousands, millions, billions, and so on.	default: false
   Show Percent	When enabled, the numeric field displays in percent format, multiplying the underlying value by 100 and adding the '%' sign. For example, a stored value of 0.25 displays as 25%.	default: false
   Show Totals	When enabled, the Grid container displays a pinned row at the bottom showing the sum of this field for all records matching the filtering condition and binding criteria.	Applicable only to the Number column type in a Grid container. default: false

Add Page Bindings

9. If required, add the required page bindings to define how data is passed between pages when navigating through links. Refer to Link to a Page and Add Page Bindings for more information.

Additional Configurations

10. If required, complete the following additional configuration as needed:

    Note

    These fields are applicable only to columns added to a grid container.

    Field Name	Description	Supported Values/Notes
    Is Hidden on Grid By Default	Controls column visibility by default	default: false
    Width Flex Grow	Controls if field grows based on content	default: false
    Sortable	Specifies if field is sortable	default: true
    Filterable	Specifies if field is filterable	default: true
    Resizable	Specifies if field is resizable	default: true
    Sort Mode	Configures default column sort order	* Ascending * Descending * None default: None
    Sort Priority	Priority for sort operation. Used with Sort Mode to configure the default column sort order	Any integer. default: 0
    Tooltip	Displays the tooltip that will be shown when hovering over cells and the header icon.	Enter a tooltip string within length constraints. maxLength: 128
    Header Icon	The icon that will be displayed in the column header replacing the number’s column name.	Use the Preview and Select Icon button to open the Select Icon dialog box and add an icon to the number. You can either search for an icon or scroll through the list to find the one you want to preview, and then click Save to apply your selection. To reset the Icon value, click Clear in the Select Icon dialog box. maxLength: 100

11. Click Save.

Related Articles

• Build Assist

• Configure Column Properties

• Configure Form Display

• Configure Grid Display

• Construct Events