Numbers can be used to store next actions and projects in a GTD system

  • We can store next actions of a GTD system in Apple Numbers by creating two tables for next actions and projects.
    • The projects list is just a plain list of projects, with a completion checkbox, a title, and an optional due date field.
      • We could add an optional notes or project support field as well, where we can link notes and other assets, or just link them using the title field.
        • It would be nice if we could link to Hook itself, where the link would open the a bunch of assets in the Hook window.
    • The next actions list contains a completion checkbox, a title, a due date, a context, and an optional project field.
      • The context field can be a drop-down listing all of our contexts.
      • The project field can be a linked field using a formula for the projects table title field.
  • Category grouping on the next actions table can be used to group next actions by context.
    • Contexts groupings can be folded, depending on where we are and what we want to see.
    • We can create sums for the number of nexf actions in a group.
  • Writing AppleScript for syncing with Reminders should be easy.
    • The script can create different Reminders lists for each context.
    • Due date can be assigned as Reminders due date.
    • Next actions can be added to each Reminders list using the following format.
      • Next action title [Project Title]
    • Questions
      • Could it be possible to sync changes from Reminders back to Numbers using AppleScript?
  • Questions
    • What pivot tables are?
    • Can we use pivot tables to create multiple views (perspectives) for the next actions table?
    • How would we store task related notes?
      • A new field can be long, but we can’t have fields under another row.
    • What would be the benefit of this system other than just using a proper task management app like OmniFocus?
      • I guess it’s free and comes with every Mac.