Google App Script - Test Project

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



Property details:

property no





Tenant details:

first name

last name

mobile no


home no

work phones



Landlord details:

first name

last name

mobile no


home no

work phones



[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]

Beceriler: Google App Motoru, Javascript, Yazılım Mimarisi, Yazılım Test Etme

Daha fazlasını görün: work at home google, web form to google spreadsheet, web apps google, using google spreadsheet, using google apps, use script in google spreadsheet, spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, speed date script, script google spreadsheet, notes in google apps, mobile system architecture, google web apps, google system architecture, google spreadsheet web app, google. docs, google apps web, google apps spreadsheets, google apps spreadsheet, google apps script spreadsheet, google apps script document, google apps notes, google apps javascript

İşveren Hakkında:
( 22 değerlendirme ) nottingham, United Kingdom

Proje NO: #4439753



Hi, can help.

2 gün içinde 82$ USD
(4 Değerlendirme)

4 freelancers are bidding on average $99 for this job


Hi, its my sample web site [url removed, login to view] user name admin at [url removed, login to view] password 123 i can customsize it for you.

in 3 gün içinde110$ USD
(3 Değerlendirme)

Hi! Please see your inbox.

in 3 gün içinde99$ USD
(2 Değerlendirme)

Hi , We understand your requirement and had experience of developing different API's. We will create a web based tool , which would be cost efficient and we can built the tool with the features you req Daha fazlası

in 10 gün içinde105$ USD
(0 Değerlendirme)