1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 29-Apr-2026 11:17 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
Multi-Platform Social Media Creatives
Category: Adobe Illustrator, Photoshop, Animation, Banner Design, Content Creation, Graphic Design, Logo Design, Social Media Marketing, Visual Arts
Budget: ₹1500 - ₹12500 INR
29-Apr-2026
10:04 GMT
Lifestyle Photo Shoot
Category: 3D Modelling, Adobe Lightroom, Photoshop, Branding, Photo Editing, Photography, Product Photography
Budget: $250 - $750 USD
29-Apr-2026
10:04 GMT
Complete TPT Payment Securely
Category: Payment Gateway Integration, Payment Processing, PayPal
Budget: $10 - $20 USD
29-Apr-2026
10:03 GMT
Golden Lovebirds 3D Model
Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Illustration, 3D Layout, 3D Modelling, 3D Rendering, 3D Visualization, Maya
Budget: ₹600 - ₹1500 INR
29-Apr-2026
10:02 GMT
Excel Cross-File Data Linking
Category: Data Analysis, Data Entry, Data Integration, Data Management, Data Processing, Data Visualization, Excel, Excel Macros, Excel VBA, Visual Basic
Budget: €8 - €30 EUR
29-Apr-2026
10:02 GMT
Organisation Conférence Technologie en Ligne
Category: 3D Animation, 3D Modelling, Animation, Article Writing, Content Development, Event Management, Visual Design, Zoom
Budget: $2 - $8 USD
29-Apr-2026
10:00 GMT
YouTube Automation Sales Closer
Category: Conversion Rate Optimization, CRM, Digital Marketing, Email Marketing, Internet Marketing, Lead Generation, Sales, Sales Management, Social Media Marketing, Telemarketing
Budget: $250 - $750 USD
29-Apr-2026
10:00 GMT
Professionalize AI-Generated Logo
Category: Adobe Illustrator, AI Graphic Design, Graphic Design, Illustration, Inkscape, Logo Design, Photoshop, Vector Design
Budget: €30 - €250 EUR
29-Apr-2026
09:59 GMT
Complete Revamp of Ladyhouse.store
Category: Graphic Design, HTML, PHP, SEO, UI / User Interface, UX / User Experience, Web Development, Web Design
Budget: ₹75000 - ₹150000 INR
29-Apr-2026
09:59 GMT
Website Audit & Redesign Fixes
Category: Conversion Rate Optimization, PHP, SEO, Shopify, Web Design, Web Development, Website Audit, WordPress
Budget: ₹37500 - ₹75000 INR
29-Apr-2026
09:58 GMT
Nigerian Imitation Jewelry Sales
Category: Business Development, Customer Service, Field Sales, Link Building, Sales, Sales Management
Budget: ₹600 - ₹1500 INR
29-Apr-2026
09:57 GMT
eCommerce Redesign & Optimization
Category: ECommerce, Graphic Design, HTML, PHP, SEO, Web Design, Web Development
Budget: ₹75000 - ₹150000 INR
29-Apr-2026
09:57 GMT
Garment Export Lead Generation
Category: B2B Marketing, Business Development, Data Entry, Email Marketing, Excel, Lead Generation, Leads, Market Research, Web Search
Budget: ₹12500 - ₹37500 INR
29-Apr-2026
09:57 GMT
Film Photography Dropshipping Store
Category: CSS, Dropshipping, EBay, ECommerce, HTML, Product Descriptions, Shopify, Web Design
Budget: £250 - £750 GBP
29-Apr-2026
09:57 GMT
Hotel Booking App Development
Category: Backend Development, Flutter, Graphic Design, Mobile App Development, Node.js, PHP, React Native, Web Design
Budget: ₹37500 - ₹75000 INR
29-Apr-2026
09:57 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