> ## Content Index
> Fetch the complete content index at: https://blog.jestor.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Track Training and Certification
- URL: https://blog.jestor.com/track-training-and-certification/
- Published: 2026-09-17T22:40:46.000Z
- Updated: 2026-09-17T22:40:46.000Z
- Author: Bruno Bannach

To **track training and certification**, connect completion records to both the person and the course. Tracking by course alone cannot answer who is currently qualified.

## Why certification lapses unnoticed

Completion is recorded once and validity is not tracked.

- Certifications expiring with no warning
- No view of who is qualified for a given task
- Training records held by an external provider
- Compliance questions answered by asking around

## What the structure needs

- **A courses table**, with validity period per course
- **Completion records**, connecting person and course
- **A completion date**, driving the expiry calculation
- **Evidence**, attached as a certificate
- **An expiry warning**, before qualification lapses

## How to set it up in Jestor

1. Create courses and completions tables in **Jestor**, connected to employees.
2. Record the completion date and attach the certificate.
3. Calculate the expiry date with a formula field from the validity period.
4. Set an automation notifying before the certification lapses.
5. Build a view showing who is currently qualified for each course.

## Why choose Jestor for qualification tracking?

Because completions are connected records in **Jestor**, the two questions that matter — who is qualified, and what expires soon — are both filters rather than reports someone assembles.

The certificate attached to the record means the evidence and the tracking are the same thing, which is what an audit of qualifications asks for.

## Frequently Asked Questions

### How is the expiry date derived?

A formula from completion date and validity period. See [jestor.com](https://jestor.com/?ref=blog.jestor.com).

### Can I see who is qualified?

Yes, as a filtered view.

### Where is the certificate kept?

Attached to the completion record.

## Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

## Get to know Jestor

With **Jestor**, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by **AI**. Discover Jestor at [jestor.com](https://jestor.com/?ref=blog.jestor.com) and see how to take your company's operations to a new level of efficiency and control.