UNITS TRACKER

Syncing…
CS In Queue Production Shipping Shipped
📜 Execution log 0

How this simulator maps to your Apps Script

Every interaction below calls a JS function that mirrors, line for line, a function in the code you gave me. Nothing here is decorative — it's the same routing logic running client-side against sample rows pulled from your workbook.

onEdit(e)
processEdit(e)
Changing the Order Status select on any row is the simulated "edit to column L." The row is located, its old status is compared to the new one, and the same branching your script does runs: Customer Service-only rules first, then the workbook-wide Shipping/Shipped rules. Trigger: any Order Status dropdown
addTimestamp()
Setting status to In Queue on the Customer Service sheet stamps column Q with the current time — nothing moves, exactly like your script's early return. Trigger: Order Status → "In Queue" (Customer Service only)
moveRowToMultiple()
findSheetLoose()
Setting status to Production on Customer Service reads column H (Unit Model), splits it on commas, and copies the row into every matching destination sheet — a comma-separated model like "FA2, FA1/GS2" fans the same row out to both tabs, stamping column R on each copy. Names are matched loosely (trimmed, case-insensitive), just like findSheetLoose. Unmatched names produce a warning toast instead of a silent failure. Trigger: Order Status → "Production" (Customer Service only)
moveRow()
Shipping and Shipped are workbook-wide rules — they fire no matter which sheet the row currently lives on, moving it to the Shipping or Shipped tab and stamping column S or T. Trigger: Order Status → "Shipping" / "Shipped" (any sheet)
returnOrderToCustomerService()
Customer Service is also workbook-wide: setting status to Customer Service on any tab moves that row back to the Customer Service sheet. If the order was fanned out to multiple unit tabs (same Order No., or same PO + Customer), every related row is pulled back together. Trigger: Order Status → "Customer Service" (any sheet)
updateAuditSheet()
After every edit, the Sales Team tab is fully rebuilt: it walks the 10 tracked sheets in order and pulls Order No., PO No., Customer, Unit Model, and Order Status (columns E–H and L) from every populated row. It's read-only here for the same reason it's a generated view in your sheet — it exists to be rebuilt, not edited. Trigger: automatically, after any move — or "Rebuild Sales Team Sheet Now"
Logger.log()
ss.toast()
Every move, warning, and failure is written to the execution log (bottom right) — that's your Logger.log calls — and surfaced as a toast in the corner, matching ss.toast(message, title, timeout).

Tracking Scanner

Center the long barcode in the frame (horizontal). UPS & FedEx use 1D barcodes (Code 128). Hold steady in good light. Chrome on a phone works best.

No scan yet — aim at a barcode on the label.

Tip: fill the width of the yellow/scan box with the barcode only (avoid other barcodes on the label). If UPS misreads, paste the 1Z number from the label. Apply writes Notes/Tracking on an LTL row.

Notes / Tracking

Full notes for this row.

Export Shipped

Export orders that hit the Shipped stage during a business week (Mon–Fri), based on the Shipped timestamp. Exported rows are removed from the Shipped tab.

Select a week to see matching orders.

Remove exported data?

This will download a CSV and permanently remove the matching rows from the Shipped tab in the live app. This cannot be undone from the board.

Export Shipping

Export orders that hit the Shipping stage during a business week (Mon–Fri), based on the Shipping timestamp. Rows stay on the board — nothing is removed.

Select a week to see matching orders.

New Order

Added to the selected Filters & Shipments tab.

New RMA

Added to RMA TRACKER.

New Order

Added to Customer Service — same as a new row entered at the top of the live sheet.

Change Password

Update the password for your account. You’ll stay signed in after saving.

Add PTO / Out

Record time off for an employee on this calendar tab.

Confirm with password

Enter your password to continue with this sensitive action.

Settings

Admin-only. Manage users, roles, and the option lists used by app dropdowns.

Admin — full access including Settings, queue reorder, and Reset to Seed Data.
Editor — edit orders, status routing, add/delete rows; no Settings, queue reorder, or seed reset.
Viewer — read-only: view sheets, search, and export KPIs.

Username Role Password

Add user

Admins can always add and edit PTO on the Calendar page. Grant access to other users below so they can add/edit/delete PTO entries on Shipping, Production, Filters, and Customer Service calendars.

Add or remove values used by dropdowns across the board. Order Status values stay fixed (they drive routing logic).

Hold Reason — Customer Service
Hold Reason — Production sheets
Production Operators
Unit Models
Filter Names — On Order (Filters tab)
On Hold — User names