1001 Freelance Projects -- Build AppSheet map app that writes back to Google Sheet

Latest Projects from
Freelance Marketplaces

View this project in detail (Note: you will be redirected to external marketplace)
Project title:
Build AppSheet map app that writes back to Google Sheet
Posted by:
External project from PeoplePerHour
Started:
10-Sep-2025 16:27 GMT
Description:
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). Add operational fields: RowID (UNIQUEID), JobStatus enum, CompletedAt/By, LastUpdated (ChangeTimeStamp), UpdateCount (ChangeCounter), AssignedTo (email), optional LatLong. New inventory sheets: Parts (SKU, Name, Unit, Active, LowStockThreshold). EngineerStock (EngineerEmail, SKU, QtyOnHand). StockLedger (Timestamp, EngineerEmail, SKU, Qty, Type=Issue\|Use\|Return, JobRowID optional, Notes, Serial optional). Normalise Yes/No fields, phone/email types, and enums (Platform: Passiv/Stingray; DeviceType: METER/MODEM/METER3). Key app features Map view (address or LatLong), pin tap opens Detail. One-tap actions: “Mark Completed” → sets status + CompletedAt/By. “Add Parts Used” → form to post ledger entries and reduce EngineerStock. Automations: Safety-net to stamp CompletedAt/By if status = Completed. Low-stock notifier when EngineerStock falls below threshold. Performance strategy: Precompute LatLong or use FullAddress; slices + security filters tuned for ~1,000+ rows. Acceptance tests From mobile map: change Status to Completed → Sheet shows status + CompletedAt + CompletedBy within seconds. Stock: Issue 3 × SKU123 to Engineer A → EngineerStock shows +3. Record use of 1 on Job #X → EngineerStock decrements, Job shows parts used. Security: non-admin only sees “My Jobs”. Offline: update status/parts offline → syncs correctly when back online. Deliverables Working AppSheet app linked to my Google Sheet. Cleaned schema (with added inventory tables). Security filters, slices, actions, automations. Short handover video + quick reference doc. 2 weeks light support for small fixes. Nice-to-haves (quote separately) Auto-assign engineer by postcode area. Barcode/QR scan for serials. Invoicing/partner compliance dashboard. Photo capture on completion (stored to Drive). Constraints Must stay in Google ecosystem (Google Sheets + AppSheet). No custom servers. I will provide Google Sheet (current data). Google account access to Sheet + AppSheet. Test engineer emails. Budget type / Currency / Budget Fixed Price / £ GBP / £363 (Stretch items under Nice-to-haves can be separate add-ons.) Advanced options (suggested text) Location: Prefer UK/EU timezone, open to others with strong AppSheet portfolio. Visibility: Public. Duration: Target delivery 7–10 calendar days from kickoff. Experience required: Proven AppSheet apps with map views, actions, security filters, and basic inventory/ledger patterns. Interview questions (paste these) Share an AppSheet project you built with a map view and write-back actions. What were the tricky parts? How will you guarantee CompletedAt/CompletedBy are always stamped (including offline and repeated edits)? Outline your Security Filter approach so engineers only see their rows (why filters vs slices). Propose the inventory data model you’ll implement (Parts, EngineerStock, StockLedger) and how you’ll keep QtyOnHand consistent. How will you keep the app fast with ~1,000+ locations (geocoding strategy, LatLong, slices)? Given messy Yes/No/phone/email values, how will you normalize quickly without losing data? Would you keep a single Jobs table or split Sites/Jobs? Defend your choice for this case. What handover (video/doc) do you provide so we can add parts, users, and columns later?
Project ID:
3448837
Project category:

Project budget:

View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
Python Developer Needed to Build a Windows GUI for an Existing AI Command-Line Tool !! Category: Desktop Application, Python, Software Development, Software Engineering Budget: $20 - $30 USD	18 Sep 2025 04:04 GMT
Vapi.ai Voice Agent Workflow Category: AI Agents, AI Chatbot Development, AI Content Creation, AI Design, AI Development, AI Text To Speech, AI Writing, Conversational AI, Voice Assistance Devices, Voice Over Budget: $250 - $750 CAD	18 Sep 2025 04:02 GMT
AWS Migration by Experienced DevOps Engineer Category: Amazon Web Services, CI / CD, Cloud Computing, Kubernetes, Linux, System Admin, Terraform, Troubleshooting Budget: ₹37500 - ₹75000 INR	18 Sep 2025 04:02 GMT
Sock Puppet Identification for Legal Action Category: Data Analysis, Digital Forensics, Legal, Research Writing, Social Media Management Budget: $250 - $750 USD	18 Sep 2025 04:01 GMT
Inspirational Congress Promo Video Category: After Effects, Animation, Video Ads, Video Conferencing, Video Editing, Video Post Editing, Video Production, Video Services, Video Streaming Budget: $250 - $750 USD	18 Sep 2025 04:01 GMT
Elegant Minimalist Coffee Logo Category: Graphic Design, Illustration, Logo Design, Vector Design Budget: $15 - $25 USD	18 Sep 2025 03:59 GMT
Transcribe 5-Hour YouTube Videos Category: Content Creation, English Spelling, Proofreading, Transcription Budget: $10 - $30 USD	18 Sep 2025 03:55 GMT
Digital Product Catalog Design Category: Adobe InDesign, Branding, Brochure Design, Content Creation, Graphic Design, PDF, Typography, Visual Design Budget: $2 - $8 USD	18 Sep 2025 03:54 GMT
D2C website wordpress Category: Branding, Content Marketing, Digital Marketing, Email Marketing, Figma, SEO, Visual Design, Web Design, Web Development, WordPress Budget: ₹1500 - ₹12500 INR	18 Sep 2025 03:53 GMT
Shopify MVP Store Build – Blackstone Grills Category: CSS, ECommerce, Graphic Design, HTML, Shopify, Shopify Development, Web Development, Web Design Budget: $250 - $750 AUD	18 Sep 2025 03:53 GMT
Controlador de forno infravermelho Category: Arduino, Process Automation Budget: $2 - $8 USD	18 Sep 2025 03:52 GMT
Python SNN with Homomorphic Encryption Category: Artificial Intelligence, CUDA, Data Science, Deep Learning, Machine Learning (ML), Neural Networks, Python, Software Architecture Budget: ₹12500 - ₹37500 INR	18 Sep 2025 03:50 GMT
Bodybuilding Photo Editing -- 2 Category: Adobe Lightroom, Photoshop, Image Analysis, Image Processing, Photo Editing, Photo Retouching Budget: $30 - $250 USD	18 Sep 2025 03:50 GMT
Holistic SEO & Social Boost Category: Content Strategy, Facebook Marketing, Google Analytics, Instagram Marketing, Internet Marketing, Keyword Research, SEO, Social Media Marketing, Website Optimization Budget: ₹600 - ₹1500 INR	18 Sep 2025 03:48 GMT
Build SCORM-Compliant British Literature Course Category: AI Content Creation, Article Writing, Articulate Storyline, Content Development, ELearning, Instructional Design, Research Writing, SCORM, Training Development, Video Editing Budget: $250 - $750 USD	18 Sep 2025 03:45 GMT

Browse All Projects

New!
Проекты на русском (Projects in Russian)