Administration & Registers

This is where the Registers, Work Books and Work Sheets are created.

Registers

A Register is the field template for the Work Sheets. It is a collection of Framework ECM fields relevant for its purpose, with each field representing a column on the Register Spread.

Settings such as column width, scroll lock, and field lock are set here, as well as the order the columns will appear.

Work Books

Work Books are a way of grouping Work Sheets.

Work Sheets

Work Sheets are a spreadsheet based on a selected Register with criteria applied.

Example

There is Register for Land Development and another for Permit Work Flow. A Work Book has been created for each of the active land estates.
In the Work Book for Avenue Estate, a Work Sheet is created for Land Development, with the criteria of the Land Estate = Avenue Estate, Job Status = Active, sorted by Land Lot Number (descending).

Another Work Sheet is created using the Permit Work Flow, with the criteria Land Estate = Avenue Estate, Job Status = Active, sorted by Job Contract Signed (ascending).
The same has been done for the Greenacres Estate, with the criteria for the Work Sheets set to Land Estate = Greenacres Estate.