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).
Course Website Design & Build Category: Content Management System (CMS), Graphic Design, HTML, PHP, UI / User Interface, Web Design, Web Development Budget: $15 - $25 USD
18-Feb-2026 10:50 GMT
PDF to Excel Conversion Project Category: Data Cleansing, Data Entry, Data Extraction, Data Management, Data Processing, Excel, PDF Budget: $20000 - $50000 USD
18-Feb-2026 10:48 GMT
Conversational Explainer Reels Editing Category: Adobe Premiere Pro, After Effects, Animation, DaVinci Resolve, Motion Graphics, Video Editing, Video Post Editing, Video Production Budget: ₹100 - ₹400 INR
18-Feb-2026 10:48 GMT
Multi Platform Social Media Management Category: Advertising, Content Writing, Facebook Marketing, Google Adwords, Graphic Design, Internet Marketing, Social Media Management, Social Media Marketing Budget: $30 - $250 USD
18-Feb-2026 10:46 GMT
game developer needed Category: C#, Programming, C++, Game Consoles, Game Design, Game Development, Game Testing, Game UI, Performance Tuning, Unity, Unreal Engine Budget: $750 - $1500 USD
18-Feb-2026 10:45 GMT
Elegant Sticker Design for AC Fridge Category: Adobe Illustrator, Photoshop, Corporate Identity, Covers & Packaging, Creative Design, Graphic Design, Logo Design, Sticker Design Budget: ₹12500 - ₹37500 INR
18-Feb-2026 10:44 GMT
Handwritten Egyptian Arabic Transcription Category: Arabic Translator, Copy Typing, Data Entry, Microsoft Word, Proofreading, Transcription, Typing, Word Budget: $10 - $30 USD
