Overview
Application Scenarios
You can import values from Excel and convert them into desired actual values for storage through settings in Display > Data Dictionary. For example, when you import M and F from Excel, 1 and 2 are stored into the database instead.
Functional Logic
1. Install Excel import mark plugin first.
2. After you set Data Dictionary under Display, the imported value will act as the display value when submitted, and will be converted into the actual value and stored in the database according to the data dictionary.
3. Setting Data Dictionary > Formula is not supported.
Example
Preparing the Template
Setting Data Dictionary
Click cell C2, select Data Dictionary under Cell Attributes > Display, set Type to Custom, and add Actual Value and Display Value.
Click Template > Data Entry Attributes, add Built-in SQL, select Smart Submit and the embeded table Student, and bind the fields and cells.
Setting Excel Import
Click Template > Excel Import Mark, and tick Convert data to actual values to submit. For details, see Excel Import Mark.
Adding Mark the Import Button
Go to Template > Web Attributes > Data Entry Settings, select Individually set for the template, double-click Mark the import and add it to the toolbar.
Demonstration
1. Save the report, click Data Entry Preview, click Mark the import to import the Excel file.
2. After submission, preview the database table student, and you can see that the imported data in the gender column is the Actual Value.
Note: Excel import is not supported on mobile devices.
Downloading the Template
Click to download the template:Display Value Conversion During Excel Import.zip
Click to download the Excel: Display Value Conversion.zip