What is data reporting, and what are its features and limitations? - Quick BI

The forms feature is used to import business data fields. You can store the data that is imported by business personnel to the business system and perform secondary data analysis. Only group spaces of the Professional and Advanced editions support data filling.

Benefits

The forms feature can be used as an online data collection tool without the need to use code. This allows you to configure a custom form, perform intelligent data reporting, collect data statistics, and analyze data.

End-to-end operations: You can collect data, create data models, analyze data, and view analysis results.
Easy to use: 0 code to build forms, provide rich controls, lower the threshold, and break the boundary between data developers and data analysts.
Multi-person collaboration: Multi-person collaboration to maintain a data, data sharing in real time.
Dual-end adaptation: one-time build, dual-end adaptation, low-cost change, and fast data reporting.

Limits

Only MySQL, SQL Server, AnalyticDB for MySQL 3.0, PolarDB for MySQL, Oracle, PostgreSQL, Dameng, and Hologres databases are supported. The account that is used to connect to the data source has the permissions to manage tables in the databases.
The accounts must have the CREATE, INSERT, UPDATE, and DELETE permissions on the databases.
Note
Hologres data sources do not support the Delete Column operation by default. Upgrade to the V2.0 version and change the related database system parameters:
1. Run the alter database database database name set hg_experimental_enable_drop_column=on command on the corresponding database instance to set the GUC parameters at the database level. After the execution is complete, the GUC parameters take effect at the database level.
2. After the configuration is complete, the current connection must be disconnected again for the configuration to take effect. The modification does not automatically apply to a new database. You must manually configure the GUC parameter for the new database.
For more information, see GUC parameters.

UI

Form Theme

Questionnaire Topic

Control description

Data form supports the following controls:

Control Type	Control Name
Basic Controls	Single-line text
	Multiple lines of text
	Value
	Date and Time
	Single Choice
	Single Select Drop-down
	Drop-down Multiple Selection
Advanced Controls	Tree Drop
	Text Area
	Upload Images
	Score
	Email
	Filling Time
	Progress
	Submitted
	User Radio
	Multiple User Selection
Layout Control	Column Layout

Procedure

Design a form based on your business requirements and write the form to the destination database. For more information, see Create a Form.
Add or modify data in forms. For more information, see Manage data.
For more information about how to manage forms, see Manage forms and Manage forms.