...
| Name | Description | Screens (Click to view) | |||||
|---|---|---|---|---|---|---|---|
| Validator | Attach a Validator plugin to validate the input value. Please see Form Validator.
|
Figure 4: Validation & Data | |||||
| Min Number of Row Validation (Integer) | Defines the minimum number of rows required for input. | ||||||
| Max Number of Row Validation (Integer) | Defines the maximum number of rows possible for input. | ||||||
| Error Message | Error message to be shown when row requirements set above is not met. | ||||||
| Data Binder | |||||||
| Load Binder | Empty by default. An empty binder means the spreadsheet records will be saved/loaded as JSON format in the parent form & database table.See the list of available Form Binders. Recommended to use Multirow Form Binder so that each record are saved into a child table via a subform. | Store Binder | & Save Binders | Load Binder allows you to customize how and where the data are retrieved from, to populate the multi-row spreadsheet in the form. Save Binder allows you to customize how and where the spreadsheet row records are saved to. Empty by Empty by default. An empty binder means the spreadsheet records will be saved/loaded as a JSON format in the parent form & database table. See the list of available Form Binders. Recommended binder to use is the Multirow Form Binder so that each record are saved into a child database table via a subform definition. The binder will update the foreign key into each record that points to the parent database table. | |||
Supported Formula Functions
...