Google App Script - Test Project

Budget $30 - $100 USD
Bids 4
Average Bid $99

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]

Post a Project Like This

This project was awarded to

Viqtor

My project ended up being quite a bit more difficult than I think was imagined but he still made a good effort to get it done in a timely manner and even though it was done in a different way than I thought it would be, he has agreed to do another project with me to get the job done right! Thanks Viktor!
About the Freelancer
Viqtor Profile Picture

Results oriented IT engineer with experience of working on web based IT projects and services. Highly motivated and fascinated by new technologies I always deliver a high quality working product. About myself: I am fast, brilliant and cheap, but you can only have any two of them at a time. So if I am fast and brilliant, I am not cheap; if I am brilliant and cheap, I am not fast; and if I am fast and cheap, I am not brilliant.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • ppcminds Profile Picture

    ppcminds

    hyderabad,  India

    PPC Minds is Search Marketing Agency that focused on bringing in quality traffic to the website and ultimately bring ROI to the campaigns. To help clients implementing Advanced PPC Skills and SEO Skills that help reduce the Cost per lead, Cost per sale while driving relevant traffic to client sites. We track and optimize the traffic that we drive to sites with the tools we developed. We also can track the lead to deals and find the keywords that lead to deals rather than just leads. We implement our own tracking system. We also helped many sites rank organically in first page of Google, Yahoo and Bing..

    PHP, Javascript, .NET, and Internet Marketing

  • GeorgeKazi Profile Picture

    GeorgeKazi

    n/a,  Kenya

    I'm a highly motivated software devloper. Send me your problems and we'll work through them together.

    PHP, Perl, C Programming, and Java

  • Viqtor Profile Picture

    Viqtor

    Kharkiv,  Ukraine

    Results oriented IT engineer with experience of working on web based IT projects and services. Highly motivated and fascinated by new technologies I always deliver a high quality working product. About myself: I am fast, brilliant and cheap, but you can only have any two of them at a time. So if I am fast and brilliant, I am not cheap; if I am brilliant and cheap, I am not fast; and if I am fast and cheap, I am not brilliant.

    Javascript, Data Processing, Excel, and Google Adwords

  • asifjans Profile Picture

    asifjans

    Lahore,  Pakistan

    Web, Web Development, Web Designing, Web Software

    ASP, .NET, Website Design, and Graphic Design