ABCDEFGHL
1
IDSubjectTypePriorityStatusAdded ByDate AddedVersionDescription/Notes
16
65Review documentationBug1 - High2 - OpenAJR06/06/2013Pre 1.0
33
100Make form editableFeature1 - High2 - OpenAJR21/10/2015v3Requested by mjyearout@gmail.com
41
101Email the whole job request to the adminFeature1 - High2 - OpenAJR08/12/2015v3Requested by pilgrimtravels@gmail.com
52
111Privacy Policy on websiteFeature1 - High2 - OpenAJR01/09/2017
56
119Multiple GCal events trigger duplicate emailsBug1 - High2 - OpenAJR23/11/2017Two events triggers two form submissions, each trigger then processes the new submissions and duplicate emails get sent out
59
16Create unit testsFeature2 - Normal2 - OpenAJR02/05/2013
60
63Test 1.4. Fail (TestDoc v0.1)Bug2 - Normal2 - OpenAJR05/06/2013Pre 1.0Test 1.4. Fail (TestDoc v0.1) - Need form validation as blank form can be submitted. Make all fields mandatory and indicate this.
61
64Test 3.2. Fails (TestDoc v0.1)Bug2 - Normal2 - OpenAJR05/06/2013Pre 1.0Test 3.2. Fails (TestDoc v0.1) - No warning when try to send an update email with a blank email address.
63
77Create a weekly report of closed jobs (status changes?)Feature2 - Normal2 - OpenAJR02/07/2013Pre 1.0
64
78Create a form for updating the job listFeature2 - Normal2 - OpenAJR02/07/2013Pre 1.0Rather than having access to the raw data - the job list itself - a new form could be created that could be used to adjust the job list not only add jobs. This would automatically put in a date for closed jobs and remove the confusion about the row and ID numbers (Job 82).
65
80Seperate sheet for projectsFeature2 - Normal2 - OpenAJR28/07/2013Pre 1.0It would be possible to set up a seperate sheet that just contained the Projects.
67
94Add underscore after local functionsFeature2 - Normal2 - OpenAJR12/11/2013Pre 1.0
77
96Create an import task list featureFeature2 - Normal2 - OpenAJR27/12/2014v316Nov2017 - Some of the code is there to export to Trello.
78
97Add one off tasks back to CalendarFeature2 - Normal2 - OpenAJR13/01/2014v3Hi there Andrew, I have been testing out using Rose Task Manager for the business that I run and just had a quick query. I was reading through the help section on your website but was unable to find anywhere that showed if it was possible to go from Google Sheet->Google Calendar. I of course recognise that Rose allows the sync of data from Google Calendar -> Google Sheets but was wondering if there was functionality to make tasks added in a Google Sheet then show up on Google Calendar as a reminder on a certain date? Thanks for any help you can give. Regards, Lewys. (lstocks@titanmouthguards.co.uk)
80
98Configure cal name to allow mult instances of RTMFeature2 - Normal2 - OpenAJR16/05/201416Nov2017 - v1.6 uses the calendar ID, so the name could be changed although only instance of RTM can be installed.
82
99Add deadline reminders to Rose Task managerFeature2 - Normal2 - OpenAJR16/05/2014
88
102Status Update PageFeature2 - Normal2 - OpenAJR06/01/2016Thanks for doing this. It is a great tool to help us doing our job easier. I am wondering if possible to put a status follow up page for the requester. I know that it sends status updates to requester. Also we can send it very easily. If we have status update page about the problem or request online, people could see if someone already have same problem or request in the room or location. They may not submit the same problem again. Also, that would be nice anyone can see the progress of the work online with subject line and location. I hope it is clear :) Thanks for your time and enormous work. Huseyin Sari (see email https://mail.google.com/mail/ca/u/0/#inbox/15216777917c9e2d)
93
103Make sender of status email configurableFeature2 - Normal2 - OpenAJR18/04/2016Is there a way to change settings so anyone can send a status email? Right now, I think I'm the only one who has that option as "owner" of the google doc. I would like our students who are completing the tasks to be able to send a status update email." - Requested by leverh...@gmail.com in April 2016.
94
104Make calendar name configurableFeature2 - Normal2 - OpenAJR27/06/2017Thanks for an amazing resource. I am wondering if multiple spreadsheets with this add-on can run at the same time. I would like to have a separate calendar for each project I am working on and tied to each calendar the spreadsheet syncing all the tasks from that projects calendar. The old version of the calendar allowed for the name of the calendar to be edited. But I am not sure the add one allows that or if multiple sheets can run at the same time (i.e. would they all try to sync with the "Rose" Calendar?)
96
105Manual entries stop the auto-numberingBug2 - Normal2 - OpenAJR01/09/2017
97
106During BST today spans two days if cal trig recreatedBug2 - Normal2 - OpenAJR01/09/2017Tomorrows events are picked up during BST (but not always??) Only get this is the calendar trigger has been deleted and then recreated (due to an error like there being no calendar).
98
108"Reinstate calendar" menu option when there is trigger (but no ID stored)Bug2 - Normal2 - OpenAJR01/09/2017Get "Script onStartCalendarTrigger experienced an error" if then try to restart it. This more to do with failing to refresh the menu as it goes away on refresh.
99
109When calendar trigger is disabled, menu not updatedBug2 - Normal2 - OpenAJR01/09/2017
100
110"Re-enable calendar trigger" can be called with no calendarBug2 - Normal2 - OpenAJR01/09/2017
101
112Make calendar trigger run at 4am local timezoneFeature2 - Normal2 - OpenAJR02/09/2017
102
114Empty draft option list if no draft choosenBug2 - Normal2 - OpenAJR21/11/2017I've tried to make this say "Default draft", but can't work out why it won't.
103
115If header name has changed the default email template isn't filled inBug2 - Normal2 - OpenAJR21/11/2017
104
116Setup regular events using the Settings sidebarFeature2 - Normal2 - OpenAJR22/11/2017
105
117andrewroberts.net bad position in sidebar "About"Bug2 - Normal2 - OpenAJR22/11/2017
106
118onEdit doesn't work if headers change - can't use meta dataBug2 - Normal2 - OpenAJR23/11/2017Could I use an installable onEdit trigger??
107
127Customisable completed task emailFeature2 - Normal2 - OpenAJR01/12/2019From Gabriel Calel: "On your settings you gave us the option of customizing a “new task” and a “status update” email, would it be possible for me to create a 3rd option so I could create another draft email that would be mainly for reporting a “completed task” and it would include a small report and other {{Columns}} for example {{Total Time Spent}} ."
108
128Automatically send "job done" emailFeature2 - Normal2 - OpenAJR01/12/2019From Gabriel Calel: " In regard, to sending emails, is it possible to have have an email sent once a status is chosen - for example once “5 - Done” button gets selected it sends an email rather than having to go Add-Ons > RTM > Send status email?
"
109
33Define enums for constantsFeature3 - Low2 - OpenAJR03/05/2013Pre 1.0AJR 8/6/13 Started doing this, but I don't know if the rest are worth converting as you are actually replicating enums with objects (?)
110
41Create a class for spreadsheet accessFeature3 - Low2 - OpenAJR06/05/2013Pre 1.0
111
52Facility to pre-notification about jobs coming upFeature3 - Low2 - OpenAJR26/05/2013Pre 1.0This could be done by using calendar notifications as the calendar is the PPM job email notifications are presently created by the MJL script. See task 14.
112
56Automatically escalate jobs after a monthFeature3 - Low2 - OpenAJR29/05/2013Pre 1.0Although there is the risk that escalation will just be ignored if every thing becomes high priority. Perhaps a nagging email to the MM instead. Or a weekly report.
114
59Don't list regular jobs when it hasn't been done the last timeFeature3 - Low2 - OpenAJR30/05/2013Pre 1.0
115
60Use speadsheet as master list for regular tasksFeature3 - Low2 - OpenAJR03/06/2013Pre 1.0I have added the long id assigned by the calendar to job list, but it would be nice to have an easy ID to search for in the calendar. The PPM job could be saved in a spreadsheet master list - they'll ultimately be stored in a db table - and the calendar could just be the visual rep of them. But then a new interface would have to be created to add calendar PPM events and assign a simple ID that could be searched for in the emails.
116
61Link to the regular calendar event in notification emailFeature3 - Low2 - OpenAJR03/06/2013Pre 1.0
117
67Look at other CMMS features I could employFeature3 - Low2 - OpenAJR06/06/2013Pre 1.0See development journal
118
82Can we hide the row numbers?Feature3 - Low2 - OpenAJR28/07/2013Pre 1.0People are getting confused the row number and the ID number. They are used to manually assign ID numbers, we'd need a different way of displaying the job list maybe via a webpage.
119
88Add facility to subscribe to task list/add email addressesFeature3 - Low2 - OpenAJR22/10/2013Pre 1.0
120
93JSDoc?Feature3 - Low2 - OpenAJR02/11/2013Pre 1.0
121
107Reinstate Dialog when run from UIFeature3 - Low2 - OpenAJR01/09/2017
122
120Automate log analysis Feature3 - Low2 - OpenAJR23/11/2017I'm never getting around to checking the firebase log, so either move back to Analytics or automate the download and analysis of the Firebase log.
123
121Move "disable calendar check" to SettingsFeature3 - Low2 - OpenAJR23/11/2017
124
122Move script properties out of libraryBug3 - Low2 - OpenAJR24/11/2017
125
123"Invalid email" warning if task from calendarBug3 - Low2 - OpenAJR24/11/2017Want some way of distinguishing the two ways a task can be listed, as coming from the calendar it doesn't provide an email address and just the admin email gets used. Also remove "NO EMAIL SENT TO USER as no valid email address found." from default email template.
126
124Add meta data for "task list" sheet. Feature3 - Low2 - OpenAJR24/11/2017
127
125Add BCC for email notificationsFeature3 - Low2 - OpenAJR17/03/2018
128
126Configure "event requested by"Feature3 - Low2 - OpenAJR29/10/2019From fidelfidelfidelqc@gmail.com: Would like to ask when i create an event on the calendar, for the "requested by" entry , its always request by Rose Task Manager. Is there any way i can create an event on the calendar and i can input the name who request it. Cause i would like to share the calendar with my colleagues so they can input the name who requested it.
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176