All Products
Search
Document Center

Quick BI:Events

Last Updated:Jan 20, 2025

Quick BI's cross tables support interactive data entry events, allowing users to input data directly into the target database to facilitate data entry.

Prerequisites

Before adding data entry events:

  • Ensure a cross table has been created. For more information, see cross table.

  • Ensure a data entry form is created. For more information, see Create a Form.

Add Data Entry Events

Configuration Entry

  1. Refer to Create a Dashboard to access the dashboard editing page.

  2. Add a cross table as depicted below.

    image.png

  3. Configure the cross table on the dashboard editing page.

    image.png

  4. In the Parse tab > Advanced settings, select Event and customize the Event Column Name.

    image.png

  5. Click Add Event.

  6. On the Event Configuration page, set the following parameters:

    image.png

    • Event Name: Required. Customize the event name as needed.

    • Event Type: Required. Choose between data entry and DingTalk. For this example, select data entry.

    • Open Method: Optional. Choose to open in Page or Popup.

    • Style: Optional. Choose between text and icon styles and configure accordingly.

    • Associate Form: Required. Select the form created during data entry.

    • Source Table Unique Primary Key: Required. Choose a unique primary key to link with the data entry data source's unique primary key, ensuring data uniqueness.

    • Field Relationship Mapping: Optional. Sync the dataset fields of the cross table with the form. This field is not required here.

      The field relationship is only effective when clicking the entry and does not dynamically change with the cross table dataset.

      Note

      If the cross table field filter list excludes fields bound in the entry form, the entry interface cannot be accessed by clicking.

      For instance, if "Province" in the cross table is bound to "province" in the entry:

      image.png

      And the "Province" field is then deselected,

      image.png

      Clicking the entry event will result in the following prompt.

      image.png

  7. Click Confirm.

    1. PC-side Effect

      Click the Feedback column's Feedback Entry to navigate to the data entry page and add new data.

      Untitled

      Once configured, you can add or modify records in the corresponding data entry report table.

      image.png

    2. Mobile-side Effect

      Untitled