Help & Support
Send Feedback
Rose Task Manager
The Rose Task Manager add-on provides an ideal way to manage your own tasks and those of your team: * GForm for submitting task requests * Scheduling of regular or on-off tasks using the Google Calendar * Email notifications of new task listings or status updates * Customised email templates using GMail drafts * Supports customisation of GForm and task list GSheet * Automatically completes task start and end time in the task list on status updates
www.andrewroberts.net
No users
Works with
Install
Overview
The Rose Task Manager add-on provides an ideal way to manage your own tasks and those of your team.

 * GForm for submitting task requests
 * Scheduling of regular or on-off tasks using the Google Calendar
 * Email notifications of new task listings or status updates
 * Customised email templates using GMail drafts
 * Supports customisation of GForm and task list GSheet
 * Automatically completes task start and end time in the task list on status updates
 * Progress "Log" tab
 
<< Usage >>

< Submit a new task >

Open the task request form (Form > Go to live form) and submit a task. You'll see the task listed in the "Task List" tab and the user and the list admin/owner will receive an email notification.

A link to the request form can be shared with your team or organisation to allow them to submit task requests, or simply bookmark it for yourself to use.

 < Set up a scheduled task >

Open the Rose Task Manager calendar and add events you would like to schedule to appear on the task list sheet. Event length is ignored, so just make a full day event

Every day the calendar is automatically checked (4am GMT), that day's tasks appear on the task list and you'll receive an email notification.

The RTM calendar is produced alongside the default calendar provided by your Google account, see the Google support pages for more information on creating events and managing multiple calendars.

The name of the calendar can be changed.

The calendar can be manually checked at any time using "Add-ons > Rose Task Manager > Check calendar for tasks".

 < Customise an email notification >

Create a draft email to use as an email template, using placeholders of the form "{{PLACE_HOLDER}}", where PLACE_HOLDER is header of the column to take a value from.

For example, say you wanted the task "Description" to be included in the email the placeholder would be "{{Description}}".

Open the settings sidebar - "Add-ons > Rose Task Manager > Settings" - and select the draft email from the "New Task" dropdown list.

Any "new task" email notifications will now use this template.

The "Status Update" email notifications can be similarly customised.

 < Send a "Status update" email >

Click on any cell in a row in the task list and then "Add-ons > Rose Task Manager > Send Status email".

 << Installation creates: >>

 * A new sheet called "Task List". DO NOT RENAME THIS SHEET.
 * A new sheet called "Fields" that is used for validating the Priority and Status values. DO NOT RENAME THIS SHEET.
 * A Google Form (Form > Go to live form) for entering tasks into the task list.
 * Task email notifications. Submitting a task via the task request form sends an email notification to the user and the owner of the task list.
 * A Google Calendar called "Rose Task Manager". The calendar can be renamed.
 
 << History >>

RTM was originally conceived as a CMMS (Computerized Maintenance Management System) to allow regular maintenance tasks to be scheduled and allow facilities to submit ad-hoc maintenance tasks.

 << Support >>

 * Main RTM website - andrewroberts.net/portfolio/rose-task-manager/
 * RTM Google+ Community - goo.gl/KtBYQe
 * "Add-ons > Rose Task Manager > Help > Learn More"
 * My twitter - andrewroberts6
 * Contact me (Andrew Roberts) - andrew@roberts.net
  
 << Release Notess >>
 
// Version 1.6
// -----------

// * Removed analytics (that wasn't used anymore)
// * Add sidebar
// * Use GMail draft for emails (in Sidebar > Settings)
// * Add "About" to sidebar
// * Email notifications "from" configurable from Settings
// * Replace calendar trigger log with event count
// * Use calendar ID rather than name (so the name can be changed and RTM 
//   will still find it
// * Moved onOpen out of eventHandler_() and removed logging (there were lots
//   of errors in StackDriver, but I think these were fixed anyway in v1.6

// Version 1.5.1
// -------------

// * Ignore missing Timestamp column
// * Add trace for where the "not from Task List" columns come from

// Version 1.5
// -----------

// * Use Firebase for production logging - BBLog

// Version 1.4.4
// -------------

// * Stop calendar trigger after re-auth email 

// Version 1.4.3
// -------------

// * Updated auth email text 

// Version 1.4.2
// -------------

// * BUGFIX: Re-arranged event handler init so user email available, and errors
//   emailed.

// Version 1.4.1
// -------------

// * Made sure menu refresh not called when trigger deleted in context of 
//   a trigger

// Version 1.4
// -----------

// * Updated Assert library to fix error email send
// * Updated "re-auth" email text
// * Removed myself from "re-auth" email

// Version 1.3
// -----------

// * Stop trigger on "daily calendar check" 
// * Added "Stop/start" trigger menu option
// * Removed delete of columns on install as causing error

// Version 1.2.3
// -------------

// * Better "no RTM calendar" error message.

// Version 1.2.2
// -------------

// * Don't check calendar if not authed

// Version 1.2.1
// -------------

// * Downgrade non task list form submission

// Version 1.2
// -----------

// * Send error emails to user

// Version 1.1.1 (Add-on v5) 
// -------------------------

// * Updated so errors displayed as alert not thrown

// Version 1.1 (Add-on v4)
// -----------------------

// * Updated code to latest libraries, style, etc.
// * Added status description to emails
// * Added re-auth code
// * Reorganised installation
// * Added manual Calendar trigger to production menu

// Version 1.0.0
// -------------

// * Automated installation (create form, format sheet, create calendar, etc)
//   so that RoseTM could be released as an add-on.
// * Introduced various libraries (or development versions of)
// * Started on re-formatting.

// Version 0.4.1
// -------------

// * Added started column and auto-complete on going to in-progress
// * Add UA tracking (after release) via cUAMeasure library.

// Version 0.4.0
// -------------

// * Hadn't checked that unit tests were running on 0.3.0, so small changes for that.
// * Changed CMMS_NAME to TM_NAME
// * Checked with new sheets - minor changes
// * Removed filter from sort menu and added new ones

// Version 0.3.0
// -------------

// * Added "wait" text to form
// * Not in the code - but realised I need to set the triggers at 4am to avoid
//   slipping into previous day as events are stored in UTC.
// * Renamed to RoseTM.

// Version 0.2.0
// -------------

// * Generally made more generic and easier to deploy; removed all reference to original 
//   deployment.
// * Removed need for fixed task list columns, as long as the required ones 
//   are in place the user can add and remove their own wherever they like. 
// * Removed the notifyAssignee() function as it seems to impersonal to ever be used.

// Version 0.1.1
// -------------
//
// * Added auto-completion of date when tasks are closed (CLOSED or DONE).

// Version 0.1.0
// -------------
//
// * First beta release.
Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu