Track Event Signups Over Time (by Date & Session) From Jotform
Jotform shows a signup count, not a trend. Here's how to see registrations over time — signups per day, per session, and pace vs. your last event — by grouping the submission date, plus the timezone and paid-vs-hold gotchas that skew the curve.
Jotform gives you a running signup count, but not a trend — it can’t tell you whether registrations are speeding up or stalling. To see signups over time you group the submission date by day (or by session), which means either exporting and building a date pivot, or using a tool that reads the date and session fields and charts the pace for you. The two things that quietly wreck the curve are timezone (off-by-a-day counts) and mixing paid registrations with free holds.
A count answers “how many so far?” A trend answers the questions that actually change what you do: Are we filling faster than last time? Which session is lagging? Did the reminder email move the needle? Jotform captures the timestamp on every registration — it just doesn’t plot it. Here’s how to turn those timestamps into a signups-over-time view.
Method 1 — Export and pivot by date
The dependable manual route is a date pivot in a spreadsheet:
- In Jotform, open Submissions (or Tables) and Download / Export → Excel (or CSV). Make sure the Submission Date column is included.
- Convert the submission date to your local timezone, then derive a plain day column (e.g.
=INT(A2)on a datetime, or a date-only formula) so all registrations from the same day share a key. - Insert a PivotTable: drag the day field to rows and a count (or the payment total) to values. That’s registrations per day.
- Add the session field to columns to get signups per day per session, and add a running-total column if you want the cumulative “how full are we” curve.
- Chart the pivot as a line to see the pace, and filter by payment status if you want a paid-only line alongside the all-signups line.
This works and it’s free. The cost is that you rebuild it every time you want a fresh look, and the timezone and paid-vs-hold steps are easy to skip — which is exactly what produces a curve that doesn’t match what you saw at the door.
Method 2 — A tool that charts the pace directly
If you check registration pace more than once per event, the point of a tool like TutuMarginis to skip the export. It reads your Jotform registrations (read-only), detects the submission-date and session fields, and charts signups over time — per day, per session, cumulative — without a spreadsheet. You can ask it in plain English (“signups per day for the Saturday session”) and get the line. As a new tool the honest claim is narrow: it automates the date-grouping and timezone handling you’d otherwise do by hand, and your data stays in your browser.
See the trend on live sample data ▸Getting the curve right — the gotchas
- Fix the timezone first. Group by the local-converted date, not the raw stored timestamp, or registrations near midnight land on the wrong day.
- Keep paid and free as separate lines.A single “signups” line that blends free RSVPs with paid tickets overstates committed attendance.
- Count sessions separately.A healthy overall trend can hide one session that isn’t selling; group by the session field to catch it.
- Align events by days-before-event. To compare pace to last time, plot cumulative signups against day -30, -14, -1 rather than calendar dates.
- Decide how holds count.Unpaid “reserve my spot” holds inflate the trend; either exclude them or track them as their own line.
Bottom line: a submission count is a snapshot; a date-grouped pivot (or a tool that builds it) is the trend. Handle timezone and the paid-vs-hold split and the curve will finally match the room. Related: getting total registration revenue from the same form and turning Jotform submissions into a chart or dashboard without Excel.
Frequently asked questions
Can Jotform show signups over time as a chart?
Jotform's Report Builder can show submission counts and some visualizations, but it charts all submissions equally and doesn't easily separate paid registrations from free holds or group cleanly by a custom session field. For a real signups-over-time trend you export with the submission date and group by day yourself, or use a tool that reads the date and session fields and charts the pace automatically.
Why do my daily signup counts look off by a day?
Almost always timezone. Jotform stores each submission timestamp in a timezone (often UTC or the form owner's setting), and if you group by that raw timestamp while thinking in your local time, registrations near midnight land on the wrong day. Convert the submission date to your local timezone before you group by day, and your daily curve will line up with reality.
Should I chart all registrations or only paid ones?
Chart both, but keep them as separate lines. All-registrations shows demand and interest; paid-only shows committed attendance and revenue pace. Mixing free RSVPs and unpaid holds into a single 'signups' line overstates how full a paid event actually is. Filter by payment status to split them.
How do I compare this event's pace to the last one?
Line up both events by days-before-event rather than by calendar date — e.g. day -30, day -14, day -1 — so an event in March is comparable to one in July. Compute a cumulative signup count per day-before-event for each event and plot them together; that shows whether you're ahead of or behind last time's pace.