Google docs / calendar integration, Google Apps Script

Closed

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:

[url removed, login to view]

Link to the spreadsheet:

[url removed, login to view]

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

See more: google sheets calendar integration, google form integration google calendar, apps script copy google calendar spreadsheet, google spreadsheet link calendar, google calendar google spreadsheet integration, google script form spreadsheet docs calendar, google spreadsheet calendar script, web form to google spreadsheet, web apps google, web app google, using google spreadsheet, using google apps, spreadsheet script google, script sheets, script google spreadsheet, script for google forms, new spreadsheet app, google web apps, google spreadsheet web app, google docs vba, google. docs, google apps web forms, google apps web

Project ID: #4586506

4 freelancers are bidding on average $126 for this job

Viqtor

Hi, can help

$158 USD in 2 days
(6 Reviews)
4.5
WilianPortillo

I have experience in developing applications with Google Apps Script. My offer: "I can make the items 1, 2, 3 and 4. The Item 5 (Google Calendar) would have to investigate. So the low price, for 4/5 intems".

$35 USD in 10 days
(0 Reviews)
0.0
ownedge

We're able to do it for you, check PM

$155 USD in 6 days
(0 Reviews)
0.0
GeorgeKazi

See your inbox.

$155 USD in 7 days
(0 Reviews)
2.8