Google App Script - Test Project

IN PROGRESS
Bids
4
Avg Bid (USD)
$99
Project Budget (USD)
$30 - $100

Project Description:
Google Apps Script Real Estate Management - Proof of Concept

This work is to help me to test the effectiveness of Google Apps Script and to gauge whether it will be suitable to use to develop our custom CRM system. I need to see the speed at which the script will run as script on the spreadsheet and a deployed web application.

We currently have 4 spreadsheets setup like database tables within google docs. They can all be linked together via primary and foreign keys.

I need a large form written using google app script, that will just list all the fields in each joined record. No fancy formatting or arranging of the fields is necessary. The form will have 2 buttons to browse to the previous or next record. There will also be one action button that will create a document with an appropriate name and the same fields within the document.

The Spreadsheets:
Tenancies (id, property_id, landlord_id, start date, amount, arears)
Properties (id, landlord_id, property name, property no, address1,county, postcode, etc)
Tenants (id, first name, last name, mobile no, email, home no, work phones, notes, etc)
Landlords (id,first name, last name, mobile no, email, home no, work phones, notes, etc)


The form:
Tenancy details
start date
amount
arears

Property details:
property no
address1
county
postcode
etc

Tenant details:
first name
last name
mobile no
email
home no
work phones
notes
etc

Landlord details:
first name
last name
mobile no
email
home no
work phones
notes
etc


[Create Document Button]


The Document:
The document will show all the same details as the form (not print screen)
And will be named [property no][address1] - [tenant first name][tenant last name]

Skills required:
Google App Engine, Javascript, Software Architecture, Software Testing
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 82
in 2 days
$ 110
in 3 days
Hire GeorgeKazi
$ 99
in 3 days
$ 105
in 10 days