Table of Contents

Tables & Items

Jordan Millar Updated by Jordan Millar

The Tables & Items area is where you can adjust certain configurations in your ChekRite portal such as Checklist Categories, Asset Categories, Employee Departments, Dynamic Lists and more.

Be very careful when using the Tables & Items area. If you delete something that is being used it can affect how your portal behaves and may break certain things.

Tables

Before you can start adding items to tables you need to add the Table itself. To do that:

  1. Navigate to Advanced > Customise > Tables
  2. Check to ensure the table you want doesn't already exist and if it doesn't push the New button.
  3. Enter the Name you want to call the table. You don't always need to name the table exactly the same as the Class as this might change for your business.
  4. Select the Class of the table, which determines where it is used

Table Classes

With the exception of a Dynamic List, each table class can only be used once. Here is a list of all the classes of table that are in ChekRite for you to add as and when you need them.

Class
Description

Asset Category

The categories of assets that appear in the drop down list inside the Asset Classes section of Sites. Items may be added on the fly in the Asset Classes tab but you can edit them here.

Asset Component

These are sometimes called component codes. These are a way of grouping together questions that might be related to the same component. e.g. whilst you might have 4 wheel questions on a car (front left, front right, etc.) you might want to group them all together under the component code of wheels for reporting purposes.

Asset Property

These are the Asset Properties for your assets. Define these here and they can be used elsewhere in the system including in questions, on assets, and even in controls.

Checklist Category

The categories of checklist that appear in the drop down list inside the Checklists section. Items may be added on the fly in the Checklists tab but you can edit them here.

Company Info

Where you can set the extra information fields for a company in the Info tab of Companies. This might include things like Company Number or Website. Define them as a table & items and then enter the values in the Info tab of Companies.

Dynamic List

You can create as many of these as you need. See the Dynamic List section below.

Employee Department

The department of employees that appear in the drop down list inside the Employees section. Items may be added on the fly in the Employees > General tab but you can edit them here.

Employee Position

The position or job title of employees that appear in the drop down list inside the Employees section. Items may be added on the fly in the Employees > General tab but you can edit them here.

Employee Title

The titles to be used for employees (e.g. Mr, Dr, Ms, etc.) in the Employee section. There are already a default set but if you want to create your own you can do it with this table.

Industry

Not used anymore.

Site Info

Where you can set the extra information fields for a site in the Info tab of Sites. This might include things like Insurance Certificate or Landlord name. Define them as a table & items and then enter the values in the Info tab of Sites.

Test Type

Not used anymore.

Dynamic Lists

Dynamic Lists are super cool. No really, they are. This is a way for you to define a list of items that pertain to your business and have users select them from a list. The really cool thing is that the end users can dynamically add to this list if you allow them to all without having to make a new version of a checklist and publish it again.

You can create as many Dynamic Lists as you need for your business. The following is an example set up for Customer Names.

Deleting a Table

Don't delete a table. Not ever. If any of the items in that table have been used in inspections you will potentially break the reporting. I am not even sure why we have a Delete button there.

Items

Once you have the table defined you can add items to it. To do that:

  1. Navigate to Advanced > Customise > Items
  2. Select the table you want to add items to from the table drop down list
  3. Enter the name of the item in the Item field
  4. Optional: Enter a description of the item in the Description field. This can be used for reporting and in a Dynamic List is also displayed on the screen under the item.
  5. Enter any other parameters that might appear in this section based on the class of table you selected. For example, in the Asset Properties table you can also select the Data Type, Analytics Label and decide if this asset property should also be used as an alternate asset ID.

Modifying & Deleting Items

Don't modify or delete items. If there is a spelling mistake then certainly fix it but if you change it from one value to another, then all the historical records such as inspections that were entered or assets that were created will take on that new value.

How did we do?

Designing Custom Controls

Contact