Workflow and forms automation: Take the retyping out of your staff’s day

Workflows and forms that do the routine steps for your admissions, registrar, financial aid and finance teams, inside the student system they already work in.

The problem

Ask any office in a college what they would stop doing if they could, and the answer is a list of small, repeated steps: updating a status after a document arrives, sending the same email, moving a record from one queue to another, typing a form into a screen.

The student system can usually do these things by itself. Often it was never set up to, or it was set up years ago by someone who has left, and nobody is sure what the existing automation does.

What I do

  • Workflows in the student system. Built with Workflow Composer (Windows Workflow Foundation), running on the events and schedules that Anthology Student (formerly CampusNexus and CampusVue) provides.
  • Forms. FormsBuilder forms for staff and students that validate what is entered and put it where it belongs.
  • Power Apps and Power Automate. For the steps that live outside the student system, in email, documents and approvals.
  • An honest inventory. A report that classifies and documents the production workflows you already have, so you know what is running before anything is changed.

Why the automation lasts

Automation fails when it encodes how a process is drawn on a whiteboard and not how it is really done. I have done these processes by hand: as a registrar, in admissions and at the financial aid desk. I know where the exceptions are, and I build for them, because a workflow that handles the easy cases and breaks on the rest just moves the work.

How it runs

I sit with the people who do the work, or read what they do in the system, and write the process down in their words. We agree what the automation should do and what it should hand to a person. Then I build it in test, your staff tries it on real cases, and it goes live with a way to switch it off.

Self-check

How healthy is your workflow estate?

Ten yes, no or not sure questions an IT lead can answer about an Anthology Student Workflow Composer and FormsBuilder estate, each with one line on why it matters. The answers score into one of three bands, with the pages on this site that speak to the gaps. It runs in your browser and sends nothing anywhere.

Nothing leaves your browser. The scoring runs on this page, and no answer is sent or stored anywhere. These are ten general good-practice checks for a Workflow Composer and FormsBuilder estate, not a description of any one school.

  1. Is there a current list of every live workflow, with an owner and a plain description?

    When nobody can say what is running, every upgrade and every audit starts with guesswork.

  2. Does every workflow carry an environment guard, so a copy restored into test cannot email real students or call production services?

    A test refresh copies the workflows along with the data. Without a guard, the test copy behaves as if it were live.

  3. Are credentials and endpoint addresses kept out of the workflow definitions themselves?

    A password inside a definition is copied into every backup and every test refresh, and changing it means editing the workflow.

  4. Are there duplicate workflow names?

    Two workflows with one name are easy to confuse, and the wrong one gets edited or switched off.

  5. Does every workflow handle an error by logging it and stopping, rather than failing silently?

    A silent failure looks like success. The record is left half changed and nobody is told.

  6. Are there workflows nobody has touched in three years that still run?

    The process may have moved on without the workflow, or the workflow may still be right. Either way, someone should check.

  7. Do any live workflows point at test or debug endpoints?

    A production workflow calling a test address either fails quietly or sends real data somewhere it should not go.

  8. Is the business logic in stored procedures with a configuration table, rather than hardcoded in the definitions?

    A rule in a stored procedure can be read, tested and changed in one place. A rule buried in a definition has to be found first.

  9. Is there a test environment refreshed from production where changes are rehearsed?

    A change rehearsed on data shaped like the real thing shows its problems before students and staff do.

  10. Does a person approve each change before it reaches production?

    An approval step is the moment someone accountable reads what is about to change.

How the score reads

Healthy

The basics that keep workflow automation safe to change are in place: you know what is running, a test copy cannot reach real people, and a person stands between a change and production. Keep the list current, and treat each not sure as a small task.

Worth a look

Nothing here is an emergency, but a few gaps are the kind that turn an ordinary upgrade or a test refresh into a long week. The answers listed with the result are the ones to look at first. Most close with an inventory and a few conventions.

At risk

Several answers, or several not sures, point at an estate nobody can describe with confidence. That is common after years of automation by different hands, and it is fixable. Start with an inventory read from the system itself, then put guards and approvals in place before the next change.

Where the fixes live

Show how the score is worked out

Each question has a healthy answer. The other answer is the risky one and scores the question's weight: 4 safety questions (the environment guard, credentials, test or debug endpoints, and approval) score three points each, the rest score two. Not sure scores one point, and a question left blank counts as not sure. 2 points or fewer reads Healthy; 3 to 8 reads Worth a look; 9 or more reads At risk, out of a possible 24. The answers that scored are listed under the result, risky answers first, then the not sures.

Common questions

Questions people ask

How small or large a project do you take?

Small is welcome. Many engagements start with one painful report, one process that causes rework each term, or one task chosen so that success is easy to check. At the other end I have built whole-population migrations and the integration layer that keeps several systems in step, and larger programs move to a monthly retainer once the first piece is live. DataZak is one person alongside a full-time role, so I do not take on more than I can deliver to the agreement we sign. See services.

This answer on the questions page

What do you need from us to start?

A plain description of the systems involved, what is going wrong or what you want to exist, and any deadline such as a term start or an audit. Then a confidentiality agreement, read-only access arranged the way your security team prefers, and a test environment to build in. Before work begins we also settle in writing which tools may see which data, and name the person at your school who approves a change before it is applied. See security and data handling.

This answer on the questions page

How do you hand over at the end, and who owns what you build?

You own everything I build for you. At handoff you get the code, the documentation, the runbooks for how it works, how to restart it and how to switch it off, the evidence from the build, and a walkthrough for your team, so another engineer can take it on. A hosted integration is defined in code with an exit plan written down, so it can move to your own team when you are ready. See security and data handling.

This answer on the questions page

All common questions

Other services

Anthology Student consulting

Hands-on help with Anthology Student (formerly CampusNexus and CampusVue) from someone who has worked in it since 2007, first as a user and then building on it.

SIS integration

Connect your student system to everything around it, as changes happen, with a record of every change.

Reporting and dashboards

SSRS reports and Power BI dashboards your staff trust, including Crystal Reports rebuilt for the web client, by someone who has used those reports.

Data migration

Move student and financial aid data between systems with a rehearsal first and proof for every record.

Financial aid automation

Automation around financial aid data, built by a former aid administrator, with the evidence an auditor asks for.

Applied AI

Put AI agents to work on real operational tasks, with the controls and the audit trail a college needs.

Managed hosting

Nowhere to run an integration? I host and maintain it on Azure, in your subscription or a dedicated one.

All services

The full list, and the three ways an engagement can run.

Have a system that needs untangling?

Tell me what you run and where it hurts. The first call is 30 minutes, free, and you will leave with a clear next step whether or not we work together.

Search this site

Up and Down move, Enter opens the result, Esc closes.