1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 13-Feb-2026 00:08 GMT
View Project
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)
Last Projects / Browse Projects
  Project Started
QA Tester Needed for Website & Mobile App
Category: Mobile App Testing, Software Testing, Test Automation, Testing / QA, Usability Testing, User Experience Research, User Interface / IA, Web Testing
Budget: $50 - $150 USD
12-Feb-2026
23:04 GMT
Nighttime Video Enhancement
Category: After Effects, Video Editing, Video Hardware, Video Post Editing, Video Processing, Video Production, Video Services, Video Streaming
Budget: $30 - $250 USD
12-Feb-2026
23:02 GMT
Cinematic Shorts Video Editor Needed
Category: Adobe Premiere Pro, AI Animation, Color Grading, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production
Budget: ₹100 - ₹400 INR
12-Feb-2026
23:02 GMT
LinkedIn Competitor Network Analysis
Category: API Development, Data Analysis, Data Visualization, Market Research, Python, Selenium, Software Architecture, Statistical Analysis, Statistics, Web Scraping
Budget: $10 - $30 USD
12-Feb-2026
22:58 GMT
Luxury Rental Marketing Campaign
Category: Digital Marketing, Facebook Ads, Google Ads, Google Analytics, Internet Marketing, Link Building, Marketing, PPC Marketing, SEO, Social Media Marketing
Budget: min $50 USD
12-Feb-2026
22:56 GMT
Create APK Photo Booth App
Category: Android, Android App Development, Android SDK, Android Studio, Java, Software Architecture
Budget: £1000 - £1500 GBP
12-Feb-2026
22:56 GMT
Data Entry Freelancer
Category: Data Entry, Data Management, Data Processing, Excel, Freelance, Google Sheets, Time Management, Typing, Web Search
Budget: $2 - $8 USD
12-Feb-2026
22:55 GMT
Garment Sewing Pattern Creation
Category: 2D Drafting, CAD / CAM, Fashion Design, Pattern Design, Pattern Making, Product Design, Sewing, Textile Design
Budget: ₹1500 - ₹12500 INR
12-Feb-2026
22:55 GMT
Retail DCF Cash-Flow Forecast
Category: Accounting, Data Analysis, Excel, Excel Macros, Finance, Financial Analysis, Financial Modeling, Financial Planning
Budget: ₹1500 - ₹12500 INR
12-Feb-2026
22:52 GMT
Jakarta Cultural Itinerary Design
Category: Event Management, Event Planning
Budget: $10 - $30 USD
12-Feb-2026
22:52 GMT
Classic Rock Backing Track
Category: Music, Music Production
Budget: £20 - £250 GBP
12-Feb-2026
22:52 GMT
Automation of Microsoft Tenant Setup
Category: API Integration, Automation, Automation Codeless Program, Cloud Computing, DevOps, Microsoft, Microsoft 365, Microsoft Azure, Microsoft Exchange, Scripting
Budget: min $50 USD
12-Feb-2026
22:52 GMT
Detailed Commercial Site Plan
Category: 2D Drafting, AutoCAD, CAD / CAM, Civil Engineering, Construction Management, Drafting
Budget: $250 - $750 USD
12-Feb-2026
22:51 GMT
Voiceflow File Translator
Category: API Development, Backend Development, CSS, Frontend Development, Full Stack Development, HTML, Translation, Web Development, Web Design
Budget: $30 - $250 USD
12-Feb-2026
22:50 GMT
Odoo 19 Accounting Setup
Category: Accounting, Business Management, CRM, Data Integration, ERP, Inventory Management, Odoo, Process Automation, Python, SAP
Budget: min $50 USD
12-Feb-2026
22:50 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)

Short URL:
1001fp.com
Mobile version:
m.1001freelanceprojects.com
Copyright © 2005-2025 1001 Freelance Projects