Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Click New (button).
Name: Type in a name for the new Class.
Data Type: Select an option from the dropdown list (Standard or Assets).
Click the checkbox next to Auto Description / Specification to have those fields automatically created, or
type in a description in the block beneath Description (Tag) and Specification (Tag).
Description (SQL): This field is unavailable if Auto Description / Specification is selected.
Customise the Description as follows:
Click Edit (button) next to Description (SQL) to open a form with the available SQL Tables and Fields.
Click Template (button) to add a shell to work from.
Click the field you want to edit.
Select a Table, and double click one of the available fields to replace the field you previously selected.
Click Save (button).
Specification (SQL): This field is unavailable if Auto Description / Specification is selected.
Customise the Specification as follows:
Click Edit (button) next to Specification (SQL) to open a form with the available SQL Tables and Fields.
Click Template (button) to add a shell to work from.
Click the field you want to edit.
Select a Table, and double click one of the available fields to replace the field you previously selected.
Click Save (button).
Warning (SQL):
Create a warning (e.g. field is not filled in or a status not set) as follows:
Click Edit (button) next to Warning (SQL) to open a form with the available SQL Tables and Fields.
Click Template (button) to add a shell to work from.
Click the field you want to edit.
Select a Table, and double click one of the available fields to replace the field you previously selected.
Click Save (button).
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select Edit from the context menu.
ℹ️ Input Fields allow you to create more fields or checkboxes for the Class.
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select Edit Input Fields from the context menu.
Click New (button) to create a new field.
Fill in the details as required:
ID: Auto-generated.
Name: Auto-generated but you can overtype it to give it a more descriptive name (recommended).
Caption: Type in a caption.
Editor: Select an option from the dropdown list.
Layout: Select an option from the dropdown list of where the field will be displayed.
Caption: Select an option from the dropdown list of where the caption should be displayed.
Width: Type in the width of the field (only applicable to certain fields e.g. text fields).
Decimal: Type in how many decimal places to use (if applicable).
Arrows: Move the line up or down the hierarchy (only applicable if there are multiple input fields).
Menu: Allows you to change the hierarchy or delete the line item.
Create Input Fields as explained (above).
Click Menu (button) > Create selectable Stored Procedure.
A pop-up will confirm that the procedure was created.
The code will be copied to your clipboard.
Navigate to an SQL Input Field and paste the code.
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes
Navigate to the Classes (tab).
Right-click a class and select Edit Checklist from the context menu.
Click Add (button).
Description: Type in a description.
Code: Type in a code.
Type: Select a type from the dropdown list. If Auto is selected, SQL is required. See the below tutorial.
Click Save (button).
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to the Classes (tab).
Right-click a class and select Edit Checklist from the context menu.
Click Edit (button).
Type: Select Auto from the dropdown list.
Right-click a checklist and select Edit SQL from the context menu.
Click Template (button) to prefill the form in the right format or enter your own SQL.
Change any of the fields as needed.
Click Save (button) on the Template, and Save (button) on the pop-up.
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select View / Edit Description (SQL) from the context menu.
Click Template (button) to prefill the form in the right format or enter your own SQL.
Change any of the fields as needed.
Click Save (button) on the Template, and Save (button) on the pop-up.
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select View / Edit Warning (SQL) from the context menu.
Click Template (button) to prefill the form in the right format or enter your own SQL.
Change any of the fields as needed.
Click Save (button) on the Template, and Save (button) on the pop-up.
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select View / Edit Note (Tag) from the context menu.
Type in or edit the tag.
Click Save (button).
Click Close (button).
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select View / Edit Note (SQL) from the context menu.
Click Template (button) to create a new template or enter your own SQL.
Change any of the fields as needed.
Click Save (button).
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select Copy from the context menu.
Confirm that you want to copy the class from the popup.
Edit any of the fields (as described under How to Create a Class).
ℹ️ Before you can delete a Class you will need to delete any of the SQL fields linked to the class. Right-click the item you want to delete and select every option from the context menu one at a time and delete or clear the fields.
Navigate to Main Menu > Items > Items.
Click Menu (button) > Edit Classes.
Navigate to Classes (tab).
Right-click a class and select Delete from the context menu.
Confirm the deletion on the pop-up.