SleekView Charts for Appointment Hour Booking: slot dashboards
Appointment Hour Booking by CodePeople stores each booking as a row in its appointment table tied to a slot and a CP form definition. SleekView Charts reads it directly and renders slot-utilisation dashboards a salon, clinic, or studio owner can actually use.
♾️ Lifetime License available
Slot bookings, mapped to a chart layer
Appointment Hour Booking by CodePeople stores each booking as a row in wp_cpabc_appointments, with date, time slot, form ID, and submission data captured per appointment. Each form definition lives in the CodePeople forms tables, and the slot configuration is read from form definition options. The plugin's admin gives a per-form bookings list with date filtering, which suits triage and limits any owner-level review of slot utilisation or per-form volume.
SleekView Charts treats wp_cpabc_appointments as a chart dataset. The booking date is read as a real datetime column, the slot time as a categorical column, and the form ID as the foreign key for joining form definitions. An owner dashboard pins this month's booking total as a Number, charts bookings per form as a Donut, ranks slots by utilisation as a horizontal Bar, and plots daily booking volume as an Area chart across the chosen range.
Aggregations run through indexes on form ID and date, and per-form submission data filters cleanly. A multi-location install with thousands of historical bookings renders the whole dashboard in well under a second.
Workflow
Read CodePeople bookings as a dataset
Source from cpabc_appointments
wp_cpabc_appointments as the dataset base. Each row is one booking with date, slot time, form ID, and the form's submitted field data ready as columns for charts.
Pivot slot and form columns
Configure four chart cards
Save per-form chart boards
Sample dashboard
Charts you can build from Appointment Hour Booking
Bookings made this month total
wp_cpabc_appointments whose booking date falls in the current month across all forms, with the previous month's number underneath for week-on-week context.
Count
Bookings distribution by form
wp_cpabc_appointments, surfacing which CodePeople forms drive most of the booking volume across the active date range on the install.
Count
group by form_id
Top time slots by booking count
wp_cpabc_appointments. Surfaces peak slots and underused windows so owners can adjust availability.
Count
group by slot_time
Daily booking volume trend
wp_cpabc_appointments. Useful for spotting weekday patterns and campaign-driven booking spikes.
Count
group by appointment_date
Comparison
Default AHB admin vs SleekView Charts
AHB per-form bookings list
- AHB ships a per-form bookings list, not a cross-form chart dashboard
- Slot-utilisation rankings require counting across paginated lists
- Per-form booking-volume comparisons are not surfaced as native charts
- Daily booking trend charts across a selectable range are not built in
- No saved per-role boards for reception, owners, or finance staff
SleekView Charts
-
Cards built on
wp_cpabc_appointmentsjoined to form definitions - Number, Donut, Bar, and Area cards mapped to real booking columns
- Cross-form booking comparisons and slot rankings in one dashboard
- Daily booking trends across selectable ranges without exports
- Per-role boards gated by WordPress capabilities for clean separation
Features
What SleekView Charts gives you for Appointment Hour Booking
Cards, not per-form lists
Pick the dimension, the metric, and the chart type per card. Build a slot utilisation bar one week and switch to a per-form booking donut the next, without exporting CSVs or building a custom report.
Forms and bookings joined
The booking row, the slot time, and the CodePeople form definition join into a single SleekView dataset, so every chart card on the dashboard reads from the same join and groupings stay consistent.
Per-role saved boards
Reception, owners, and finance each save the board they care about. WordPress capability gating decides who opens which dashboard so each role lands on the right chart view by default.
Audience
Who builds AHB charts dashboards with SleekView
Salon and clinic owners
Per-form volume and slot utilisation rankings on one board, so the week's most-booked slots and underused windows are visible at a glance before scheduling decisions.
Reception and front desk
Today's bookings, this week's slot mix, and pending confirmations visible in a single dashboard. Replaces eyeballing per-form admin pages with one chart board.
Finance and bookkeeping
Booking-driven revenue trend per form and per slot filtered by date range. Month-end reconciliation runs from a saved chart board, not a series of CSV pivots.
The bigger picture
Why CodePeople bookings need a chart view
Appointment Hour Booking solves the slot-locking math cleanly: each form configures its own day grid, the booking flow respects slot capacity, and the admin captures the submission per appointment. What it doesn't do is summarise across forms or slot times in any flexible way. Owners ask the same handful of questions every week: how many bookings we ran, which slot fills fastest, which form drives the most demand, whether daily volume is rising.
Each question is one chart against the cpabc_appointments table that already lives inside WordPress. SleekView Charts gives that dataset a rendering layer with cards that map cleanly to operational questions: Number for the KPI, Donut for the mix, Bar for the ranking, Area for the trend. The plugin keeps owning the slot logic, the chart board gives the team the cross-form view that pure plugin admin has never delivered.
Questions
Common questions about SleekView Charts for Appointment Hour Booking
No. The AHB per-form bookings lists stay where they are. SleekView Charts sits alongside as a configurable layer so owners, reception, and finance each get the cross-form chart dashboards the plugin doesn't ship today, without changing how the booking form itself works on the frontend.
 Yes. Per-appointment form submissions are stored alongside the booking row. SleekView pivots each form-field column into a typed dataset column and uses it as a chart's groupBy or valueColumn, so custom intake fields become charts without writing any custom SQL or PHP.
 
The form_id column on wp_cpabc_appointments joins onto the CodePeople form definition tables and resolves to a readable form label. A single saved configuration drives the join, so every chart on the dashboard uses the same form mapping consistently.
Yes. A horizontal Bar grouped by slot_time with a counted aggregation ranks slots by booking volume. Filter the dashboard date range and the form, and the ranking scopes automatically without per-card adjustment from the user opening the board.
 Yes. A date range, form filter, or slot filter at the dashboard level cascades to each card on the board. A weekly capacity review and a quarterly trend can share one saved configuration without duplicating filter selections card by card on every dashboard.
 Cards query the live AHB table on render. A new booking created from any CodePeople form on the frontend appears in every card on the next reload, with no separate sync, scheduled refresh, or cache flush step between the booking and the chart update.
 Yes. Aggregations run server-side using the indexes on form_id and appointment_date that AHB already maintains. A multi-form install with thousands of historical bookings across many slots renders the whole chart board in well under a second on a typical host.
 Yes. Each saved board is gated by a WordPress capability, so reception, owners, and finance each open the dashboard that matches their job. The slot utilisation board and the finance revenue board stay separate by default for each user logging in.
 Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- German Market
- Wpc Product Bundles
- Funnelkit Stripe Gateway
- Checkout Plugins Stripe Woo
- Wp Simple Pay
- Yith Woocommerce Product Image Gallery Slider
- Woocommerce Shipping Australia Post
- Yith Woocommerce Subscription
- Woocommerce Name Your Price
- Woocommerce Follow Up Emails
- Woocommerce Quickbooks
- Woocommerce Tab Manager
- Woocommerce Product Vendors Pro
- Woocommerce Pdf Vouchers
- Woocommerce Payments Stripe