Closed

Google Docs spreadsheet

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 XERO accounting system (OPTIONAL) joined using Google Apps Script service. Including use of NFC technology located on the assets to aid in workflow automation.

Stage 1 Desired Outcomes:

Allow for on-site technicians to easily record photos against the relevant asset using an Android smartphone.

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. Privacy option? Can client X see client Y assets?

Overview:

An asset is produced by an authorised user in the Xero accounting system. Xero accounting system produces a unique ID per asset. Xero 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 in Xero

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 - [url removed, login to view]

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

Xero API - [url removed, login to view]

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

http://www.nxp.com/campaigns/nfc//

Skills: .NET, C Programming, PHP, Software Architecture, Visual Basic

See more: asset register google docs, www xero accounting, www docs google com, www apps programming com, writer access com, what is record in data structure, what is nfc android, what is data structure in programming, what is an apps script, using google spreadsheet, using google apps, use script in google spreadsheet, use of data structure in programming, technology in accounting, spreadsheet services, spreadsheet script google, spreadsheet script, spreadsheet accounting, service spreadsheet, script sheets, script google spreadsheet, register as an app developer, private writer service, php programming android, photo store script

About the Employer:
( 3 reviews ) Dhaka, Bangladesh

Project ID: #4484568

7 freelancers are bidding on average $37/hour for this job

thecloudkernel

Thank you for considering TheCloudKernel services. We are Israel based premier specialist IT solutions and services company. Over the past 6 years we have assisted thousands of clients worldwide in solving problems r More

$39 USD / hour
(18 Reviews)
7.2
omtechnologies

Hi, We can provide PHP / Mysql/JQuery/Ajax/Javascirpt/HTML/CSS expert for your project. Please check PMB with details.

$36 USD / hour
(191 Reviews)
7.8
AnisInfoTech

Hello, We love to work on this advance project. We have total 14 years of development experience and that help us to headstart in anything with minimum time. Your project is very interesting and our team is alway More

$26 USD / hour
(61 Reviews)
7.4
ValueCoders

Hi, Experts team of SEO/Wordpress/PHP/cakephp/joomla/Drupal/Magento/AJAX/Codeigniter developers and designers. Thanks Gaurav

$43 USD / hour
(136 Reviews)
7.3
hrarcon

Ready to work on your project

$39 USD / hour
(15 Reviews)
5.9
krishcompusoft07

12 year expert team....

$25 USD / hour
(3 Reviews)
2.7
on2itjo

Hi, We at on2itonline would love to work with you on this, we do MAD "full service" websites on a clear and fixed budget. We have lots to offer that others don't ,like our lifetime FREE hosting on every website for a More

$51 USD / hour
(0 Reviews)
0.0