Google Docs spreadsheet + Web UI

Project Description: Spreadsheet + Google Maps UI Concept: 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? Overview: 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 References: Google Apps Script - [login to view URL] Google Maps API - [login to view URL] Xero API - [login to view URL] = WorkflowMax integration NFC Tag writer App & Information - [login to view URL]?t=W251bGwsMSwxLDEwMiwiY29tLm54cC50YWdpbmZvbGl0ZSJd http://www.nxp.com/campaigns/nfc// 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'. MORE DETAILS AVAILABLE ON REQUEST