All Products
Search
Document Center

Quick BI:Manage data in a form

Last Updated:Jun 08, 2023

This topic describes how to add data to a form and manage the data in the form.

Prerequisites

A form is created. For more information, see Create a form.

Background information

  • The developer of a form and the administrator of the workspace in which the form is created can manage all data in the form.

  • If the form is not shared with you or you have only the public URL of the form, you cannot manage the data in the form.

Entry point

  1. On the homepage of the Quick BI console, perform the steps that are shown in the following figure to go to the Forms page.

    国中-数据填报入口
  2. On the Forms page, find the form to which you want to add data, and click the 1 icon in the Name column.

    国中-管理数据

Add data to a form

  1. In the top navigation bar, click Workbench. In the left-side navigation pane, select a group workspace from the workspace list.

  2. In the left-side navigation pane of the page that appears, choose Data Construction > Forms.1

  3. On the Forms page, find the form to which you want to add data, and click the 1 icon in the Name column.2

  4. On the All Data tab of the Data Management page, click + Add Form.

  5. In the dialog box that appears, enter the data that you want to add and click Submit.

Import multiple data records at a time

When you import multiple data records at a time, the files that you want to upload must comply with the following requirements:

  • The table header of the file that you want to upload cannot be empty. The file cannot contain merged cells.

  • You must use the Chrome browser to upload the file.

  • The file must be an XLS or XLSX file.

  • The file size cannot exceed 50 MB. In the file, the number of rows cannot exceed 500,000 and the number of columns cannot exceed 100.

  1. On the All Data tab of the Data Management page, click Batch Import.

  2. In the Batch Import Data dialog box, read File upload requirements, click the Download icon to download the Excel template, and then configure the parameters in the template based on the file upload requirements.

  3. Select or drag the file to the required position and click OK.Batch Import Data

Export multiple data records at a time

  1. On the All Data tab of the Data Management page, click Batch Export.

  2. In the Export dialog box, configure the parameters.1

    • File Name: You can specify the name of the Excel file that you want to export.

    • Data Range: You can select one of the following two options to export data:

      • All Data: specifies that all data is exported. If the number of data records exceeds 10,000, the first 10,000 data records are exported.

      • Data Obtained Based on Filter Conditions and Display Fields: specifies that only the data records that are filtered based on the specified filters and field display settings are exported.

  3. Click OK.

Query the data in a form

  1. On the All Data tab of the Data Management page, configure Submitted By, Modified By, Submitted At, and Modified At.

  2. Click Query.Query results

Reset filters

If you want to clear the configured filters at a time after you configure the filters, you can click Reset to reset the filters.

  1. On the Data Management page, click the All Data tab.

    The following figure shows that the filters are configured.12

  2. Click Reset to clear the filters.13

Edit filters

You can edit the filters to configure the fields that are displayed in the filters.

  1. On the All Data tab of the Data Management page, click the Edit Filter Conditions icon.

  2. In the Edit Filter Conditions dialog box, perform the following operations:

    • Click select all to display all filters.

    • Select the filters that you want to display. The selected filters are displayed.

      Note

      By default, Submitted By, Modified By, Submitted At, and Modified At are selected.

Configure fields that you want to display

You can configure the fields that you want to display in a form.

  1. On the All Data tab of the Data Management page, click the Configure fields that you want to display icon.

  2. In the Set Display Fields dialog box, perform the following operations:

    • Click select all to display all fields.

      Note

      By default, all fields in a form are displayed.

    • If you clear a field, the field is not displayed in the form.

Edit records in a form

  1. On the All Data tab of the Data Management page, find the record that you want to edit and click the Edit icon in the Actions column.

  2. In the dialog box that appears, edit the record and click Edit.

Delete a record from a form

  1. On the All Data tab of the Data Management page, find the record that you want to edit and click the Delete icon in the Actions column.

  2. In the message that appears, click OK.

Export records from a form

You can select the records that you want to export.

  1. On the All Data tab of the Data Management page, select the records that you want to export from the form.

  2. Click the Export icon to export the selected records.

    You can also select Select Current Page and click the Export icon to export all records.

Delete a record from a form

You can select the records that you want to delete.

  1. On the All Data tab of the Data Management page, select the records that you want to export from the form.

  2. Click the Delete icon to delete the selected records.

    You can also select Select Current Page and click the Delete icon to delete all records.

Query imported records

On the Import Records tab, you can manage Excel files that are imported at a time.

  1. On the Data Management page, click the Import Records tab.

  2. Configure the filters and click Query.15

    • File Name: the name of the uploaded Excel file.

    • Record ID: the ID of the uploaded Excel file. The system automatically generates the ID.

    • Imported By: the alias of the person who uploaded the file.

    • Imported At: the time when the Excel file was imported.

    • Import Status: the status of the imported Excel file. A record can be in the Imported or Import Failed state.

    • Actions: Click the Delete icon to delete the record.

Reset filters for querying imported records

If you want to clear the configured filters at a time after you configure the filters, you can click Reset to reset the filters.

  1. On the Data Management page, click the Import Records tab.

    The following figure shows that the filters are configured.15

  2. Click Reset to clear the filters.Reset