Overview
Problem
When you use a widget in a cell for data entry, if you have set Actual Value and Display Value in Data Dictionary of the widget, the actual value is displayed in the cell when the widget is in the blur state after data entry. In this case, how to retain the display value after data entry?
Implementation Method
When the widget is in the blur state after data entry, the program will send the actual value corresponding to the entered value of the widget to the cell for display. Therefore, to address the above-mentioned problem, you just need to modify Display of the cell where the widget is located, and set Actual Value and Display Value in Data Dictionary of the cell to match those in Data Dictionary of the widget.
Note:1. Actual values are submitted to the database without being affected by the solution.
2. The solution is not supported if Returned Value's Type is set to String for drop-down checkbox widgets.
Example
The example takes the Product table in the built-in database FRDemo as an example.
Template Design
Add drop-down box widgets for cells A2 and B2, respectively, as shown in the following figure.
Set data dictionaries of the widgets in cells A2 and B2, as shown in the following figure.
Display Setting for the Cell
Select cell B2, select Data Dictionary under Cell Attribute > Display, and set the data dictionary, as shown in the following figure.
Effect Display
Save the template and click Data Entry Preview. The actual value is displayed when the widget in cell A2 is in the blur state, while the display value is displayed when the widget in cell B2 is in the blur state.
The solution is also supported on mobile terminals. The following figure shows the effect.
Template Download
For details, you can download the template Retaining the Display Value of the Widget in a Cell After Data Entry.cpt.
Previous：Returning Display Values in a Drop-down Tree in a Cell
