Drop-down Tree Default Value Setting

1. Expected effect

The drop-down tree widget is usually used in parameter query and data entry report. If you want to set the default value for the drop-down tree widget, how can this be achieved? As shown below:

2. Implementation ideas

• When the drop-down tree is in the parameter panel, click the drop-down tree and fill in the full path of the default value in the "Properties> Advanced>Widget Value" position.

• When the drop-down tree is in a cell, simply fill in the full path of the default value in the cell.
  

Note: The entered default value can be the actual value of the widget or the displayed value, and the final displayed value is the displayed value.

1. The drop-down tree in the parameter panel

Fill in the full path of the default value in the "Properties> Advanced>Widget Value" of the widget. The rules for filling in the default value are as follows:

• Single-select drop-down tree. The default value must write the full path , separated by the parent node .

     Example: Headquarter, Financial department, Director

• Multi-select drop-down tree. The default value must be written in the complete path, used between parent nodes , separated, and separated by multiple values ; separated. 

     Example: Headquarter, Financial department, Director; Headquarter, Financial department, Accountant

1) Example

To Build Drop-down Tree, select the drop-down tree widget , Fill in theHeadquarter, Financial department, Director in the "Widget Value'', as shown below: 

2) Save

Click "Data Entry Preview", the widget will display the minister by default , as shown in the figure below:

2. Data entry drop-down tree in the cell

After adding the drop-down tree widget to the cell, just fill in the default value directly in the cell. The filling rules are as follows:

• Single-select drop-down tree: The default value must write the full path , separated by the parent node .

     Example: Headquarter, Financial department, Director 

• Multi-select drop-down tree: The default value must be written in the complete path, used between parent nodes , separated, and separated by multiple values ; separated.

Example: Headquarter, Financial department, Director; Headquarter, Financial department, Accountant

1) Create a new dataset and tree dataset

As shown in the figure below:

2) Build tree

EnterHeadquarter, Financial department, Director; Headquarter, Financial department, Accountant in the cell , select the Drop-down Tree widget, check Multiselect , clickBuild Tree , select Automated Build, tree data set selectTree1 , Actual Value and Display Value Is the Department ID and Department_name , as shown in the figure below:

3) Save

Click "Data Entry Preview", the effect is as shown in the figure below:

Problem phenomenon

The drop-down tree of cells with default values will not automatically expand to the corresponding level, as shown in the following figure:

Solution

Click "Template" and select "Data Entry Settings" in "Web Attributes". On the "Data Entry Settings" interface, select "Individually set for the template", and click Add JS Event at "Event Settings". The event type is "Start Loading". As shown below:

The JavaScript code is as follows:

FR.Core.Plugin.ExtraWidgetConfig.autoExpandTreeNodes=true;

Effect preview