Google Docs spreadsheet + Web UI

Project Description: Spreadsheet + Google Maps UI


A central location to store photos, notes and history of advertising assets. Using standard Google Apps services including Google Drive and Google Sheets integrated with the WorkflowMax job management system. Joined using Google Apps Script service. Including use of NFC technology located on the assets to aid in workflow automation re: maintenance updates.

Stage 1 Desired Outcomes:

Allow for on-site technicians to easily record photos against the relevant asset using an Android smartphone via an Android app or web solution.

Ability to easily share asset photo and note records with external users to the organisation.

Stage 2 Desired Outcomes:

Populate private Google Maps instance with data from Asset spreadsheet and Asset photos for sharing to end users via heatmap and individual pins. Privacy option? Can client X see client Y assets?


An asset is produced by an authorised user in the WorkflowMax system or Google spreadsheet producing a unique ID per asset. WorkflowMax API used to access information about asset and trigger events in Google Sheets via Google Apps Script.

Google Apps Script checks Xero assets on a timed basis looking for new unique asset ID. If new ID found produces new line in the Asset Register Spreadsheet hosted in Google Drive. For example:

Asset A001 is created WorkflowMax system/Google Doc

Script creates new line for Asset A001 in register

Asset Register Spreadsheet in Google Drive to record information such as Asset ID, last photo recorded date, number of asset photos, condition notes, client installation date, location, etc.

Google Apps Script used to check if new asset has been created in spreadsheet and generate a new Google Drive folder with the Asset ID, name of asset and location i.e.

Asset A001 in register triggers script event for folder creation

Folder created under parent directory with name Asset A001- Name - Location

On-site users take photo of asset and use inbuilt Android application to post the photo to Google Drive. Android application allows users to select what folder they want to post to and pre-highlights the title of the image to be uploaded.

NFC concept to allow user to tap phone against asset and record Asset ID - Name - Location - Timestamp

On-site user saves photo to capture folder for script processing

Google Apps Script to monitor capture folder and look for Asset ID. Asset ID used to trigger script to move photo to relevant Asset Folder for storage. Records date of last photo and number of photos to Asset Spreadsheet.

Using Google Drive share functionality provide read access to external users to the organisation

Example Folder Structure:

FOLDER - Asset Register (parent Directory)

Spreadsheet - Asset Register Spreadsheet

FOLDER - Asset Photo Storage

FOLDER - A001 - Name - Location

FOLDER - A002 - Name - Location

FOLDER - A003 - Name - Location

Image - A003 - Name - Location - Timestamp1

Image - A003 - Name - Location - Timestamp2

Image - A003 - Name - Location - Timestamp3

Image - A003 - Name - Location - Timestamp4

Document - A003 - Condition Notes


Google Apps Script - [url removed, login to view]

Google Maps API - [url removed, login to view]

Xero API - [url removed, login to view] = WorkflowMax integration

NFC Tag writer App & Information - [url removed, login to view]?t=W251bGwsMSwxLDEwMiwiY29tLm54cC50YWdpbmZvbGl0ZSJd

Hours of work: UnspecifiedProject Duration: 1 - 4 weeksSkills required:

Particulars Summary

We can break this 'spreadsheet' project into 3 stages:

> 1) the app - (we will supply a sample form for this)

> 2) the Doc spreadsheet (WorkflowMax integration - if possible) &

> 3) the UI showing the Google map - now updated to include 'Hotspots'.


Skills: Android, Cartography & Maps, Google App Engine

See more: google docs spreadsheet, google web, google docs spreadsheet api, www web developers com, www web developers, www google com web developer, www docs google com, www doc google com, writer access com, what to look for in a web developer, what is system ui, what is record in data structure, what is nfc android, what is an apps script, web writer job description, web service for developers, web photo management, web form to google spreadsheet, web developers job description, web developers job, web developers directory, web developers and app developers required required, web developer overview, web developer on line, web developer job application

About the Employer:
( 0 reviews ) Australia

Project ID: #4521894

12 freelancers are bidding on average $1487 for this job


Hello. For your concern we've developed 200+ Apps for Android, iOS, BlackBerry and Windows Phone so far. Please check your PMB to get some of our recently developed Apps. Thanks.

$2526 USD in 30 days
(34 Reviews)

We are an expert in building Mobile Applications. please check your PMB. Thanks

$1855 USD in 20 days
(9 Reviews)

Expertise in Mobile Application Development. I can start the Project immediately. Please check PM. Waiting for your reply..

$979 USD in 18 days
(3 Reviews)

Hi. Please check your PM.

$1546 USD in 10 days
(9 Reviews)

Hello Respected Client, I have Read your requirements and we are very experience in this concept. Please check Message Board for more details. Thank you !

$1030 USD in 20 days
(3 Reviews)

Hi, Please check private message. Thanks

$1546 USD in 25 days
(5 Reviews)

It's an easy task for [url removed, login to view] have gone through your requirements and we are ready to start the work immediately on your project. We will send you the complete list of company's projects and portfolio once you reply us b More

$1444 USD in 30 days
(2 Reviews)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and t More

$1340 USD in 25 days
(4 Reviews)

Hi i am interested to develop this for [url removed, login to view] see your [url removed, login to view] Rashid Saleem

$1159 USD in 25 days
(3 Reviews)

Respected Client, Please check PMB for listing and confident to complete the project with quality services.. Best Regards

$1237 USD in 15 days
(2 Reviews)

Hi, I've read your job description and I'm very much interested in the [url removed, login to view] can make the work perfect for [url removed, login to view] look at PMB for more details. Regards! Amar

$1444 USD in 25 days
(0 Reviews)

Hello, I am Nirav Joshi, an experienced project manager and web developer writing to you on behalf of my company Eagle Eye Technologies. I have read carefully the project description and fully understand th More

$1546 USD in 20 days
(0 Reviews)

It's an easy task for [url removed, login to view] have gone through your requirements and we are ready to start the work immediately on your project. Please see the attached list of company's projects. Also please check the PMB.Thanks.

$1333 USD in 30 days
(0 Reviews)

Hi, We take pleasure to introduce ourselves as a team of experienced professionals in the fields of Mobile Application Development and Design. Currently, our expertise includes Android, Blackberry & iPhone plat More

$1384 USD in 14 days
(0 Reviews)

Hi We are interested in your project and read your [url removed, login to view] have completed 150+ big projects in last 5 years. Please check private message board for details.

$1546 USD in 10 days
(0 Reviews)