1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 18-Feb-2026 14:15 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
WordPress Website Rebuild with Elementor
Category: Content Management System (CMS), Elementor, HTML, PHP, SEO Writing, Web Development, Web Design, Website Optimization, WordPress
Budget: £250 - £750 GBP
18-Feb-2026
11:03 GMT
Resume / CV / Portfolio Design Project
Category: Adobe Creative Cloud, Adobe Creative Suite, Adobe Illustrator, Brochure Design, CV Design, Graphic Design, Logo Design, Portfolio Management, Resumes, Visual Design
Budget: $30 - $250 AUD
18-Feb-2026
11:00 GMT
Full Stack Developer - Angular & Spring Boot
Category: Angular, AngularJS, API Development, Azure, Full Stack Development, Java, Node.js, NoSQL Couch & Mongo, REST API, Spring Boot
Budget: ₹24
18-Feb-2026
11:00 GMT
Music Reviewer | Creative Content Writer
Category: Article Writing, Blog Writing, Content Writing, Copywriting, Creative Writing, Journalism, Music, Proofreading, Research, SEO Writing
Budget: $10 - $30 USD
18-Feb-2026
10:59 GMT
Configuración Odoo Ventas Mayorista
Category: Accounting, B2B Marketing, ERP, Inventory Management, Odoo, Python, Sales Management, Software Architecture
Budget: €250 - €750 EUR
18-Feb-2026
10:59 GMT
Freelance Recruiter for Delhi-Based Company for Full time candidate
Category: Customer Service, Customer Support, Human Resources, Interviewing, LinkedIn Recruiting, Recruitment, Sourcing, Talent Acquisition, Telephone Handling, Virtual Assistant
Budget: ₹600 - ₹1500 INR
18-Feb-2026
10:59 GMT
Cloud Kitchen Consultancy for Delhi NCR
Category: Branding, Compliance, Consulting, Financial Planning, Logistics, Marketing Strategy, Menu Design, Operations Management
Budget: ₹12500 - ₹37500 INR
18-Feb-2026
10:53 GMT
WordPress Reference Page Clone and getting it score A for mobile and desktop on Google page speed (fully responsive for all devices)
Category: CSS, Elementor, Google PageSpeed Insights, HTML, JavaScript, PHP, Web Design, Web Development, Website Optimization, WordPress
Budget: ₹600 - ₹1500 INR
18-Feb-2026
10:53 GMT
Course Website Design & Build
Category: Content Management System (CMS), Graphic Design, HTML, PHP, UI / User Interface, Web Design, Web Development
Budget: $15 - $25 USD
18-Feb-2026
10:50 GMT
PDF to Excel Conversion Project
Category: Data Cleansing, Data Entry, Data Extraction, Data Management, Data Processing, Excel, PDF
Budget: $20000 - $50000 USD
18-Feb-2026
10:48 GMT
Conversational Explainer Reels Editing
Category: Adobe Premiere Pro, After Effects, Animation, DaVinci Resolve, Motion Graphics, Video Editing, Video Post Editing, Video Production
Budget: ₹100 - ₹400 INR
18-Feb-2026
10:48 GMT
Multi Platform Social Media Management
Category: Advertising, Content Writing, Facebook Marketing, Google Adwords, Graphic Design, Internet Marketing, Social Media Management, Social Media Marketing
Budget: $30 - $250 USD
18-Feb-2026
10:46 GMT
game developer needed
Category: C#, Programming, C++, Game Consoles, Game Design, Game Development, Game Testing, Game UI, Performance Tuning, Unity, Unreal Engine
Budget: $750 - $1500 USD
18-Feb-2026
10:45 GMT
Elegant Sticker Design for AC Fridge
Category: Adobe Illustrator, Photoshop, Corporate Identity, Covers & Packaging, Creative Design, Graphic Design, Logo Design, Sticker Design
Budget: ₹12500 - ₹37500 INR
18-Feb-2026
10:44 GMT
Handwritten Egyptian Arabic Transcription
Category: Arabic Translator, Copy Typing, Data Entry, Microsoft Word, Proofreading, Transcription, Typing, Word
Budget: $10 - $30 USD
18-Feb-2026
10:44 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
Copyright © 2005-2025 1001 Freelance Projects