You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Definition
Spreadsheet Form Element allow users to perform many actions in an excel-like environment, depending on the use cases. A few examples of uses of spreadsheets are:
  • Database editing
  • Configuration controlling
  • Data merging
  • Workforce planning
  • Sales reporting
  • Financial analysis


Figure 1 : Sample Spreadsheet Form Element in the userview

 

Figure 2 : Spreadsheet Form Element Properties

 

NameDescription
SpreadsheetElement ID of the form element.
LabelSpreadsheet label/title.
Columns

The spreadsheet column(s) is defined here.

Sub-elementDescription
ValueField ID of the column.
LabelColumn header title/label.
Format TypeDefines the type of input to store.
Format

Defines the format to show data on the spreadsheet.

Default format type is Text.

Available Data Types:

  • Text - format the value as text
  • Numeric - accepts a numeric value
  • Date - accepts a date type value
  • Time - accepts a time type value
  • Checkbox - appears as a checkbox to check
  • Dropdown - appears as a dropdown menu to select options
  • Autocomplete - autocompletes any known phrases
  • Password - obscures any alphanumerical value into a password
  • Custom
Regex ValidationValidates input value to match the defined Regular Expression pattern.
FormulaDefines a formula to perform processing. Refer to Figure 1 & Figure 2 for a simple example.
ReadonlyDefines if the column is editable.

 

Figure 3 : Spreadsheet Form Element Properties - UI

 

NameDescription
Enable Header Sorting? 
Data Order Field ID 
Readonly 
Disable Add Feature 
Disable Delete Feature 
Show Row Numbering? 
Number of columns to fixed on left 
Number of spare rows 
Custom Settings (JSON) 

 

Figure 4 : Spreadsheet Form Element Properties - Validation & Data Binder

 

NameDescription
Validator 
Min Number of Row Validation (Integer) 
Max Number of Row Validation (Integer) 
Error Message 
Load Binder 
Store Binder 

 

 

 

 

  • No labels