Skip to content

Columns

Column Types

Type Description
TYPE_STRING
TYPE_INTEGER
TYPE_NUMBER
TYPE_DATE
TYPE_FLOAT
TYPE_RADIO
TYPE_CHECKBOX
TYPE_ZIP
TYPE_TEXTBOX
TYPE_INPUT
TYPE_MENU
TYPE_SELECT
TYPE_CALENDAR
TYPE_TIME
TYPE_NOTEPAD see data-type-input=19 in panel.forms.js
TYPE_HIDDEN_STD
TYPE_HIDDEN_DATE
TYPE_FILE
TYPE_FORM_SECTION see data-type-input=101 in panel.forms.js
TYPE_FORM_UPLOAD
TYPE_FORM_TEXT
TYPE_FORM_BUTTON
TYPE_PHONE
TYPE_HREF
TYPE_STRING_CONCAT
TYPE_STRING_CENTER
TYPE_STRING_RIGHT
TYPE_CURRENCY
TYPE_CURRENCY_SIGN
TYPE_KEY_PRIMARY
TYPE_KEY_SECONDARY
TYPE_KEY_STATUS
TARGET_TABLE
TARGET_EXCEL
FIELD_TEXT
FIELD_NORMAL
FIELD_HAS_TABLE
FIELD_DYNAMIC
mapValues_LEFT
mapValues_RIGHT

Column Properties

Here are all possible column properties and their purposes:

Property Description
num Need documentation
type Need documentation
origtype Need documentation
decimals = 0 Need documentation
alertLevel = 0 Need documentation
sum = 0 Need documentation
id Need documentation
alias Need documentation
delim Need documentation
format Need documentation
minimum Need documentation
alertCallback = ‘required’ Need documentation
propertyName Need documentation
suffix Need documentation
field = column::FIELD_NORMAL Need documentation
active = true Need documentation
readonly = false Need documentation
row = false Need documentation
tab = false Need documentation
col = false Need documentation
tabs = false Need documentation
total = false Need documentation
zeroValue = null This is the visible value to show when a column value equals zero. For example, if the zeroValue was set to ‘None’, then the word would show in place of 0.
pkey This is the parent key object. In other words, the table key. It contains the key information like database connection, table name, primary key and more.
name Column name is the field in the database table. It is set from the first parameter of the column method.
callback Need documentation
css = [] Need documentation
excel = [] Need documentation
rules = [] Need documentation
rowcol Need documentation

Table Columns

Table columns

Base Classes

Class Description Usage
inputcol Stdin F
hiddencol Hidden column (rw by javascript) F
textcol Static text B
datecol Date formatted mm/dd/yyyy B
calendarcol Stdin or choose date from calendar F