Smart Life USAll posts
Page 3 of 4
Google Sheets web app multiple screens: Apps Script doGet page routing — Receiving appointment system 4
When you look up how to create multiple screens in a Google Sheets web app, you’ll often see examples that create a separate Apps Script project for each screen. But if you run separate check-in, admin dashboard, and on-site lookup screens for something like a receiving appointment system, the number of projects explodes and URLs, permissions, and shared functions all drift apart, making real-world maintenance painful…
Google Sheets settings in one place: manage with a SETTINGS sheet
If you’re looking for a way to keep Google Sheets settings in one place, this post lays it out. When you use a Google Sheets receiving appointment system, you’ll often get requests like “For this week only, start at 8 a.m. instead of 9,” or “Turn off yard slots for now.” If you open the Apps Script code and edit constants every time, it’s easy to make mistakes, and the operator has to keep asking the developer for help…
Google Sheets dock doors auto-create: 30 doors, 50 yard slots
If you’re looking for a way to auto-create dock doors in Google Sheets, this post walks through it. When you build an inbound appointment system in Google Sheets, you always need a dock door and yard slot list. But in the field, this simple list is still often typed by hand. Once you have 30 doors and 50 yard slots, it’s easy to miss or mistype numbers. This post shows how to remove that repetition…
Google Sheets inbound appointment sheet structure — basics 1
If you found this by searching for how to build an inbound appointment system in Google Sheets, you’re probably a practitioner directly handling warehouse or logistics work. You may already have inventory management or outbound automation in decent shape, but the system for managing inbound time slots is still scattered across Excel, phone calls, and messengers. This post walks through, from scratch, a Google Sheets–based inbound appointment sheet structure you can copy, paste, and start using right away.
Google Sheets Apps Script Error Handling & Backup | LockService · try/catch · DriveApp Backup
If you’re looking for ways to handle errors and back up data in Google Sheets Apps Script, this post puts everything in one place. Once you automate warehouse or inventory operations with Google Sheets and Apps Script, there comes a point where “it just needs to run” is no longer enough and “it must not break” becomes more important. When one button click is tied to hundreds of inbound/outbound rows, stock aggregation, and dashboard refreshes, a single error or concurrent save conflict can corrupt data so badly that you can’t realistically restore that day’s work.
Google Sheets activity log automation | Apps Script 9
If you’re looking for a way to automatically log activity history in Google Sheets, this post lays it out. Even when the staff in charge of inbound/outbound changes, you need to be able to immediately see who saved what so warehouse responsibility is clear. When you manage inventory in Google Sheets, questions like “Who changed this quantity?” and “When was this shipped out?” come up often…
Google Sheets dashboard with Apps Script: see warehouse status at a glance
If you’re looking for how to build a Google Sheets dashboard, this post walks through a real setup. In an actual warehouse you often end up with an inbound sheet, outbound sheet, stock summary, putaway status, and load management sheet all open at once, jumping back and forth. Before the morning meeting, you waste time just pulling numbers from each sheet in Excel and Google Sheets, and the on-site walk-through gets pushed back. This article summarizes how to build a **Google Sheets dashboard** that shows inbound, outbound, and stock on a single screen, automatically.
Google Sheets outbound load summary automation
Managing outbound shipments in Google Sheets makes it hard to see what is actually going on a single truck. This post builds a per-Load outbound summary with Apps Script: totals by item, pallet and weight sums, and warnings for zero quantities, missing items and duplicate orders.
Google Sheets barcode scan input with Apps Script 6
Most people looking for a Google Sheets barcode scan input already own a handheld scanner, yet every inbound and outbound move still means jumping between the sheet and the device. This post builds an Apps Script sidebar where one scan plus Enter writes the row for you — with duplicate-scan protection and a scan log.
Google Sheets daily inventory report email automation
Even after you close out yesterday's stock, someone still has to rebuild the same summary every morning and email it. This post automates it end to end in Google Sheets: a previous-day inbound/outbound summary as an HTML table, pending receipts, near-full locations, and a time-driven Apps Script trigger that sends it on schedule.
Google Sheets warehouse rack layout visualization | Apps Script auto-color + locking
When you manage warehouse inventory in Google Sheets, you can usually see the quantity by location, but it’s often not obvious which racks are full or which areas are almost empty. This post walks through Google Sheets warehouse rack layout visualization: we’ll draw the actual rack shapes on the FLOOR_MAP sheet and…
How to Auto-Aggregate Inventory in Google Sheets | Apps Script Part 3
When you look up how to auto-aggregate inventory in Google Sheets, most examples use SUMIFS or QUERY. The inbound/outbound data gets stored fine, but once you try to view current stock by location and model, formulas get complicated and the sheet slows down. This post shows how to rebuild and refresh the entire STOCK sheet in one go using Google Sheets Apps Script…