Medical Sales College Automates Admissions & Placement

Running a FileMaker solution? We build, fix, and extend FileMaker databases. Schedule a Free Consult →

Medical Sales College

Medical Sales College replaced three disconnected databases and constant copy-and-paste with one admissions-to-placement system that flags new applicants within 10 minutes and builds employer introduction emails in seconds.

At a glance
Client Medical Sales College
Industry Post-secondary education, medical device sales training
Project Custom admissions, student records and job placement system
Launched Spring 2018
Team eXcelisys lead developer; Kurt Knippel (project manager)

Client

Medical Sales College is a post-secondary school that trains students for careers in medical device sales and helps graduates find jobs with employers.

Challenge

Every student’s details were typed in up to three times: once when they applied, again when they were accepted, and again when they reached job placement. Each step lived in a separate database.

Placement was the biggest time sink. To introduce one graduate, staff pulled details from several screens and pasted them into emails, sometimes 20 to 30 per graduate.

“The big goal was to improve efficiency and automate what we are trying to do.” — Scott Binder, Executive VP of Student Services, Medical Sales College

Solution

eXcelisys built one connected system that follows each person from application to job placement.

1. Applicants apply online through the school’s WordPress site. The system checks for new applications every 10 minutes, loads them automatically and alerts recruiters.

Questions about your project? We have answers. Talk to an eXcelisys developer — no sales pitch, just straight advice.

Book a Free 15-Min Call →

Online application data auto-filled into the applicant record

2. Acceptance emails fill themselves in from the applicant record.

Acceptance email auto-filled from the student record

3. When an applicant is accepted, their record becomes a student record and student-only fields open up. Nothing is retyped.

Student record with student-only fields unlocked after acceptance

4. At graduation, the record is already available to placement staff.

5. Placement staff tick the states a graduate wants to work in, choose an email template, and the system writes a personalized introduction to each matching employer.

Placement screen for choosing employers by target state

Employer introduction email template before auto-fill

Employer introduction email after auto-fill with graduate details

“The coolest feature is in pulling the data to generate the emails.” — the lead developer, eXcelisys

Results

Measure Before After
Times each student’s data is typed in Up to 3 0
Time to spot a new applicant Whenever staff checked Within 10 minutes
Employer introduction emails Assembled by hand, 20–30 per graduate Generated in seconds

The project took longer than the client expected. “It took a lot longer than I thought,” Binder said. Kurt Knippel, who managed the project, explained why: “The more new capabilities you add, the more testing and refinement required.”

Have a process like this?

If your team retypes the same data at every stage, we can connect those steps. See our custom database development and integration services, or talk to a Solutions Services Consultant.

Related services: custom databases, integrations, FileMaker database development services and WordPress website services.

Contributing Editors:

Kurt Knippel
Lisa Frick
Christo