I need an AppSheet app on top of my Google Sheet to manage site jobs on a map and allow engineers to tap a pin, edit fields (e.g., mark “Job Completed”), and have those updates write back immediately to the Google Sheet (with who/when logged). Additionally, I need stock/inventory management tied to engineers (issue/return parts, current holdings, low-stock alerts, serial capture).
Must-haves
Two-way workflow: From mobile map view, engineer taps a location → edits status/fields → updates persist back to the Google Sheet (audit: user + timestamp).
Inventory module:
Parts catalogue (SKU, description, phase compatibility if relevant).
Per-engineer stock ledger (issue, use on job, return) with current balances.
Link parts used to a job (qty + optional serials/barcodes).
Low-stock threshold per part (+ optional email/notification).
Security: Sign-in required. Engineers only see their assigned jobs (server-side Security Filter), admins see all.
Offline friendly with automatic sync when online.
Basic dashboards: My Jobs (map + table), Open Jobs, Completed; simple filters (Status/Platform/DeviceType).
Handover: short loom/video + doc covering how to add users, edit enums, add columns, maintain stock items.
Data scope (starting point)
Current single sheet of jobs (addresses, contacts, device type, notes, invoicing flags).
Construction Tender Administration Support Category: Construction, Construction Management, Microsoft Office, Microsoft Word, Project Management, Risk Management Budget: $8 - $15 AUD
11-Mar-2026 05:04 GMT
Invoice Data Input to Sheets Category: Data Analysis, Data Collection, Data Entry, Data Management, Data Processing, Excel, Google Sheets, PDF Budget: ₹750 - ₹1250 INR
11-Mar-2026 05:04 GMT
Realistic Alien & UFO Models Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max Budget: €30 - €250 EUR
OCR Data Entry in Sheets Category: Adobe Acrobat, Data Entry, Data Extraction, Data Management, Data Processing, Excel, Google Sheets, PDF Budget: ₹750 - ₹1250 INR
11-Mar-2026 04:52 GMT
PDF to Google Sheets Migration Category: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Excel, Google Sheets, Visual Basic Budget: ₹750 - ₹1250 INR
