Hi, I am looking for a developer to assist with amending existing javascript type code (a small section of code written to work with Google Docs) to add a few new functionalities. Can you assist? Thanks. I have added the code snippet, the base spreadsheet and the reminder spreadsheet and want the following functionality:
The base spreadsheet is accesible by myself and a professional who I work with. The reminder spreadsheet is linked by 'import' function to the Base Spreadsheet. The professional uses the spreadsheet to manage their clients such as adding any interactions with the client and setting a date for the next likely progress with the client's case.
I basically want to be able to send the professional a reminder by email, that the date that s/he has set in the base spreadsheet for making the next update has expired (the professional will not be looking at the spreadsheet every day, so a reminder is useful). The reminder email needs to be sent every day until the professional updates the relevant client record in the base spreadsheet.
There are some problems with this software that doesn't suit my particular needs, hence I need assistance with it:
Problems to be Fixed
1) When the professional updates the date of the next update in their base spreadsheet while the reminder spreadsheet updates the date in the relevant cell (Column E), it fails to adjust the next scheduled email (Column M) to coincide with the new date entered by the professional. It just continues to send an email every day once started.
2) Also, when new rows are added or removed in the base spreadsheet this causes problems with the Reminder Spreadsheet which is not updated to reflect the Base Spreadsheet accurately. It must be possible to delete rows and add them as the rows are added and deleted in the base spreadsheet.
3) There seems to be a limit in the reminder spreadsheet - can this limit be removed.
Functionality to be added
1) I would like to be able to have the reminder emails sent at variable times between 09.00 and 13.00 Central European Time (for example stagger the emails by 10 minutes each row where the date of the update is todays date or earlier)
2) If possible to include a hyperlink in the email to the relevant Google doc
Please let me know if this can be achieved and send a quotation please. Thanks.
The language of code is java script. I am an expert of this and have helped many small companies automate their task. I will finish the task ASAP, but 7 days is the maximum time i will need.
hi,
I´m google apps developer, your task looks ok for my experiences and skills. If you would like, you could send me more details or your base spreadsheet.
regards,
Filip