Successfully!

Error!

Number Widget

  • Last update:  2023-10-26
  • Overview

    Version

    Report Server Version

    App Version

    Functional Change

    11.0

    /

    /

    11.0.21

    11.0.85

    Added the Allow One-Click Clearance function on the Mobile Terminal tab page.

    Application Scenario

    Data Entry Widget

    You can enter numbers (including integers, negative numbers, and decimals) and data through the number widget in data entry reports.

     1.png

    Parameter Widget

    You can enter numbers (including integers, negative numbers, and decimals) and query parameters on the parameter panel through the number widget.

     2.png

    Adding Methods

    Data Entry Widget

    Select a cell, click Widget Setting on the right attribute panel, and choose Number Widget from the drop-down menu of Select Widget.

     3.png

    Parameter Application

    Drag the Number Widget from the widget toolbar on the parameter panel into the parameter panel.

     4.png

    Widget Introduction

    Attribute

    Data Entry Widget

    The following figure shows the Attribute tab page of the Number Widget.

     

    The following table introduces the settings of each attribute in detail.

    iconNote:
    You can set the default value by adding a value in a cell when you use the Number Widget in the data entry.

    Classification

    Settings

    Introduction

    Basic

    Widget Name

    Displays the name (empty by default) of the widget. It is manually entered and usually used in conjunction with parameters. For example, you can pass the widget value to the corresponding parameter after the widget is obtained through the widget name.

    Available

    Determines whether the widget is available.

    Checked (default setting): The widget is editable in the data entry.

    Unchecked: The widget is grayed out and not editable.

    Visible

    Determines whether the widget is visible.

    Checked (default setting): The widget is displayed on the data entry page.

    Unchecked: The widget is not displayed on the data entry page.

    Advanced

    Watermark

    Displays light gray watermark texts in the widget during the data entry. You can manually enter the needed prompt information in Watermark (empty by default). The watermark disappears after you click the widget editing area.

    Validation

    Allow Null

    Determines whether the widget can be empty.

    Checked (default setting): The widget can be empty. Unchecked: A prompt appears in the data entry validation and submission.

    Error Tip

    Appears when Allow Null is unchecked, allowing you to customize the prompt message. The default message is: "Can not be null."

    Allow Decimal

    Determines whether the entered value can be decimals.

    Checked (default setting): The entered value can be decimals.

    Unchecked: The entered value cannot be decimals.

    Decimal Place

    Appears when Allow Decimal is checked. You can customize the maximum decimal places (default value as 16).

    Allow Negative Number

    Determines whether the entered value can be negative numbers.

    Checked (default setting): The entered value can be negative numbers.

    Unchecked: The entered value cannot be negative numbers.

    Need Maximum Value

    Allows you to customize the allowed maximum value. Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value larger than specified maximum value." Unchecked (default setting): The entered value is not limited by the maximum value.

    iconNote:
    If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter 12.99999, the system defaults to carry as 13.

    Need Minimum Value

    Allows you to customize the allowed minimum value. 

    Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value smaller than specified minimum value." 

    Unchecked (default setting): The entered value is not limited by the minimum value.

    iconNote:
    If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter 12.99999, the system defaults to carry as 13.

    Error Tip

    This setting item appears after Need Maximum Value or Need Minimum Value is checked. You can customize error prompts like “Exceed the setting range.” If no error tip is set, the entered value not meeting the condition is underlined with a red wavy line.

    Parameter Widget

    The following figure shows the Attribute tab page of the Number Widget.

     

    The following table introduces the settings of each attribute in detail.

    Classification

    Settings

    Introduction

    Basic

    Widget Name

    Displays the name (default value as numberEditor#) of the widget. It is manually entered and usually used in conjunction with parameters. For example, you can pass the widget value to the corresponding parameter after the widget is obtained through the widget name.

    Available

    Determines whether the widget is available.

    Checked (default setting): The widget is editable in the data entry.

    Unchecked: The widget is grayed out and not editable.

    Visible

    Determines whether the widget is visible.

    Checked (default setting): The widget is displayed on the data entry page.

    Unchecked: The widget is not displayed on the data entry page.

    Advanced

    Label Name

    Allows you to use the label name to achieve the label function on mobile terminals, because the widget label attribute is supported and the Label Name attribute of general widgets can be recognized on mobile terminals. The Label Widget on the parameter panel is not supported on mobile terminals.

    Widget Value

    Displays the default value (empty by default) during the widget initialization. Double-Precision, Field, and Formula are supported.

    Double-Precision: includes datatype data with higher accuracy. Number with at most 15 digits (like 12.35) is supported.

     7.png

    Field: includes dataset fields, such as the Sales_Volume field of the dataset ds1. Datasets include template datasets and server datasets.

     8.png

    Formula: includes formulas supported by the designer, such as the following formula through which the value of the cell A1 can be obtained.

     9.png

    Watermark

    Displays light gray watermark texts in the widget during the data entry. You can manually enter the needed prompt information in Watermark (empty by default). The watermark disappears after you click the widget editing area.

    Font Size

    Includes the size of the font (default value as 12) entered in the text box.

    iconNote:
    This function is not supported on mobile terminals.

    Validation

    Allow Null

    Determines whether the widget can be empty.

    Checked (default setting): The widget can be empty. Unchecked: A prompt appears in the data entry validation and submission.

    Error Tip

    Appears when Allow Null is unchecked, allowing you to customize the prompt message. The default message is: "Can not be null."

    Allow Decimal

    Determines whether the entered value can be decimals.

    Checked (default setting): The entered value can be decimals.

    Unchecked: The entered value cannot be decimals.

    Decimal Place

    Appears when Allow Decimal is checked. You can customize the maximum decimal places (default value as 16).

    Allow Negative Number

    Determines whether the entered value can be negative numbers.

    Checked (default setting): The entered value can be negative numbers.

    Unchecked: The entered value cannot be negative numbers.

    Need Maximum Value

    Allows you to customize the allowed maximum value. Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value larger than specified maximum value." Unchecked (default setting): The entered value is not limited by the maximum value.

    iconNote:
    If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter 12.99999, the system defaults to carry as 13.

    Need Minimum Value

    Allows you to customize the allowed minimum value. Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value smaller than specified minimum value." Unchecked (default setting): The entered value is not limited by the minimum value.

    iconNote:
    If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter 12.99999, the system defaults to carry as 13.

    Error Tip

    Appears after Need Maximum Value or Need Minimum Value is checked. You can customize error prompts like “Exceed the setting range.” If no error tip is set, the entered value not meeting the condition is underlined with a red wavy line.

    Coords & Size

    Widget Location

    Includes the widget location (changed based on the horizontal and vertical coordinates) on the parameter panel. The coordinate is automatically displayed based on the widget location.

    Widget Size

    Includes the widget size. You can resize the widget by changing the Width and Height values. You can also hover your cursor to the widget boundary and drag the boundary until the widget reaches the desired width and height.

    Event

    You can add events for the widget on the Event tab page to achieve certain effects. The Number Widget supports four types of events — After Initialization, Before Editing, After Editing, and After Exiting Edit.

     10.png

    Select an event and add the event content. The event response methods supported by the Number Widget include JavaScript, Summit to Database, Send Email, Export Event, and Mobile Pop-up.

     11.png

    Select a corresponding event response method.

    Mobile Terminal

    The Allow One-Click Clearance function is supported on the Mobile Terminal tab page.

     12.png

    Advanced:

    • Allow One-Click Clearance: allows you to delete the entered content with one click.

    Application Example

    The following table introduces how to apply the number widget.

    Application Scenario

    Actual Effect

    Scenario:

    Set a validation code through the number widget to prevent malicious data entry and junk data. The data entry can be submitted only when the validation code is correct.

    13.png


    Attachment List


    Theme: Parameter
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback