WEB-Based Task Management System and Method

• US 20080244582A1
• Filed: 03/28/2008
• Published: 10/02/2008
• Est. Priority Date: 03/31/2007
• Status: Abandoned Application

• Current Assignee: Smartsheet Inc.
• Original Assignee: Smartsheet Inc.
• Inventors: Jones, Todd W., Mader, Mark P., Frei, Brent R., Brown, William E., Fasullo, Todd A., Frei, Maria R., Creason, John D., Astorquia, Jason S.
• Application Number:
  US12/058,605
• Publication Number:
  US 20080244582A1
• Time in Patent Office: Days
• US Class Current: 718/100
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]
• CPC Class Codes: G06F 9/54 Interprogram communication
• CPC Class Codes: H04L 12/1822 Conducting the conference, e.g. admission, detection, selection or grouping of participants, correlating users to one or more conference sessions, prioritising transmission
• CPC Class Codes: H04L 51/234 for tracking messages
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

A task management system and method integrates rich functionality into a web-browser based application. An efficient request for an update enables a user to quickly generate a completely customizable email message to intended recipient(s). By introducing a client side, in-memory database, the client component becomes less susceptible to network connectivity glitches and enables user interfaces to be redrawn without server interaction. Additionally, the task management system and method provides flexibility by enabling tasks to be grouped and organized. Specifically, a task may be associated with multiple task sheets and a task sheet may include multiple tasks in a many-to-many manner. Also, templates may be created that enable a user to start with a base template and to add (or remove) one or more columns. Further, the task management systems allows for multiple users to access and manipulate task data concurrently. In addition, the task management system provides a means for viewing the change history of task data within a task sheet by highlighting task data within a task sheet that has been changed by another user of the task management system.

Claims

1. A computer-implemented method for generating an email update request from an initiating client to a recipient account, comprising the steps of:

(a) sending instructions to the initiating client operable for;

(i) presenting a task sheet to the initiating client, the task sheet having at least one task and a set of associated cells;

(ii) receiving an email update request command from the initiating client;

(iii) presenting a user interface configured to enable selection of a subset of the associated cells;

(b) receiving the selected subset of the associated cells;

(c) generating the email update request based on the selected subset of the associated cells; and

(d) transmitting the email update request for update to an email address associated with the recipient account.

2. The computer-implemented method of claim 1, wherein the email update includes a single use authorization key.

3. The computer-implemented method of claim 1, wherein the email update includes a web form.

4. The computer-implemented method of claim 3, wherein the email update includes a single use authorization key.

5. The computer-implemented method of claim 1, wherein the email update includes a link to a web page that is rendered by an email client when the email client request does not support web forms.

6. A computer system configured to manage a task hierarchy, comprising:

a task data store configured to store information about a plurality of tasks, the task information including a parent task and a task unique identifier;

a task sheet data store configured to store information about a plurality of tasks, the task sheet information including a task sheet unique identifier; and

a task to task sheet data store configured to store a plurality of relationships between tasks and task sheets, said relationships including a task unique identifier and a task sheet unique identifier.

7. The computer system of claim 6, wherein a status of a parent task is at least partially determined by the status of a child task.

8. The computer system of claim 6, wherein a characteristic of a child task is at least partially determined by the status of a parent task.

9. A computer-implemented method for managing tasks, comprising:

(a) receiving information for creating a first task sheet;

(b) creating the first task sheet and assigning the first task sheet a unique identifier;

(c) receiving information for creating a first task relating to the first task sheet;

(d) creating the first task and assigning the task a unique identifier;

(e) creating a relationship between the first task sheet and the first task;

(f) receiving information for creating a second task sheet;

(g) creating the second task sheet and assigning the second task sheet a unique identifier; and

(h) creating a relationship between the second task sheet and the first task.

10. The computer-implemented method of claim 9, further comprising:

receiving information for creating a second task relating to the first task sheet;

creating the second task and assigning the second task a unique identifier;

creating a relationship between the first task sheet and the second task;

receiving an instruction to make the second task a child of the first task; and

updating the second task to include the unique identifier of the first task as a parent task identifier.

11. A computer system for managing a plurality of task sheet templates, comprising:

a task sheet data store configured to store information about the plurality of task sheets;

a column definition data store configured to store schema information about a plurality of system defined column types and further configured to receive and store information relating to user defined column types;

a row definition data store configured to store schema information about a plurality of system defined row types and further configured to receive and store information relating to user defined row types; and

a task sheet data store configured to store relationships between task sheets and column and row definitions.

12. A computer system for coordinating information between a client and a server using a client side in-memory database, comprising:

the server comprising;

a server processing unit;

a server memory device;

a server data storage device;

a server program stored in the server data storage device for providing instructions to the server processing unit;

a server database in the server data storage device for managing relational data; and

the server processing unit responsive to the instructions of the server program, operable for;

transmitting database structure instructions to the client;

transmitting initial data to the client; and

receiving data updates from the client;

the client comprising;

a client processing unit;

a client memory device;

a client data storage device;

a web browser program stored in the client data storage device for providing instructions to the client processing unit;

the client processing unit responsive to the instructions of the web browser program, operable for;

creating the client side in-memory database operating within the context of the web process based on the transmitted database structure instructions, the client side in-memory database configured to manage relational data;

populating the client side in-memory database based on the transmitted initial data;

generating a user interface configured to receive user input;

updating data in the client side in-memory database based on input received by the user interface; and

transmitting updated data to the server database.

13. A computer-implemented method for coordinating information between a client and a server using a client side in-memory database comprising:

transmitting database structure instructions from the server to the client;

transmitting initial data from the server to the client;

creating a client side in-memory database operating within the context of the web process based on the transmitted database structure instructions, the in-memory database configured to manage relational data;

populating the client side in-memory database based on the transmitted initial data;

generating, by the web browser, a user interface configured to receive user input;

updating data in the client side in-memory database based on input received by the user interface;

transmitting updated data from the client side in-memory database to the server database; and

selectively updating the data in the server database based on received updated data.