All Products
Search

This Product

    Quick BI:Overview

    Document Center

    Quick BI:Overview

    Last Updated:Nov 18, 2025

    The data entry module in Quick BI is form-based, which is efficient for scenarios such as information collection, questionnaires, and data labeling. However, industries such as water services, manufacturing, and finance often require table-based data entry. To meet this requirement, Quick BI now supports complex table data entry, allowing you to create tables and insert data into target data sources. This topic describes the complex table data entry feature, which is available only in the Professional Edition.

    Benefits

    • Flexible and efficient: You can use three data entry methods: cell entry, table entry, and dataset entry. These methods support various custom table formats and enable efficient data collection and reporting using the high information density of tables.

    • Integrated reporting and data entry: You can enter data directly into complex tables. The system combines and calculates the entered data with the data retrieved from datasets, providing a one-stop solution for data reporting and analysis.

    • Versatile applications: A variety of basic and business-specific controls meet the needs of different data entry scenarios, such as financial budgeting, manufacturing production reporting, and water utility equipment inspections.

    • Multi-user collaboration: Multiple users can collaborate on data entry, and the data is shared in real time.

    Prerequisites

    • A MySQL database is created, and the account used to connect to the data source has permission to perform operations on tables in the database.

    • A workbook is created. For more information, see Create a Workbook.

    Limits

    • If you embed the complex table data entry page in a third-party environment, data submission may fail. This failure can occur because some browsers block cross-origin iframes from writing cookies. For example, if you open an embedded page in the WeCom browser on iOS, data submission fails.

      Therefore, we recommend that you use the complex table data entry feature directly on the Quick BI platform.

    • For a list of supported data sources, see Data Source Function Item List. The account used to connect to the data source must have create, insert, update, and delete permissions for the tables in the database.

      Note

      By default, Hologres data sources do not support the delete column operation. To enable this operation, upgrade to V2.0 and change the relevant database system parameters:

      1. In the corresponding database instance, run the `alter database database_name set hg_experimental_enable_drop_column = on` command to set the database-level Global User Configuration (GUC) parameter. After you execute the command, the setting takes effect for the entire database.

      2. After configuring the setting, you must disconnect and reconnect for the change to take effect. This setting does not apply to new databases, which must be configured manually.

      For more information about these settings, see GUC Parameters.

    Access the feature

    You can use the complex table data entry feature from the Quick BI workbench.

    1. Log on to the Quick BI Workbench and go to Workbooks. On the Workbooks page, click Create Workbook (③) to configure the data entry feature in a new workbook. Alternatively, click the image icon (④) in the Actions column of an existing workbook to configure its data entry feature.image

    2. On the workbook editing page, click Data Entry (①) in the toolbar and configure the settings as needed. Before you start, you can also use the User Guide feature (②) provided by Quick BI. Follow the guide to quickly learn the configuration process.image

    Demonstration

    image

    References

    The end-to-end process for configuring complex table data entry and the related reference documents are as follows:

    No.

    Operation

    Description

    References

    1

    Apply the appropriate data entry feature

    Quick BI provides the following three data entry patterns. Choose the one that best suits your needs.

    • Dataset entry: Converts a table from a dataset into an editable workbook that you can use to add, delete, or modify data in the underlying table.

    • Cell entry: Configures data entry for a single cell. This pattern is suitable for scenarios where data is entered into individual or combined cells.

    • Table entry: Adds a data entry control to a row in a table to quickly apply the controls to all cells in the corresponding column. This pattern is suitable for scenarios that require data entry for entire rows of a table.

    2

    Set the data entry submission area

    After you configure the data entry controls for the workbook, you must define the data entry scope, write settings, and write validation.

    3

    Advanced Settings

    After you configure table data entry, you can create and assign data entry tasks to specific users for data collection. You can also set data entry permissions and enable storage approval to prevent dirty data.

    For scenarios where using a PC for data entry is inconvenient, Quick BI supports table data entry on mobile devices, which allows for flexible business data collection.