Google docs / calendar integration, Google Apps Script

CLOSED
Bids
4
Avg Bid (USD)
$126
Project Budget (USD)
$30 - $250

Project Description:
The task is to customise a Google Apps spreadsheet and automate several tasks using Google Apps Script. I am not familiar with GAS so I am not sure how much of this will be straightforward or complex to achieve. I know how to do it in VBA - but that's not what we're using here!

I currently have a spreadsheet used to manage property bookings. Information is to be entered using a Google Form, and output to a Google Apps spreadsheet.

I need to automate the following operations on the data.

1. Copy any new rows (created via the form) to another sheet, dependent on the value in the first field. (The value is which property the booking relates to, from a drop-down list; I need a sheet that shows all bookings, and individual sheets for each property). It should be possible to add new properties easily. Also copy ALL new rows to a different sheet.
2. Calculate a field "Length of stay" (ie subtract start date field from end date field)
3. Automatically resort each sheet by the date order of one of the fields (booking start date). If possible, on each sheet I would like a couple of blank rows in between each month of entries, and also automatically total a couple of the columns.
4. Conditionally format-highlight start / end dates & times in adjacent rows if they are the same. The idea is that if one booking ends on the same day as the next one begins, we should be able to see that easily.
5. Export the row as data to a Google Calendar entry. The start / end date and time will form the parameters of the calendar entry; the name and total fields will combine to form the title of the calendar entry


Link to the form:
https://docs.google.com/forms/d/1VnrzqGq-5BkpP8VvU9hUuexlr_IzdhGLDJqLmkI7nJ8/viewform

Link to the spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0Asf6vfGDtS5wdHZEN2xXWE12R3lVcXpySWxyYW1TWkE&usp=sharing

On the current spreadsheet, form responses are going to the Form Responses 1 tab; I need the information copied to the Main tab, and relevant information to the appropriate tab for the property.

Skills required:
Google App Engine, Google Web Toolkit
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.


$ 158
in 2 days
Hire WilianPortillo
$ 35
in 10 days
Hire ownedge
$ 155
in 6 days
Hire GeorgeKazi
$ 155
in 7 days