 

 [    ](https://www.facebook.com/sharer/sharer.php?u=https://www.skvare.com/markdownify/node/438&title=One%20Platform%20for%20Registration%2C%20Payments%2C%20and%20Certificates%20Across%20Johnson%20County "Share to Facebook") [    ](https://www.linkedin.com/sharing/share-offsite/?url=https://www.skvare.com/markdownify/node/438 "Share to Linkedin") [    ](mailto:?subject=One%20Platform%20for%20Registration%2C%20Payments%2C%20and%20Certificates%20Across%20Johnson%20County&body=https://www.skvare.com/markdownify/node/438 "Share to Email") 

 

 

#  One Platform for Registration, Payments, and Certificates Across Johnson County 

 Customer Database (CRM) Maintenance and Support Training and Documentation 

 

 



 Image

Image

 ![Child drawing on paper with color pencils](/sites/default/files/styles/case_study_main_image/public/joco-childcare-drawing.png.webp?h=5c428798&itok=hmWR9ik7)

 





 

## Overview

Johnson County Government needed a better way to manage public class registration, payments, contact records, and reporting across departments.

What started as a childcare licensing tool grew into a shared system used by multiple teams. Working with Skvare, the County built a unified platform using Drupal and CiviCRM that connects public registration with internal operations.

## Challenge

Johnson County manages many public programs. Each department has different rules, reporting needs, and fee structures.

Before this project:

- Registration processes varied by department
- Staff handled manual steps for tracking attendance and issuing certificates
- Reporting did not always align with department-specific financial needs
- Public users experienced disconnected tools

Over time, demand grew. Departments needed:

- Repeatable event setups
- Clean data capture
- Better financial tracking
- Self-service tools for participants

The County also wanted to maintain a consistent, branded public experience.

## Solution

Skvare built a unified system that connects registration, payments, certificates, and reporting.

### A Single Public Experience

Residents register for programs through one county-branded site. Classes feel like part of one system, not stitched together tools.

Behind the scenes:

- Drupal manages content and presentation
- CiviCRM manages events, contacts, payments, and reporting
- Custom fields support department-specific requirements

Each event can:

- Define whether certificates are available
- Select the correct certificate template
- Capture custom data such as contact hours or case numbers

### Automated Certificate Printing

Several departments needed printable participation certificates.

Skvare reviewed and extended the CiviCRM certificate extension. The team:

- Installed and configured the certificate module
- Patched and improved extension behavior
- Created custom event fields to control certificate access
- Built landscape PDF formats
- Configured message templates per program

By building self-service certificate printing directly into the event system, staff in Childcare Licensing and Mental Health no longer generate or distribute certificates manually — freeing them to focus on program delivery.

Participants who attend qualifying events can log in and print their own certificates from their dashboard.

This work included:

- Conditional "Print Certificate" links
- Custom template logic
- Token configuration per event
- Permission adjustments for secure access

The result is a controlled, repeatable certificate workflow built into the event system. Skvare also contributed a patch from this project upstream to the CiviCRM certificates extension, where it was reviewed and merged — making the improvement available to the broader open-source community.

### Cleaner Financial Accountability

Each department tracks revenue differently.

The system captures fees cleanly and supports department-level reporting. Financial data aligns with internal tracking needs.

### Scalable Department Adoption

What began with childcare licensing expanded to other programs, including mental health and public training events.

The structure supports:

- Multiple certificate templates
- Event-specific rules
- Department-specific reporting
- Continued expansion

As adoption grows, departments gain smoother registration, cleaner data, and better reporting.

## Results

Johnson County now operates a unified, secure registration and certificate platform.

*Operational improvements*

- Self-service certificate printing
- Reduced manual administrative work
- Standardized event setup
- Repeatable template-based workflows

*Technical improvements*

- Patch contributed to the CiviCRM ecosystem
- Secure role-based access controls
- Stable PDF generation and formatting
- Structured token-based messaging

*Strategic impact*

- Vendor-independent, open-source platform
- Consistent public experience across departments
- Ongoing security, maintenance, and performance stewardship

The system continues to expand as more departments adopt it.

Technology serves the County's programs and residents, not the other way around.

If you are planning improvements, [let's talk](/lets-talk).