Build and track sales quotes on a Sheet — quotes and lines as two tabs, the App as the form, every change a versioned Sheet write.A sales quote builder over one Sheet: a Quotes worksheet (customer, PO number, dates, currency, total, status) and a Lines worksheet (item, description, quantity, unit price, amount). The App lists quotes, shows one with its lines, adds quotes and lines, moves a quote through draft, sent, accepted and declined, and recalculates its total — every write is a Sheet mutation with optimistic concurrency, so the Sheet stays the single record and a pricing or order-entry Agent can be attached to its changes later. No NetSuite connection is needed. Business area: Sales & CRM · Type: App Built for: Sales rep, Sales ops, Order desk
Data and resources
- Quotes sheet (Sheet): One Sheet containing Quotes and Lines. The App validates changes, calculates totals, and checks for concurrent edits before saving. The default creates both worksheets.
- View preferences (App state): The selected quote and status filter, per viewer.