Training records will be linked to Contacts in Upvise
Training Matrix in the Forms app can be used to keep track of expiring documents, with a visual dashboard colour coded expired or expiring-soon documents.
Tasks will be created as reminders for team members to action and renew documents when needed.

...

Before You Start

Before you start using the form, the below should be reviewed.

Expand

title	Before you start:

Before using the training record, you should completed a review of the below form template fields:

Field: F1 (Training Record): “Qualification Name”
1. This is the List of licences and certification’s you’d like to record.
2. Examples are “White Card”or “Drivers licence”.

Image Added

Field: F3 (Training Record): “Type”
1. This is the List of the Type of Qualifications you’d like to record.
2. Examples are “Diploma” or “Induction”.

Image Added

Forms

3. Field: F12 (training record): ”Employees”

a. this should be looking for your “employee” contact group in upvise.

Image Added

This field should be hidden.

Note: Do not rename or delete any fields in this template as the Matrix function and Task generation will cease to work.

Screen Guide:

Form name: Training Record

...

Note: when there is no expiry populated, there will be no reminder task generated.

Customising Training Records

You are able to add additional form fields into the training record form to capture more details if required. e.g. training provider. Standard form fields should be retained and hidden if they are not required. Additional form fields will not reflect in the matrix display.

Importing Training Record Data

An import option is available in upvise to import training record data in BULK.

The import process does not generate Task reminders or allow for BULK image imports.

Expand

title	1. Navigate to the Training Record Template

Navigate to the Training Record Template (Forms > Templates > Training Record)

Expand

title	2. Extract the import template

Click on the ellipsis
Select “Import Forms”

Image Added

Download Form Import

Image Added

An Excel file will be exported for the data to be populated

Expand

title	3. Prepare the Data Import File

You will have a blank Excel file with the below headings.

Column Header	Details	Example
id	The forms ID. This can be the Same as the Name.
Name	The Form Name you Want Displayed	Image Added
Date	Today’s Date	Image Added
Status	1 = Submitted If you Import the forms in any other status they will need to be manually submitted.
Owner	The owner of the submitted training record. see Users
LinkedID	Workbench Person Id You can see this by exporting your contact list to excel in upvise or checking the ID in workbench	Contact>Export Image Added Workbench > Person Image Added
LinkedRecord	Contact
Employee	Employee’s Full name as it is in workbench
Qualification Name	Qualification Name Note: this must be reflected in your qualification list defined in your template first.
or Enter
Type	Type Note: this must be reflected in your qualification list defined in your template first.
Assessment Date	Date the assessment occurred
Expiry Date (If Applicable)	Date the record expires
Attendees Signature	N/A cannot import images
Verified by	Employee’s Full name as it is in workbench- this may be different to the employee the record is for
Verification Signature	N/A cannot import images
Notes	any notes if required