posted Jan 9, 2012, 5:54 AM by Sundew Shin
updated Mar 15, 2012, 9:05 PM
Where is it from?
Few years ago, I was working for a group of General Motors engineers and realized they can be really mean if you don't track every single details of each events, such as where that's from and where it's ended during the whole project time..
After the first round, I eventually developed myself a tool called 'Issue Tracking Sheet.' It is a simple spreadsheet document w/ the list of on-going/completed issue items, and I recorded logs of all the related events and share the sheet every Friday with all, and I didn't get bothered ever since, plus, I found myself amazingly organized in terms of issue tracking.
It worked as charm, but it has only one problem. It works in only one direction. Since it was a simple spreadsheet file, it wasn't easy to absorb many people's voluntary status update or feedback. There were laid the classic 'version control' problem.
What is Historian?
We decided to call it, 'Historian.' It is a GAS-written program purposely mimic the functionality of the issue tracking spreadsheet. (The back-end spreadsheet is just look the same as my old tracking sheet) It has the front-face GUI which provides interface to receive feedback (cooperative update logging) more easily.
Long story short, you can use it, as it was originally designed for, as a task/log-oriented bulletin board with your team members or contractors. Or, you also can use it simply as your personal todo-list or task manager, or be more creative and impress me. =)
How to install on my Google Apps domain?
Historian will automatically prepare itself and run as if it's an unique copy for the page inserted, for you and the page visitors.
Please feel free to leave your comments at: email@example.com
- Known Bugs:
- 030712 - fixed the [BUG] newly added item needs to be sorted as well
- 030712 - fixed the [BUG] define the date selection after: filter selection -> item modification
- 030712 - fixed the [BUG] ghost data left on the UI after cancellation
- Implemented configurable timezone
- Utilized Cache/Lock devices
- Added commenting permission
- Added customized status indicators
- Google Apps Gadget URL for your application:
- Utilized the LockService for preventing interlacing modifications from separate invocations of script to the spreadsheet for:
(Class Records).write(Class Sheet)();
- Utilized the CacheService for caching == speed up the code execution
- Known Issues
- Syntax error: We're sorry, a server error occurred. Please wait a bit and try again. line: ? (line 60)