1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 08-Oct-2025 09:37 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
Data Entry and Retyping Jobs
Category: Copy Typing, Data Entry, Data Processing, Excel, PDF
Budget: $1500 - $3000 USD
08-Oct-2025
05:55 GMT
Outbound calls stopped working on FusionPBX
Category: Asterisk PBX, FreeSwitch, SIP, VoIP
Budget: $10 - $30 USD
08-Oct-2025
04:04 GMT
Organic Social Media Traffic (No agency)
Category: Article Writing, Content Creation, Content Strategy, Facebook Marketing, Instagram Marketing, Internet Marketing, Pinterest, Social Media Management, Social Media Marketing, Twitter
Budget: $30 - $250 USD
08-Oct-2025
04:04 GMT
HubSpot Real-Estate Lead Automation
Category: API Integration, Automation, Hubspot, JSON, Node.js, PHP, Python, REST API, Software Development, Web Services
Budget: $30 - $250 AUD
08-Oct-2025
04:01 GMT
Daily Stock Trading Specialist
Category: Accounting, Business Analysis, Finance, Financial Analysis, Financial Markets, Investment Management, Market Analysis, Market Research, Metatrader, PHP
Budget: ₹12500 - ₹37500 INR
08-Oct-2025
04:00 GMT
Nutritionniste pour Programme Perte de Poids
Category: Diet, Health, Nutrition
Budget: $10 - $30 USD
08-Oct-2025
03:58 GMT
Setup Outlook 2016 on New PCs
Category: Microsoft Office, Microsoft Outlook, Technical Support
Budget: $15 - $25 AUD
08-Oct-2025
03:58 GMT
Matrimony web & app development
Category: Android App Development, API Development, Flutter, Mobile App Development, Node.js, React Native, React.js, Web Development, Web Design
Budget: $750 - $1500 USD
08-Oct-2025
03:57 GMT
Unity Action-Adventure Game Buil
Category: Game Art, Game Design, Game Development, Game Testing, IPhone, Mobile App Development, Unity, Unity 3D
Budget: $2 - $8 USD
08-Oct-2025
03:56 GMT
Students fake vs real grievance classifier
Category: Classification, Data Analysis, Data Mining, Data Modeling, Data Processing, Data Science, Deep Learning, Machine Learning (ML)
Budget: ₹600 - ₹1500 INR
08-Oct-2025
03:56 GMT
Drone-Based Environmental Impact Categorization
Category: ArcGIS, Data Processing, Data Visualization, Drone Photography, Environmental Engineering, Project Management, Remote Sensing, Risk Assessment
Budget: min $50 USD
08-Oct-2025
03:55 GMT
LA County Title Deed Research
Category: Copy Typing, Data Collection, Data Entry, Data Management, Excel, Legal Research, Property Law, Property Management, Research, Web Search
Budget: $30 - $250 USD
08-Oct-2025
03:55 GMT
NSFW Image QA (Deleting images that look too AI) + some light editing.
Category: AI Image Editing, Image Analysis, Image Processing, Image Recognition, Photoshop
Budget: $30 - $250 USD
08-Oct-2025
03:54 GMT
Meta Business Manager Setup
Category: Advertising, Facebook Marketing, Graphic Design, HTML, Instagram Marketing, PHP, Social Media Management, Web Design
Budget: ₹600 - ₹1500 INR
08-Oct-2025
03:53 GMT
WordPress SiteGround Setup for Tranquil Waves
Category: Digital Marketing, Email Marketing, HTML, PHP, SEO, UX / User Experience, Web Design, Web Development, WooCommerce, WordPress
Budget: $250 - $750 AUD
08-Oct-2025
03:51 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-2024 1001 Freelance Projects