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

Latest Projects from Freelance Marketplaces

Today is: 19-Nov-2025 01:26 GMT

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
Update Tenant Information in Excel Spreadsheet Category: Data Entry, Data Processing, Excel Budget: $10 - $20 USD	19-Nov-2025 03:22 GMT
PrestaShop Optimization and Improvements Category: ECommerce, PHP, Prestashop, SEO, Web Design Budget: $375 - $750 USD	19-Nov-2025 02:15 GMT
Asustor NAS Setup Category: Home Automation, Linux, Network Administration, Network Security, PHP, Security, Software Architecture, Web Security Budget: $10 - $30 USD	18-Nov-2025 23:04 GMT
Indoor Pigeon Expo Banner Design Category: Adobe Illustrator, Photoshop, Banner Design, Graphic Design, Logo Design, Print Design, Visual Design Budget: £10 - £20 GBP	18-Nov-2025 23:04 GMT
Supreme Court Judicial Review Filing Category: Contracts, Legal, Legal Analysis, Legal Consultation, Legal Research, Legal Writing, Research Budget: $250 - $750 USD	18-Nov-2025 23:01 GMT
Weekly Bookkeeping & Statement Preparation Category: Accounting, Bookkeeping, Finance, Financial Analysis, Financial Planning, Financial Services Tax, Google Sheets, Intuit QuickBooks, Payroll, Tax Preparation Budget: $8 - $15 USD	18-Nov-2025 23:01 GMT
WordPress Checkout Payment Integration for reachweightloss.com Category: API Integration, HTML, Payment Gateway Integration, PayPal API, PCI Compliance, PHP, Web Development, Website Optimization, WooCommerce, WordPress Budget: min $50 USD	18-Nov-2025 23:01 GMT
Light-hearted Eulogy Actor Category: Acting, Creative Writing, Event Planning, Poetry, Public Speaking, Speech Writing, Voice Acting, Voice Over Budget: £20 - £250 GBP	18-Nov-2025 23:00 GMT
Mac App Store ASO Specialist Category: App Store Optimization, Conversion Rate Optimization, Data Analysis, Internet Marketing, Keyword Research, Search Engine Marketing (SEM), SEO, Testing / QA Budget: $25 - $50 USD	18-Nov-2025 23:00 GMT
Elegant Indoor Pigeon Banner Category: Adobe Illustrator, Photoshop, Banner Design, Graphic Design, Logo Design, Print Design, Typography Budget: £10 - £20 GBP	18-Nov-2025 22:59 GMT
Lead-Generating Social Media Management Category: Analytics, Content Creation, Facebook Marketing, Instagram Marketing, Internet Marketing, Social Media Management, Social Media Marketing, Twitter Budget: ₹1500 - ₹12500 INR	18-Nov-2025 22:58 GMT
French Conversation Tutor Needed Category: Conversational AI, French Tutoring, Language Tutoring Budget: €250 - €750 EUR	18-Nov-2025 22:56 GMT
Comprehensive SEO Audit & Backlink Cleanup Category: Analytics, Audit, Digital Marketing, Link Building, SEMrush, SEO, Website Optimization Budget: $250 - $750 USD	18-Nov-2025 22:56 GMT
Photoshop Editing -- 2 Category: Adobe Creative Cloud, Adobe Illustrator, Photoshop, Digital Art, Graphic Design, Image Processing, Photo Editing, Photoshop Design, Video Editing Budget: $15 - $25 USD	18-Nov-2025 22:56 GMT
Playful Logo Animation, Two Sizes Category: 2D Animation, Adobe Animate, Animation, Graphic Design, Logo Animation, Logo Design, Motion Graphics Budget: ₹1500 - ₹12500 INR	18-Nov-2025 22:56 GMT

Browse All Projects

Projects by Skills ...
Projects for 'android' Projects for 'ajax' Projects for 'asp' Projects for 'aspnet' Projects for 'cms' Projects for 'cpp' Projects for 'csharp' Projects for 'css' Projects for 'delphi' Projects for 'design' Projects for 'drupal'	Projects for 'excel' Projects for 'facebook' Projects for 'flash' Projects for 'html' Projects for 'java' Projects for 'javascript' Projects for 'joomla' Projects for 'iphone' Projects for 'mysql' Projects for 'photoshop' Projects for 'php' Projects for 'python'	Projects for 'ruby' Projects for 'seo' Projects for 'sql' Projects for 'sysadm' Projects for 'translate' Projects for 'typing' Projects for 'twitter' Projects for 'vbnet' Projects for 'xml' Projects for 'wordpress' Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android' RSS feed for 'ajax' RSS feed for 'asp' RSS feed for 'aspnet' RSS feed for 'cms' RSS feed for 'cpp' RSS feed for 'csharp' RSS feed for 'css' RSS feed for 'delphi' RSS feed for 'design' RSS feed for 'drupal'	RSS feed for 'excel' RSS feed for 'facebook' RSS feed for 'flash' RSS feed for 'html' RSS feed for 'java' RSS feed for 'javascript' RSS feed for 'joomla' RSS feed for 'iphone' RSS feed for 'mysql' RSS feed for 'photoshop' RSS feed for 'php' RSS feed for 'python'	RSS feed for 'ruby' RSS feed for 'seo' RSS feed for 'sql' RSS feed for 'sysadm' RSS feed for 'translate' RSS feed for 'typing' RSS feed for 'twitter' RSS feed for 'vbnet' RSS feed for 'xml' RSS feed for 'wordpress' RSS feed for 'writing'

New!
Проекты на русском (Projects in Russian)	Long URL: www.1001freelanceprojects.com	Mobile version: m.1001fp.com