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 | |
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 = '' | 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 |