This portlet displays a grid with data from a TIS Table. It allows to edit the data in the TIS Table, e.g., to change values, to add or delete rows, or to change the order of the rows. Data can also be copied into the editable grid from Excel (see Copying Data between Excel and TIS Board).
The following figure depicts the communication between TIS Editor, the TIS Table, and the TIS Board for this portlet. In TIS Editor, two data nodes are involved, one (init node) writes a TIS Table with the Generate editable data table 4.0 operator and the other (read node) applies the Read editable data table 5.0 operator to read the TIS Table. The Editable Grid Portlet reads the data from the TIS Table and modifies the TIS Table directly.
![](_scroll_external/attachments/7ab7b7ecba97/image2017-7-5_11-0-47.png)
Conflicts can occur when the table is edited by both, the Generate editable data table operation of the init node in TIS Editor and by the Editable Grid. In particular, when the init node is set to Automatic update (see Update process between data nodes), changes in an ancestor of the init nodes triggers the operation which overwrites data entered from the Editable Grid Portlet. Also, the operation can be triggered by an event from TIS Board, e.g., in order to create a new TIS Table with some user's name on Logon. The following options deal with this problem.
- Set parameter "Create only new table" in Generate editable data table 4.0 operator to true: The TIS Table can never be overwritten by the Generate editable data table operation.
- Set Update option in init node to "Manually": Changes from the Editable Grid Portlet can only be overwritten manually.
- Set Update option in init node to "Fixed": No changes can be made from either TIS Editor or the Editable Grid (changes in the Grid will be lost).
Task |
Actions |
Prepare in TIS Editor Step 1 |
Prepare the initial table for the editable grid in a data node (init node) in TIS Editor and write it to a TIS Table with the operator TIS Board - Generate editable data table 4.0. ![](_scroll_external/attachments/85cde1ca361d/worddavcaadf6ef978d75a69ec656c38b90d48d.png)
Enter a folder and a name for the TIS Table (can be a parameter) and check the option "Create only new table" if you do not want this operation to overwrite the table.
![](_scroll_external/attachments/7d2fd2154def/image2017-7-5_11-25-44.png)
Set the Update option to "Manually" if "Create only new table" was left unchecked and you do not want the table to update automatically (hence overwrite changes from the Editable Grid). The table can still be updated manually (changes overwritten).
![](_scroll_external/attachments/5d89c1b855ae/worddave8fee0c79a556644ca815128e4b4f8ff.png)
|
Prepare in TIS Editor Step 2 |
Create an empty data node (read node) and add the operator TIS Board - Read editable data table 5.0. ![](_scroll_external/attachments/cc5870acabc1/image2017-1-12_8-57-16.png)
Enter the folder and name of the TIS Table created in Step 1.
|
Prepare in TIS Editor Step 3 |
Switch on the symbol for TIS Board connection in the read node.
![](_scroll_external/attachments/9f600b662755/image2016-1-14-11-42-50.png)
|
Create in Portlet Designer Step 1 |
Create a Portlet, choose the TIS Editor project and the read node created previously, select Editable Grid portlet.
|
Create in Portlet Designer Step 2 |
Save portlet ![](_scroll_external/attachments/84b95db32d56/image2017-7-5_11-33-39.png)
|
Edit in Portlet Designer |
See Description in Formatting and Working with Portlets and Conditional Formatting for Grids.
Do not forget to save whenever you have edited something.
The result is something like this:
![](_scroll_external/attachments/0d6beb09960d/image2015-12-29-10-39-20.png)
Please note that you can navigate with tabs and cursor.
|
Save and close |
Save the changes of this Portlet and close it in the Portlet Designer. |
TIPS |
The Controller Portlet allows to manage the update and retrieval of data from an editable grid. Boolean values in the Portlet are represented by checkboxes. |
TIPS |
If you want to have an empty table that should be filled by the user from the Editable Grid do the following:
- Create a table with the columns you need with their respective data type and no rows.
- Create the Editable Grid. Rows can be added using the Add button
![](_scroll_external/attachments/664dfaf1018f/image2017-7-5_11-40-18.png)
|
|
See section Settings below for additional options. |
TIPS |
HELPTEXT IN GERMAN <font size="1"> <li>Hinweis: Symbole werden oft erst sichtbar, wenn die Maus im entsprechenden Bereich ist. </li><li>Eingabe Weg 1 für Tabellen: <img src="./res/silk/add.gif"> fügt neue Zeilen ein (rechts oben im jeweiligen Portlet) - <a style="target-new: tab;" href="http://www.youtube.com/watch?feature=player_embedded&v=Yc1Ub4UiljU" target="_blank">Videoanleitung</a>. </li><li>Eingabe Weg 2 für Tabellen: Kopieren Sie mit <img src="./res/silk/script_edit.gif"> bis zu 2000 Zeilen (dauert ca. 2 Minuten) mit Copy/Paste auf einmal hinein. - <a style="target-new: tab;" href="http://youtu.be/MU0qP8h5mXk" target="_blank">Videoanleitung</a> </li><li>Bitte drücken Sie danach das <b>Symbol </b><img src="./res/silk/Disk.gif"> rechts oben in diesem Fenster, um die Daten auf den Server zu übertragen. <span style="background-color: rgb(255, 255, 0);"><i>Die gelbe Kopfzeile im Fenster symbolisiert, dass Daten eingegeben aber noch nicht übertragen wurden! </i></span></li></font>
HELPTEXT IN ENGLISH <font size="1"> <li>Tip: Move your mouse over the portlet to make icons apear. </li><li>Path 1: <img src="./res/silk/add.gif"> fügt add new rows - <a style="target-new: tab;" href="http://www.youtube.com/watch?feature=player_embedded&v=Yc1Ub4UiljU" target="_blank">Videoanleitung</a>. </li><li>Path 2: Copy <img src="./res/silk/script_edit.gif"> up to 2000 rows (approx. 1 minute) with Copy/Paste. - <a style="target-new: tab;" href="http://youtu.be/MU0qP8h5mXk" target="_blank">Videoanleitung</a> </li><li>To save the data press <b>Symbol </b><img src="./res/silk/Disk.gif"> top right of the portlet. <span style="background-color: rgb(255, 255, 0);"><i>If the top of the portlet is yellow then data is not saved so fare. </i></span></li></font> |
See also Keyboard Shortcuts
Data Type |
Input |
Interpretation |
Date |
21 |
DD → 21.01.2018 using today's date |
Time |
3 |
HH → 03:00 |
|
320 |
HH:MM → 03:20 |
|
|
|
DateTime |
|
|
|
|
|
Settings
Column description |
A data column a description can be given that appears as a tool tip in the TIS Board. ![](_scroll_external/attachments/36f53e87f97b/worddavd79c666a049b371523dd0b9aef038835.png)
![](_scroll_external/attachments/c3ad36d19e80/worddavd83c5d70b8b5b198434d89c1182638f2.png)
|
Forced Line Break |
If Force Line Break option is activated then lines wrap at the column's width. If not activated 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.
![](_scroll_external/attachments/9e0f05ff3f9b/worddav437fb2ae7d7249e692423408be3c20df.png)
|
Combo Boxes (static list) |
|
Combo box (dynamic list) |
TIS Board - Dynamic selection for Editable Grid provides data for selection. |
Radio Buttons |
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 |
Default values can be defined for new rows in the Portlet Designer. ![](_scroll_external/attachments/7d352f3758c0/worddav83dab22f850b317513910202c480b009.png)
|
Static Combo |
Content that will be pasted via copy/paste will be checked if there is a static combo in one of the columns. |
General Properties |
![](_scroll_external/attachments/23f178a1fd50/image2016-1-14-10-2-51.png)
Property |
Description |
|
Keep column titles |
Column titles are not editable and are defined by the data node respectively TIS table. NOTE: If there are some edited column titles and this option is set, then it is necessary to save the portlet and reload it into the Portlet Designer otherwise the column titles will not be reset to the default. |
FLEX-428 - Editable Grid keep column titles Closed
|
Banded rows |
Alternating show rows with background color white and grey for better readability. |
|
Show Row Number |
Additional column with row numbers is shown. |
|
Show filter bar |
Displays an extra bar string filtering case-insensitive. NOTE: You must save changes before the next filter. ![](_scroll_external/attachments/4ccbad51e472/image2017-11-7_15-39-52.png)
|
FLEX-96 - Filter-Zeile für Grids (Geburtstagsliste) Closed
FLEX-2823 - Filter funktionieren nicht, wenn Spaltencaption eine Zahl ist Closed
|
Permit add rows |
Allow adding rows. The add icon is shown in the tool bar. |
|
Permit delete rows |
Allow deleting rows. The delete icon is shown in the tool bar. |
|
Send data only when saving |
See above Automatically or manually Save |
|
Enable selection mode |
Hides the tool bar and show a button for saving in the bottom.
|
FLEX-96 - Filter-Zeile für Grids (Geburtstagsliste) Closed
|
|
Troubleshooting
Problem |
Frequent Cause |
Solutions |
Editable Grid does not work |
Instead of the retrieval node, the fill node has the property ![](_scroll_external/attachments/fe4c043d2e55/image2016-1-29-17-7-46.png)
|
Switch on the other node
|
Several operations follow immediately after Retrieval |
Make additional nodes to separate the operations |
Cannot edit Editable Grid |
Portlet designer is open and portlet is not saved |
Save the portlet |
User rights are not properly set in TIS Board |
Obtain the necessary rights |
|
|
|
Also see Conditional Formatting for Grids.