In the last post, we began a discussion which impacts everyone who uses a paper planner. Tasks are written in the paper planner which have supporting digital material. When you do the task, you must have the digital material at hand. Begin by reading the last post if you have not already done so. When you have finished, return here.
An item from Dropbox or Evernote needs to be referenced while you are working on a task.
This technique is much the same as needing to reference a document on your hard drive. The trick to get the path name for the entry and paste that link into the spreadsheet.
Open Dropbox on your computer desktop, as opposed to accessing Dropbox from the website. Right-click on the desired file, and choose “Copy as path” from the menu. On the spreadsheet, right-click on the cell where you want the link to appear. From the menu, choose “Hyperlink.” Paste the path name into the address box.
In the planner, list the to-do. Beside it, reference the line on the spreadsheet which links to the document. An example might look like the example below:
For Evernote, open the desktop client. Right-click on the desired note. Select “Copy Note Link.” On the spreadsheet, right-click on the cell where you want the link to appear. From the menu, choose “Hyperlink.” Paste the path name into the address box.
In the planner, list the to-do. Beside it, reference the line on the spreadsheet which links to the document. Below is an example:
|Screenshot of the links generated using the examples in this post
and the post just prior to this one.
As stated in the last post, you must not insert lines into the spreadsheet or delete lines. Doing either would alter the numbering of all entries below it. When a link on the spreadsheet is no longer needed, the link can be deleted. That line is now empty, and the next task you need to enter can take its place.
This post is one person’s attempt at a solution which could help many. What do you think? Do you have another suggestion for approaching this problem?