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).
Mobile Web App UX Audit Category: Interaction Design, UI / User Interface, Usability Testing, Visual Design Budget: ₹1500 - ₹12500 INR
13-Mar-2026 17:04 GMT
SQL Server Application Support Category: .NET, C#, Programming, Data Backup, Data Protection, Database Management, Microsoft SQL Server, Performance Tuning, SQL Budget: $15 - $25 USD
13-Mar-2026 17:04 GMT
Type English Handwritten Notes Category: Content Writing, Data Entry, Editing, English Translation, Proofreading, Transcription, Typing, Word Processing Budget: $10 - $30 USD
Restaurant Review Reel Editor Category: Adobe Premiere Pro, CapCut, Content Creation, Content Strategy, Instagram Marketing, Social Media Marketing, Video Editing, Video Post Editing, Video Production Budget: $10 - $30 USD
13-Mar-2026 17:01 GMT
Dog Care Chatbot Development Category: AI Chatbot Development, AI Development, Android, Mobile App Development, Natural Language Processing, PHP, Python, REST API Budget: €750 - €1500 EUR
Minimalist Android UI/UX Design Category: Android, App Design, App Development, Graphic Design, Mobile App Development, Mobile Development, UI / User Interface, User Experience Research, User Interface / IA, UX / User Experience Budget: ₹600 - ₹1500 INR
13-Mar-2026 16:59 GMT
UST Groundwater Geologist Needed in Portland, OR Category: Environmental Consulting, Environmental Engineering, Geology, Report Writing, Research, Research Writing, Risk Assessment, Statistical Analysis Budget: $10 - $5000 USD
13-Mar-2026 16:57 GMT
Full Mobile App UI Design Category: Android UI Design, App Design, Game Design, Mobile App Development, UI / User Interface, Unity, Unity 3D Budget: ₹1500 - ₹12500 INR
13-Mar-2026 16:57 GMT
Event Website From PDF Category: Animation, CSS, CSS3, HTML, JavaScript, Parallax Scrolling, Web Development, Web Design Budget: ₹1500 - ₹12500 INR
