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
Turbojet Engine SolidWorks Model Category: 3D CAD, 3D Design, 3D Modelling, 3D Rendering, Manufacturing Design, Mechanical Engineering, Product Design, Solidworks Budget: ₹1500 - ₹12500 INR	20 Nov 2025 23:02 GMT
Android App with Google Sheets Sync Category: Android, API Integration, App Development, Database Management, Excel, Java, Kotlin, Mobile App Development Budget: ₹1500 - ₹12500 INR	20 Nov 2025 23:01 GMT
Brand Design Category: Branding, Graphic Design, Logo Design, Social Media Marketing Budget: £20 - £250 GBP	20 Nov 2025 23:00 GMT
VA for DM Activities Category: Instagram, Virtual Assistant Budget: $2 - $8 USD	20 Nov 2025 23:00 GMT
Graphics design for digital marketing Category: Banner Design, Graphic Design, Illustration, Logo Design, Photoshop, Video Editing Budget: €2 - €6 EUR	20 Nov 2025 22:59 GMT
Diseño de presentación con metáforas visuales. Sólo que hable español. Category: Brochure Design, Corporate Identity, Creative Design, Google Slides, Graphic Design, Keynote, Powerpoint, Visual Arts Budget: $8 - $15 USD	20 Nov 2025 22:57 GMT
Tech Job Application Assistant - manually apply to job postings WITH PRECISION ! Category: Data Entry, Editing, Google Sheets, Linkedin, LinkedIn Profile, Resumes, Software Development, Software Engineering, Time Management, Word Budget: ₹600 - ₹1500 INR	20 Nov 2025 22:57 GMT
Native Thai Content Strategist Category: Content Audit, Content Creation, Content Development, Content Strategy, Content Writing, Copywriting Budget: $15 - $25 USD	20 Nov 2025 22:56 GMT
Ecommerce para tours de agencia Category: Content Management System (CMS), Payment Gateway Integration, Payment Processing, SEO, Shopify, Web Design, Web Development, WooCommerce Budget: $30 - $250 USD	20 Nov 2025 22:56 GMT
Django-Based SIP Web Phone Category: Backend Development, Django, Frontend Development, JavaScript, Python, SIP, Software Architecture, WebRTC Budget: ₹1500 - ₹12500 INR	20 Nov 2025 22:56 GMT
Urban Edgy Barbershop Logo Design Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Typography Budget: $30 - $250 USD	20 Nov 2025 22:53 GMT
Urgent WordPress Developer Needed -- 2 Category: Content Writing, CSS, HTML, JavaScript, PHP, Web Design, Web Development, WordPress Budget: $10 - $30 AUD	20 Nov 2025 22:53 GMT
Edición de video Category: Adobe Premiere Pro, After Effects, Animation, Camtasia, Final Cut Pro, Podcast Editing, Video Editing, Video Post Editing, Video Production, Video Services Budget: $30 - $250 USD	20 Nov 2025 22:50 GMT
SEO Restoran Tingkatkan Visibilitas Category: Content Writing, Digital Marketing, Google Adwords, Google Analytics, Internet Marketing, Keyword Research, Link Building, SEO Budget: $15 - $25 USD	20 Nov 2025 22:48 GMT
Complete Website Design and Add E-Commerce Features Category: ECommerce, Graphic Design, HTML, PHP, Web Design Budget: $100 - $200 USD	20 Nov 2025 19:00 GMT

Browse All Projects

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