All Products
Search
Document Center

Quick BI:Controls

Last Updated:Jun 08, 2023

The forms feature supports eight types of controls. This topic describes the controls and their use scenarios.

Configure controls

  • Normal Config

    • Title: the display name of the control and is used as the column name of the form.

    • Field Name: the dimension or measure name of the dataset that is created based on a form.

    • Tips

    • Description

    • Default Status

    • Default Value

      You can select Use Logon Username to use your logon username as the default value.

  • Style

    Configure the style of the control.

  • Validation

    Specify the source, type, length, and values of data in the control.

Text

You can use the Text control to add a single row of text data, such as names or job titles.Text-3.11

Textarea

You can use the Textarea control to add multiple rows of text data, such as a job introduction or self-introduction.Textarea-3.11

Dropdown

You can use the Dropdown control to select an option from limited options, such as departments and ranks.Dropdown-3.11

When you use the Dropdown control, you must configure the parameters in the Options section. The option values in the drop-down list include custom data and data from a specified connected data source.

  • Custom Data

    You can customize the data in the control based on your business requirements.Custom Data-3.11

    Note

    For more information about the configuration of Set Linked Fields, see Set Linked Fields.

  • Based on the connected data source

    You can use data from a connected data source as data in the Dropdown control.Options-3.11

    In the preceding figure, when you add a form, the value of the debit card field can be used as the value in the Dropdown control.

Number

You can use the Number control to add numeric data, such as the length of employment.Number-3.11

Date

You can use the Date control to add date data. Date-3.11You can select the date format from the Format drop-down list.

Radio

You can use the Radio control to add limited option data. This control is used when a small number of options exist.Radio-3.11

Note

For more information about the configuration of Set Linked Fields, see Set Linked Fields.

Tree drop

You can use the Tree drop control to specify the data in the data source as input data of the form. The data source must be associated with Quick BI.

Note

If you use the Tree drop control, only the MySQL data source can be used as the data source of the form.

In this example, the area field in the company_sales_record table of the MySQL data source is used as company_sales_record areathe data source of the form that you create. Tree drop-3.11When you add a form, you can use the value of the area field as the input data.area

Page Breaks

You can drag existing controls to the Page Breaks control.Page Breaks-3.11

Set Linked Fields

You must configure Set Linked Fields only when you use the Dropdown or Radio control and the data source is Custom Data. In the following example, a Date control and a Number control are associated with a Dropdown control.

  1. On the form edit page, add the Dropdown, Date, and Number controls.2

  2. Select the Dropdown control. In the Options section, select Custom Data for Source and edit the options.

    In this example, the options contain Number and Date.3

  3. Click Set Linked Fields.

  4. In the Set Linked Fields dialog box, perform the steps in the following figure to associate the values of Options with the values of Linked Fields.Linked Fields

    When you add a form, only the controls that are associated with the Dropdown control are displayed as the values of the Dropdown control. For example, if you select Date for the Dropdown control, only the Date control is displayed as the value of the Dropdown control.

Image

You can use this control to upload images, such as product logos.Image_4.3.2

The following figure shows the preview effect of an image.Image preview_4.3.2

Note
  • You can upload an image only by using the URL of the image.

  • You can upload only images in the JPEG, PNG, or GIF formats.