4.1.4 Setting Column Editing Options
Note: Column editing options are available only if product is licensed for Viewsheet Forms.
When you configure a table as “editable” (see Table Properties: Advanced Tab), you can place restrictions on which columns may be edited by users, and what types of values can be entered.
To set the editing options for a particular column, follow the steps below:
1. Right-click the column header, and select 'Column Option' from the context menu. This opens the 'Column Option' dialog box.

2. In the 'Column Option' dialog box, select 'Enable Column Editing' to make the column editable by users.
Note: The Viewsheet's onLoad Handler script is re-executed each time the user makes an edit to an editable table. See Accessing User-Modified Data in a Table, in Dashboard Scripting, for more details.
3. In the 'Column Editor' menu, select the type of editing control you wish to provide to users. The available options are 'Text Editor', 'ComboBox Editor', 'Date Editor', 'Number Editor', and 'Float Editor'.

Each type of column editor provides settings which allow you to restrict the values that a user may enter into the column. This allows you to perform validation checking on user input. See Validating User Input for the available settings.
See Also
Table Properties: Advanced Tab, for information on enabling end-user table editing.
| << Table Properties: Advanced Tab | © 1996-2013 InetSoft Technology Corporation (v11.4) | 4.1.5 Validating User Input >> |