The 'Edit Grid' library extends the functionality of Editable Grids
and makes them more effective. The following functions have been
implemented as form segments and to optimise performance, they
are applied only to the forms they are used on.
Automatically set a
column to a value
from the form
|
Typically this is used to add the current
Folder ID to allow “Child” related
tables for a Folder to be maintained
from an Editable Grid.
(Currently this cannot be done in e-Work without
writing custom scripts for each form).
|
Blank a Grid Column
|
Enables an auto number field in an
Editable Grid.
(This function appears to be addressed in e-
Work V6.5 for SQL Server at least).
|
Set a Column from
a Name/Value
Dropdown selection
|
Extends the functionality of the
standard name/value dropdown
selection (available in e-Work V6.6) to
Editable Grids.
|
Set a “Check”
Column
|
Provides the ability to set check
columns (Y/N, T/F etc) in Editable Grids.
e-Work V6.5 does not support check fields in
Editable Grids.
|
Insert and Delete
Buttons
|
Currently users have to be told how to
add and delete rows in Editable Grids.
This function avoids this by adding the
required buttons to the form.
|
Total Columns
|
Automatically sums selected columns.
|
The 'Edit Folder Grid' library extends the functionality of Editable Grids by
automatically recording the FolderID in the first field of the grid (which is hidden).
This enables records to be associated with that folder. Without this code this
cannot be achieved - i.e. all records will be applicable to all Folders.