Page History

The text entered as column description appears as tool tip on the column headers.

Wrap lines at the column's width. If disabled, then long lines show ellipsis (...) at the end in order to fit the column's width.

Newline control characters in the input string ((char)10) are always converted to a line break, that is, <br/> in HTML.

A Combo Box allows to input predefined values.
Prepare a table that should be edited:

In this grid users should only type in their age group.
In the Portlet Designer choose the column and go to the column properties and choose "Static combo"

Click on Edit Static Combo Values, so that a new window opens:

Define the values that can be chosen and the text that should be displayed.
Finally the user can only choose the predefined values:

This is the functionality if two columns with true/false values exclude each other (e.g. male/female)
Prepare a table with the two or more columns. In the TIS Designer mark the first column (e.g. male) and go to the Column Properties. There choose a group, which defines which columns belong together.

Now repeat this step for the second column (e.g. female).
Now in the Editable Grid only one of the two columns can be chosen.

Automatically or manually Save

Users can choose if data is automatically sent to the database or if it is sent only at clicking the save button.
This settings can be made in the Portlet Designer.

The standard setting is "automatically". The advantage of manual sending the data is that several inputs in the Editable Grid can be done quicker.
Sending the data to the database must not be mixed up with saving the table.

Default values can be defined for new rows in the Portlet Designer.

Add following function to TISBoardSettings.js, which replaces the 01.01.9000 to the today's date and 02.01.9000 to the tomorrow's date.

Please note that the portlet name (in the following example "a00 Default Values") has to be specified. This may be a regular expression as well.

TISBoard.standardValsAdapter = [
 
        [ /a00 Default Values/, function(rec, standardVals, columnTypes) {
                for(var j=0;j<columnTypes.length;j++) {
                        if(columnTypes[j].DefaultValueSet) {
                            switch(columnTypes[j].Datatype) {
                                case TISBoard.ColumnDescriptionType.DateTime:
                                case TISBoard.ColumnDescriptionType.DateTime_UTC:
                                case TISBoard.ColumnDescriptionType.Date:
                                case TISBoard.ColumnDescriptionType.Date_UTC:
                                        var dI = 'c'+j;
                                    
                                        if( Math.abs(standardVals[dI] - new Date(9000,0,1)) < 1000) {
                                                standardVals[dI] = new Date();
                                                standardVals[dI].setHours(0,0,0,0);
                                        }
                                        if( Math.abs(standardVals[dI] - new Date(9000,0,2)) < 1000) {
                                                standardVals[dI] = new Date();
                                                standardVals[dI].setHours(0,0,0,0);
                                                standardVals[dI] = standardVals[dI].add(Date.DAY, 1);
                                        }
                                break;
                                default:
                                break;
                            }
                        }
                    }
                return standardVals;
        }]
];

The node containing the TIS Board - Read editable data table 7.0 is not connected to TIS Board