The Register Spread screen is used to view and modify Framework ECM data for a selected work sheet. The column headings displayed differ based on the Framework ECM fields selected for the register.
Understanding The Register Spread
...
Icon/Action | Description |
---|---|
Export The Export function will create an MS Excel file from the current displayed Work Sheet. The appearance and content will be exactly as currently selected, including any changes to the sorting or criteria made during the session. A default format is applied to the file name ; [workbook]_[worksheet]_[ddmmyyyy hhmmss].xls This name can be modified on saving. |
...
The row count appearing in the status bar of the register spread gives the number of records being displayed. This count updates whenever a new set of records is presented; that is, if the Work Book or Work Sheet selections are changed or if further Selection filters are applied.
Importance of Refresh
The Register is a very simple review and editing tool, and multiple changes can be made during a session.
It is possible for a change to appear to have been made, but it will not have been committed due to a number of underlying rules.
Restriction examples are:
- It is not possible to copy/paste content with different data type. For example, you cannot copy a boolean Yes answer to a date field. However, most data types can be copied then pasted into a String field, such as Lot Number.
- Popup values cannot be copied/pasted to one another. For example, you cannot copy a House Type from one cell to another.
- Drag/Drop of values is not permitted at all.
- Copy/Paste applies to a single cell only.
Info | ||
---|---|---|
| ||
It is recommended that after any Copy/Paste the Refresh button is clicked to check the expected changes have been committed. |
There may also be changes made by other users in Framework ECM or Register that have not yet updated on the Spread. If a specific value has been changed during your session, and you try to update, a conflict message will appear and you will have the opportunity to update, accept the alternative change or cancel.
Data Types And Editing
All fields that display as white in the register spread can be edited. If the field appears yellow, it is locked.
...
Data Type | Example Fields | Editing Methods |
---|---|---|
String | Street Address, Notes, Land Number |
|
Decimal | Cost Amount, J/BCon Amount | |
Double | Energy Rating | |
Integer | ||
Boolean (Small Integer) | Required? |
|
Date | Ordered, Received, Completed |
|
List Entity | Administrator, Land Suburb Name | A List field will appear with an arrow at the side. Click this arrow to produce a "Select" dialog where the valid selections are available. Select the required item from this list. |
...