Editing Data

If the Data Table Editor is in the editable mode, the values within the table may be changed.

Renderer and editor used to display and modify value in each cell depend on several factors.

• Field type

• Editor/Renderer specified in field declaration (that is a part of Table Format)

• Availability of Selection Values declared for this field in Table Format

• Whether the field value is NULL

There are some special cases when non-standard editors are used:

If the field is declared as Nullable and its value is NULL, it is shown as <Not Set> in DTE. Click the cell to start editing and set a non-null default value for it.

You can reset the value back to NULL using the Remove Value operation in the cell context menu.

If a field format contains selection values, editing is performed using a drop-down box.

If Extendable Selection Values flag is set in Field Format, any custom value can be typed in the text field next to the combo box if Other option is selected in it.

Integer, Long, String and Float values are edited in a normal text field.

Boolean values are edited using checkboxes and are represented by Yes (for TRUE) or No (for FALSE) in read-only mode.

Date and Date/Time values are edited using a Date Picker.

Colors are selected using a Color Picker.

Data Table fields (i.e. fields whose values are actually entire data tables) are edited by a nested Data Table Editor that appears on a separate page. The page opens when you click [...] button in the cell containing the embedded Data Table.

Default Data Block editor allows to upload or download a file of any type.

Date-only editor allows to specify a date using Date Picker, but time specification is not allowed.

Time-only editor allows to specify a time in string form, but date cannot be selected.

Bar renderer shows Integer, Long, Float and String values as percentages of maximum defined by Editor Options.

String values are converted to numbers on the best effort basis.

Period editor allows to specify a time period as a certain number of selected time units.

Password editor is very similar to the usual text area, but types characters are now shown.

Values cannot be copied from cells that use this editor.

Reference editor displays clickable references in blue underlined font.

Clicking on a reference initiates a server action.

Long String values can be alternatively viewed and edited in a Text Area editor.

String values corresponding to Context paths and context masks are specified using a Context Mask Selector component. It looks like a usual text field with a button on the right.

Pressing the [...] button opens an Entity Selector component to allow building the mask by pointing and clicking.

Data Block fields may contain images, sounds or generic files.

Files, sound and images are inserted into the cells using a File Selector.

Images contained into the Data Table are displayed as a thumbnail (see previous screenshot). Clicking on a thumbnail opens a full-size image view.

Sounds can be played back by clicking on the Play button.

Was this page helpful?

Tell us more

Send

Thank you!