Zeon Signs

Admin Login

This area is restricted to authorized administrators only.

← Back to Team Hub
→ Open Jobs Board → Checklist Tool ← Back to Hub

Admin Dashboard

Edit checklist sections and items, manage settings, and reset to defaults. Changes are saved automatically to this browser and applied immediately to the checklist tool.

Import Open Jobs CSV

Drag & drop or select your CSV file. Jobs will be upserted by Project#.

📂
Drop CSV here or click to browse
Requires: Project# and Status columns. All other columns are stored and shown in the job detail view.
Current Jobs in System
Loading…
Kanban Board Settings
Salesperson Colors

Choose a badge color for each salesperson. Colors appear on cards in the Kanban board and rows in the List view.

Pipeline Display Settings

Choose which stages appear in the Pipeline widget on the homepage and in what order. Drag rows to reorder. Toggle the eye to show/hide a stage. These settings are independent from the Kanban board.

Create View

Select which status columns to show in this view. Uncheck to hide a column.

Manufacturing Checklist
Low Complexity Checklist
Ship-In Checklist
Service Checklist
Permit Checklists

Shared by Manufacturing & Ship-In. Add one checklist per municipality.

Review QR Code

Upload your customer review QR code here. It will appear at the bottom of every printed checklist. The image is stored in this browser — upload it once and it's always ready.

No QR uploaded

Accepts PNG, JPG, GIF, or SVG. Recommended size: 300×300px or larger for best print quality.

How it works: Select your QR image and click Save. The image is stored in this browser and will automatically appear on all printed checklists going forward. If you clear your browser data you'll need to re-upload it.

⬆️ Import ABQ Permit Export

Download the Excel export from the ABQ permit portal, then import it here. Permits are merged — existing records updated, new ones added. Job numbers are matched to Open Jobs by address.

→ Open ABQ Permit Portal (log in, search your permits, export to Excel)

📂 Drop .xlsx file here or click to browse

Accepts the standard ABQ permit portal export format

Current ABQ Permit Count

permits stored in Supabase

👁 View Permits Page →
📁 Closed Jobs List

Import a CSV of closed/completed jobs so the Permits page can link permits to past work. This list is internal — it does not appear on the Open Jobs board or anywhere else.

View Permits Page

📋 Same format as Open Jobs CSV

Requires a Project# column. Optional: Name, Salesperson, Status. All other columns are stored and used for address matching.

📂 Drop .csv file here or click to browse

Same column format as your Open Jobs export

Closed Jobs Stored

jobs

💰 Turned In for Billing

Import a CSV of jobs turned in for billing. Used by the Permits page for candidate matching only — not visible on any other page.

📋 Same format as Open Jobs CSV

Requires a Project# column. Optional: Name, Salesperson, Status. All other columns are stored and used for address matching.

📂 Drop .csv file here or click to browse

Same column format as your Open Jobs export

Billing Jobs Stored

jobs

⏳ Pending Jobs

Import a CSV of pending jobs. Used by the Permits page for candidate matching only — not visible on any other page.

📋 Same format as Open Jobs CSV

Requires a Project# column. Optional: Name, Salesperson, Status. All other columns are stored and used for address matching.

📂 Drop .csv file here or click to browse

Same column format as your Open Jobs export

Pending Jobs Stored

jobs

📧 Expiration Email Notifications

A daily automated check runs on your Netlify server. It emails the people below when any issued permit is expiring within your threshold window.

OFF

Each PM will only receive alerts for their own permits. Pulled automatically from your Open Jobs list.

Receives a summary of all expiring permits regardless of salesperson.

Each owner listed here will also receive the full summary of all expiring permits.

Emails are sent once per day. Only permits with status "Issued" are included.

⚙️ One-time Setup Required

  1. Create a free account at resend.com
  2. Verify your sending domain (or use their free onboarding@resend.dev address for testing)
  3. Create an API key in Resend → copy it
  4. In Netlify: Site → Environment Variables → add RESEND_API_KEY = your key
  5. Also add SUPABASE_URL and SUPABASE_KEY as env vars (same values from this admin page)
  6. Add the file netlify/functions/check-expiring-permits.js to your repo (provided separately)
☁️ Cloud Sync (Supabase)

Connect a free Supabase database so the job board is shared across all browsers and devices. Once configured, uploading a CSV here will automatically push the jobs to the cloud — everyone will see the updated board instantly.

One-time setup
  1. Go to supabase.com and create a free account & new project.
  2. In your project, click SQL Editor in the left sidebar and run this SQL:
create table hub_data (
  key text primary key,
  value jsonb not null,
  updated_at timestamptz default now()
);
alter table hub_data enable row level security;
create policy "Public access" on hub_data
  for all using (true) with check (true);
  1. Go to Project Settings → API and copy your Project URL and anon / public key.
  2. Paste them below and click Test & Save.

This is the public anon key — safe to use in a browser for an internal tool.

☁️ Sync Diagnostics

Use this to verify that settings are being saved to the cloud and to force-push everything if something seems out of sync. If you see "Write blocked" below, follow the fix instructions.

⚠️ If writes are blocked: Open your Supabase project → Table Editor → hub_data → RLS Policies → make sure a policy exists that allows INSERT/UPDATE for the anon role. Run this SQL in the SQL Editor if not:
create policy "Allow anon writes" on hub_data
  for all using (true) with check (true);
🧪 Beta Database Sync

Copy data between production and beta databases. Safe to run at any time — it overwrites the target with a fresh copy of the source.

Change Admin Password

Minimum 6 characters. Write it down somewhere safe — there is no recovery option.

Danger Zone

⚠️ Reset All Checklists to Default

This will remove all customizations you've made to every checklist and restore the original items. This cannot be undone.

📦 Inventory CSV Upload

Upload a SquareCoil inventory export (.csv) to populate the Inventory page. All items are stored in Supabase and are immediately visible to the team.

Expected columns (from SquareCoil export):

ID, Description, Size, Category, Vendor, Purchase Cost, Purchase UOM, QOH, Cost UOM, Cost, Last updated

📂

Drop CSV here or click to browse

SquareCoil Inventory export (.csv)

Current Inventory in System
Loading…
📦 Inventory Editor

Edit subcategory names and keyword rules inline. Drag to reorder items, subcategories, or whole categories. Click Save Changes when done.

Loading…
⚙️ Settings

QR Code — Inventory Help Form

Upload a QR code image that links to your inventory request/correction form. It will appear at the top of the Inventory page when staff tap the "QR Code" button.

📋
Current QR

Drop image here or click to browse

PNG, JPG, or GIF — recommended square


QR Code — Service Inventory Form

Upload a QR code image that links to the service inventory request/correction form. It will appear on the Service Inventory page when staff tap the "QR Code" button.

🔧
Current QR

Drop image here or click to browse

PNG, JPG, or GIF — recommended square


QR Code — Kit Builder Help Form

Upload a QR code image that links to your kit builder help or feedback form. It will appear on the Sign Comp Kit Builder page when staff tap the QR code button.

🔧
Current QR

Drop image here or click to browse

PNG, JPG, or GIF — recommended square

🔧 Service Inventory Editor

Edit service categories and standard inventory items in one place. Three category types: standard (pulls from master inventory), custom (manually entered items), tiered (price tier lists).

🔧 Service Categories

Loading…

📦 Standard Inventory Items

Only categories assigned to the service inventory are shown. Add or remove them below — changes are saved with Save All.

Loading…
Loading…
📚 Parts Library

Reusable part definitions — SignComp extrusions, hardware, and reference items. Parts defined here can be added to any kit.

Loading…
🔧 Kit Builder

Create and manage cabinet kit configurations. Each kit defines which parts are needed for a specific depth and face type combination.

Loading…
📊 Import Labor Analysis CSV

Upload the daily Labor Analysis Report. Each upload is saved to history — the dashboard shows trends over time.

📂
Drop CSV here or click to browse
Accepts the standard "Labor Analysis Report" CSV export. Each file is stored with a timestamp so history builds up automatically.
Upload History

No uploads yet.

👁 View Labor Dashboard

Crop Section Detail

Click and drag on the PDF to select just the drawing area, then click Apply Crop.

⏳ Rendering PDF…
No selection