← All sketches

Example sketch

Tracking licences and certificates across an association

The sentence it all started with

“In our association, members' coaching licences and first-aid certificates expire without anyone noticing in time.”

This sketch is an example. We wrote the sentence; the concept was generated by an AI and edited by us; our renderer draws it.

Example sketch – not a client project

ConceptDocumentation and records

Certificate Register

Who is authorised for what, and until when: licences and certificates with reminders before they expire.

How we understood your problem

Certificates are scattered: copies in club folders, expiry dates in a head office spreadsheet, reminders in volunteers' heads. Nobody is warned in time. It only becomes visible once someone leads a group without a valid licence.

Who it's for

  • Head officeKeeps an eye on all clubs and reviews uploaded certificates.
  • Club boardSees its own coaches and what expires over the coming months.
  • MemberUploads the new certificate directly and receives the reminder.

Interface

Expiry

What is expiring?

Expired

6

across 4 clubs

Expiring in 90 days

41

28 already reminded

Clubs

  • Gymnastics Club North complete
  • Swim Club 2 expired
  • Sports Club South expiring
  • Rowing Club complete
  • Judo club 4 expired
  • Running Group West expiring

Coming up next

  • First aid Member 1184 in 9 days
  • Licence C Member 0932 in 12 days
  • Background check Member 2210 in 20 days
  • Lifeguard certificate Member 0457 in 23 days

Expiry days

November

3, 9, 12, 20, 23, 30

Review

Incoming certificates

New certificate

Attach photo or PDF

or browse

  • first_aid_1184.pdf awaiting review
  • licence_c_0932.jpg approved

Confirm certificate

Type
First aid
Issued on
14 Oct
Valid until
calculated, 2 years
Issuer
may be left blank

Confirm

Recently approved

MemberCertificateValid untilReviewed by
0932Licence Cin 4 yearsHead office
1377First aidin 2 yearsHead office
0457Lifeguard certificatein 2 yearsBoard

Data model

Data model as a table
EntityFieldType
Membermember_numberText
nameText
clubText
emailText
Certificate TypenameText
valid_monthsNumber
required_forText
CertificatememberReference
typeReference
issued_onDate
fileFile
confirmedYes/No
Relations between the entities
FromCardinalityToRelation
Member1:nCertificateholds
Certificate Type1:nCertificatedetermines validity

Market value

What this problem would be worth on the market: how the product could be offered if it were sold. Not our price, and not an offer.

Billed per unit per club

  • Most likely fit

    Club

    12 €

    per month · per club

  • Association, 20+ clubs

    8 €

    per month · per club

Volunteer structures don't pay per head. The club is the unit that carries responsibility.

Roadmap

  1. Stage 1

    Register

    All certificates with expiry dates in one place, imported from the old spreadsheet.

  2. Stage 2

    Reminding

    Staged reminders, upload by the member, confirmation by the head office.

  3. Stage 3

    Deployment check

    Visible per group whether its leaders hold all required certificates.

Core features

  • Expiry listEverything expiring in 30, 60 and 90 days, sorted by club.
  • Upload a certificatePhoto or PDF from the phone; the head office confirms with one click.
  • Certificate typesEach type has a validity period the association sets itself.
  • Deployment checkShows per group whether its leaders hold all required certificates.
  • RemindersBy email to the member first, then the board, then the head office.

Deliberately left out

  • No membership management: master data comes via import; dues and addresses stay where they are.
  • No course booking: the register says what is missing, not where to renew it.
  • No automatic authenticity check: a person looks at every certificate.

What the AI does

Reads type and issue date from the uploaded document and pre-fills the form.

What the AI explicitly does not doThe AI never confirms a certificate. It only becomes valid once a person has reviewed it.

Integrations

  • Membership system (import)
  • Email sending

Three questions we would ask you first

  1. Which certificates are truly mandatory, and do they differ by sport or age group?

  2. Who may confirm certificates: only the head office, or also club boards?

  3. May copies of background checks be stored, or only the date they were viewed?

A sketch, not an offer. Generated by an AI, rendered by us.