Dashboard

2027 Show — Capital Region Flower & Garden Expo

Exhibitors
--
Total
--
Accepted
--
Pending
--
Missing COI
--
Missing Tax ID
--
Balances Due
Seminars
--
Speakers
--
Applications
--
Sessions
--
Confirmed
--
Pending
--
Emails Sent
Recent Registrations
CompanyTypeBoothTotalStatusCOITax ID
Loading...
🔒 Booth Holds — Expiring Soon
No active holds.
📞 Follow-ups Due
No follow-ups.
Speaker Applications
SpeakerTopicStatus
Loading...

Exhibitor Directory

All Exhibitors
CompanyContactEmailPhoneCategoryCOI ExpiresTax IDYearsActions
Loading...

2027 Registrations

CompanyTypeBooth SelectionBooth AssignmentElectricTotalStatusCOITax IDSRActions
Loading...

Floor Plan — HVCC, Troy NY

2027 Floor Plan
Available  
Assigned  
Hold   | Click a booth to select & assign  |  Shift+click for multiple
Click a booth to select and assign. Shift+click additional booths for larger spaces.
Additional Spaces
Loading...
🔒 Holds
Loading...

Add Hold

Reports

📥 Import from Cognito Forms
Submitted entries only — duplicates skipped
Select a Cognito CSV export (Renewal, Early Reg, or Standard):
📬
Booth Assignment Mail Merge
CSV with all assigned exhibitors — ready for Word or Outlook mail merge.
Include:
⭐
New Exhibitor Report
First-time exhibitors for the 2027 show.
📖
Program Directory
Exhibitor listing details for the show program.
🎟
Comp Ticket Report
All comp tickets issued — sorted by company name or ticket number. Includes exhibitors, speakers, sponsors, and floral designers.
Sort:

Speaker Database

Rolling year-to-year — like the Exhibitor directory

📸 Batch Photo Upload
Select all speaker photos at once — uploads to Supabase Storage & links to profiles
All Speakers
PhotoNameOrganizationEmailStatusSessionsActions

Speaker Submissions — 2027

Year-specific speaker registrations

All Applications
SpeakerOrganizationTopicsSessionsStatusActions

Schedule Planner

Speaker Confirmations

Speaker & Template
Placeholders: {speaker_name} {session_title} {session_day} {session_time} {session_room}
Preview & Send
Select a speaker to preview their confirmation email.

Social Posts

Select Speaker
🎨 Canva Copy Kit
Click any copy button — paste directly into Canva
Select a speaker above to see copy blocks.
✨ Post Copy Generator
Facebook Post
Select a speaker above.
Story Caption

Live Schedule

Preview of the public-facing schedule. Download as HTML, table, or PDF to publish.

Seminar Reports

--
Total Timeslots
--
Filled
--
Open Slots
--
Speakers
Confirmation Tracker
🚪 Speaker Gate List
✔SpeakerOrganization
Loading...
📅 Sessions by Day & Room
Loading...

Floral Designer Database

Rolling year-to-year — all designers across all shows

📸 Batch Arrangement Photo Upload
Upload post-event arrangement photos — links to designer profiles
All Designers
PhotoNameShop / AffiliationLocationEmailStatusEntriesActions

Floral Design Entries — 2027

Year-specific sign-ups grouped by lead designer

All Entries
DesignerShop / AffiliationThemed ClassesActions

Themed Classes — 2027

Sign-up grid with class capacity tracking

Loading...

Floral Social Posts

Generate post copy for featured floral designers — 2027

Select Designer
✨ Post Copy Generator
Facebook Post
Select a designer above.
Story Caption

Floral Design Reports

Sign-In & Credentials Sheet
Volunteer instructions: Grey numbers = entitled but not yet received. Black numbers = sent in advance. Click the ✏ to edit a designer's credentials.
✔ Designer Shop / Affiliation Themed Class(es) Goodie Bag Comp Tickets Button T-Shirt

Add Designer

Upload arrangement photo
No entries yet.

Add Entry

Quantities (each lead designer normally receives 1 goodie bag, 2 comp tickets, 1 button, 1 t-shirt)
Tickets sent in advance:

Add Themed Class

👥 Manage Advisors

Add New Advisor

Assign Designer

🎟 Edit Credentials

—
—
Once Date Sent or Ticket Start # is filled, the Comp Tickets column on the sign-in sheet turns black to show they've been delivered.

📧 Confirmation Email Preview

To:

Settings & Theme

👤 User Management
Loading users...
💾 Data Backup
Downloads all critical tables as a ZIP of CSV files. Recommended weekly during show season.
Tables included: registrations · exhibitors · payments · speakers · sessions · seminar_registrations · floral_designers · floral_classes · floral_entries · ticket_allocations · registration_notes · participation_years
⚠️ Storage Setup Required

Photo and logo uploads require two Supabase Storage buckets. Click Run Check to test them, or set them up now:

floral-photos
For floral designer arrangement photos (uploaded in Floral Design → Designers)
Not checked
exhibitor-logos
For Featured Exhibitor logos (uploaded in the exhibitor profile)
Not checked
To create a bucket: Supabase Dashboard → Storage (left sidebar) → New Bucket → enter name → check "Public" → Save
Event Details
API Keys
Saved to this browser only (localStorage). Never uploaded.
Theme Colors
Change each year to match the expo theme. Updates live on this page.
Sidebar Color#2d1248
Accent / Highlight#f0c040
Button / Primary#4a2060
Year Presets

Submit Speaker Application

Add Follow-up

Add Speaker

Upload new photo (replaces current)
Loading...

🔗 Merge Duplicate Speakers

Select two speaker profiles to merge. The "Keep" profile stays — missing fields are filled from the "Merge From" profile. Sessions and registrations are reassigned, then the duplicate is deleted.

Edit Session

Review Application

New Registration