How acc-tax-reighteen/spreadsheets-order-next works
This Google Apps Script web app collects sales orders: a salesperson opens the form, the server validates their Google-account email and loads reference data, and the browser submits the completed order for storage. The README also documents live customer search, multi-select, NOO entry, dynamic fields, and optional photo upload. Only the README was available as evidence, so relationships below reflect documented behavior; implementation details are not independently verified.
Main entry points: Index.html Order Form UI · Code.gs Initial Data
Components 15
Order Form
- Order Form UI
Index.html - Customer Search
Index.html - Customer Selection
Index.html - New Outlet Entry
Index.html - Dynamic Fields
Index.html - Photo Encoding
Index.html
Server Workflow
- Initial Data
Code.gs - Email Validation
Code.gs - Order Submission
Code.gs
Google Services
- Sales Spreadsheet
- Customer Spreadsheet
- Category and City Sheets
- Order Spreadsheet
- Photo Drive Folder
Other components
- Salesperson
Connections 15
- Salesperson → Order Form UI: opens
README.md - Order Form UI → Initial Data: requests data
README.md - Initial Data → Email Validation: validates email
README.md - Email Validation → Sales Spreadsheet: checks roster
README.md - Initial Data → Customer Spreadsheet: reads customers
README.md - Initial Data → Category and City Sheets: reads options
README.md - Initial Data → Order Form UI: returns form data
README.md - Order Form UI → Customer Search: offers search
README.md - Customer Search → Customer Selection: selects results
README.md - Customer Selection → New Outlet Entry: supports new outlet
README.md - Order Form UI → Dynamic Fields: shows configured fields
README.md - Order Form UI → Photo Encoding: encodes optional photo
README.md - Order Form UI → Order Submission: submits order
README.md - Order Submission → Photo Drive Folder: uploads photo
README.md - Order Submission → Order Spreadsheet: appends order
README.md