
I am looking for Javascript expert to sync Google Calendar to Drive Spreadsheet
- or -
Post a project like this4065
$$
- Posted:
- Proposals: 3
- Remote
- #613167
- Awarded
Description
Experience Level: Intermediate
Hi,
I am trying to create a workflow throughout Google Calendar and Drive Spreadsheet, where I can sync and control my invoices.
So far, I manage to create a script that import my Google Calendar entries, I also found some other information that may help with some functions.
Please find attached my link to Drive Spreadsheet, where you can find more details about my ideas.
Link 1 - I managed to add a script that sync Google Calendar to Spreadsheet, but there is problem, which is it re-write new entries everytime I run the script, instead add new row above on the top. I believe that the problem is on the line- var row=i+
https://docs.google.com/spreadsheets/d/1N1gAjIEqCfuthEspD-08mXYAxp5RXGJFzaMAJsINTLw/edit?usp=sharing
Link 2 - Is the same spreadsheet but without the script.
https://docs.google.com/spreadsheets/d/1qZawkd2PIYvJ7JJHbQxVgZ6KiKHZfVMhfDMY13ESpv8/edit?usp=sharing
You will notice in the spreadsheet that I would like to create a trigger function to copy the information from a specific Row into an Invoice Template Sheet, by the way it does not necessarily needs to be a sheet it could a Doc page too.
Here I some information that I found regarding this function:
http://www.mrexcel.com/forum/excel-questions/602635-automatically-move-entire-rows-one-worksheet-into-another-worksheet-same-workbook.html
https://productforums.google.com/forum/#!topic/docs/ehoCZjFPBao
And the last thing is, I would like to write some status in the status column and the sync it with Google Calendar Event Title for example:
Event tittle " Maria Job"
Event title with the status information write on Status column: "Maria Job -PAID"
Have a look and let me know what you think, is it possible and how long and how much would you charge.
Please feel free to contact me here:
Best regards,
Eduardo
I am trying to create a workflow throughout Google Calendar and Drive Spreadsheet, where I can sync and control my invoices.
So far, I manage to create a script that import my Google Calendar entries, I also found some other information that may help with some functions.
Please find attached my link to Drive Spreadsheet, where you can find more details about my ideas.
Link 1 - I managed to add a script that sync Google Calendar to Spreadsheet, but there is problem, which is it re-write new entries everytime I run the script, instead add new row above on the top. I believe that the problem is on the line- var row=i+
https://docs.google.com/spreadsheets/d/1N1gAjIEqCfuthEspD-08mXYAxp5RXGJFzaMAJsINTLw/edit?usp=sharing
Link 2 - Is the same spreadsheet but without the script.
https://docs.google.com/spreadsheets/d/1qZawkd2PIYvJ7JJHbQxVgZ6KiKHZfVMhfDMY13ESpv8/edit?usp=sharing
You will notice in the spreadsheet that I would like to create a trigger function to copy the information from a specific Row into an Invoice Template Sheet, by the way it does not necessarily needs to be a sheet it could a Doc page too.
Here I some information that I found regarding this function:
http://www.mrexcel.com/forum/excel-questions/602635-automatically-move-entire-rows-one-worksheet-into-another-worksheet-same-workbook.html
https://productforums.google.com/forum/#!topic/docs/ehoCZjFPBao
And the last thing is, I would like to write some status in the status column and the sync it with Google Calendar Event Title for example:
Event tittle " Maria Job"
Event title with the status information write on Status column: "Maria Job -PAID"
Have a look and let me know what you think, is it possible and how long and how much would you charge.
Please feel free to contact me here:
Best regards,
Eduardo
Eduardo D.
90% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
0%
Last project
19 Mar 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies