Airtable for Case Analysis – Casemap Replacement

Slice n Dice Your Case Data

In cases with a multitude of witnesses, facts, and things spread over a timeline and various documents and sources, getting a big picture view becomes essential. On the Windows platform, most lawyers turn to Casemap to pull together meaningful chronologies with the ability to slice and dice by issues, people and source. Casemap provides a ‘spreadsheet’ view for each major list of stuff: people, documents, issues etc. Casemap also made it a breeze to filter each sheet down to just the info you wanted to see or share. For example, filtering all Facts in a chronology down to witness “Joe Smith” and Issue “liability.” Casemap was mostly spreadsheet, but like a weird cross breed with a database. In short, it was a great place to capture data about your case as it evolved and then analyze that data down the road when preparing for a deposition, hearing or trial. On the Mac side, there hasn’t been a really solid tool for doing the same thing until recently.

In the cloud alternatives.

Current pay-to-play services like FactBox ($38/month) and CaseFleet ($34/month) offer close approximations of Casemap through cloud based interfaces. A trial run of FactBox did not coax any money from my wallet as the interface and input of facts carried too much friction and fussing. CaseFleet came not too long after but, in the interim, a cloud based offering called Airtable appeared.

More function, more flexibility, less friction.

Airtable can do everything that FactBox or Casefleet can do, and more. Because Airtable is not locked in to a particular set-up, you get to choose what is what and where it goes. Want to create a chronological Fact sheet with links to sheets for Jury Instructions, Issues, People and Sources? You design it to fit your needs and never find yourself trying to pound nails with a screwdriver.


Further Airtable is free to use with some limitations that most lawyers will never run up against, but even if you find yourself pushing the limits, pricing starts at $12/month. Airtable, unlike Casemap which is captive on a desktop, is great at collaboration with other people. Finally, Airtable has a really smooth and polished iOS app that allows you to review, edit, add and update your spreadsheet/data tables from an iPad or iPhone. And, surprise surprise, the native app even offers split view if you’re using an iPad Pro.

The only downside is that, because it is a cloud based service, there must be an active internet connection in order to use Airtable. Otherwise, Airtable is an all-around win for lawyers trying to corral a large set of facts, witnesses and issues in a meaningful way.

Essential Mac Apps

The best part about Macs is the ease of upgrading to new hardware. In the old Windows days, an upgrade to new hardware meant hours lost reinstalling applications, hunting down serial number and praying to the software licensing gods that there wouldn’t be some crazy limitation preventing you from installing software you already purchased on your shiny new computer. With a Mac, the ability to easily transfer an entire user environment (apps, data, settings) from the old hardware is dead simple.

But, recently, I came into possession of an iMac. Not having worked from a desktop in a very long time, I decided to do a clean install of OS X and then track which apps I was forced to install first.

The First Apps Installed On A Clean Mac

Notably, you can get quite a bit of work down without installing anything. OS X’s built in Mail, Calendar, Preview (reads PDFs) and Address Book get you up to speed fairly quickly, and for free. But, it also didn’t take long to start needing other stuff to get the job done quickly, and more comfortably. So, from first installed to last, here’s the list of essential Mac OS X apps used in my daily routine.

June 29, 2012: Update - I was just over at MILO and read New Jersey estate planning lawyer Victor Medina’s response listing his essential Mac apps. He included Dropbox and Alfred (or LaunchBar). I actually use both of those and, in fact, installed those early on but they so seamlessly integrate into my workflow that I forgot to include them on the list altogether.

1. BusyCal – Sync with just about anything and list view.
2. Moom – Getting windows set just right on the screen.
3. 1Password – Surprised this didn’t come in first, really. Tracks all your important passwords AND credit cards, driver’s licenses etc.
4. TextExpander – Too many joys to explain, from audience specific signature lines in emails to shortcuts for legal citations.
5. OmniFocus – When you get tired of spinning your wheels and going ten different directions at once, put some direction to your energy (just don’t put it all into micromanaging your ToDo list, a.k.a. know when to stop organizing what you need to do and start doing stuff.)
6. Pages – Because, eventually, you’ll need to write something with substance and formatted in an eye pleasing manner.
7. DEVONthink Pro Office – Heavy lifting, digging deep case and issue analysis.
8. Skitch – Screenshots, but importantly, screenshot filenames which tell you where the screenshot came from, including the page number of the PDF you were looking at when you took the screenshot.
9. Circus Ponies NoteBook – Collecting and building notes, depo outlines, thoughts, themes and exhibits, so that it can all get thrown together into a Trial Notebook.
10. Default Folder X – OS X’s continuing shortcoming? Finder. Fix it with this nice little utility that makes the finder truly useful, including the ability to add OpenMeta tags to files as you save them.
11. DEVONtechnologies Free Word Service – Ever need to delete bunch of line endings or change an ALL CAPS line to small caps? Go get this free utility to quickly and effortlessly manipulate text.
12. DEVONsphere – $4.99 on the app store. Get it and play with it. It can be a bit of processor hog, so set it on a weekly index schedule, preferably on a day you are not working.
13. OmniOutliner Pro – The old standby outliner. It is a great way to organize depo outlines and the standout columns feature allows you to sort by date, or do spreadsheet style calculations.
14. Parallels/WinXP (TextMap, WordPerfect) – Bleh. Occasionally you just get sucked back in… think of it as going into the storage room in the basement to pull some old file out of archives and then relish your return to the sunlit corner office of Mac OS X.

Do you have a ‘must install’ app not listed above? Tell us about it in the comments, including the ‘why.’

Awkward Breakup

A call came in the other day.

“Hey Pete, it’s Jerry.”


“Jerry Raster… I used to work on the network and your computers at your office?”

“Oh! Hey Jerry, what’s up?”

“Well, I hadn’t heard from you in a long time and I was just wondering if I did something wrong last time, or maybe you found somebody else to work on your PCs….”

“Oh no no no. We switched to Mac.”

Long, awkward silence.

“So, um, yeah, since switching, we haven’t needed any tech support except for getting the Ricoh Copier/Scanner/Printer to play nice, but it’s on a lease so the vendor took care of that.”

“Oh. Mac?”


Long, awkward silence.

“Yeah, um, well okay. Talk to you later.”

DockView Shows App Thumbnails

Jealous of Windows 7’s ‘thumbnails’ that show up when the mouse hovers over an app on the task bar? DockView offers the same functionality, and more, for Mac OS X.  This great little app is only $7.99 and is free to try out with no limitations except an annoying and occasional ‘buy me’ window. The app plays nice with OSX’s Spaces so long as you switch to each Space and activate the app in that Space at least once.  So, if you have Preview PDFs open across three different Spaces, you can switch to them via the Dock thumbnail.  Additionally, when using Command-Tab, DockView also provides the pop-up thumbnail allowing quick switching for apps and windows. Finally, and better than Windows 7’s thumbnails, you can:

(1) alter the height and width of the pop ups; and, (2) pause, play and skip in the iTunes thumbnail. Genius and well worth the $7.99.

DEVONthink Pro for Case Analysis

DEVONthink Pro: Nirvana for case analysis?

Ever since switching to MacOSX there has been an empty space left by CaseMap.  DEVONthink offers not only an adequate replacement for CaseMap, but perhaps the best software available for attorneys interested in conducting case analysis on the Mac.  If your litigation efforts involve building medical/fact chronologies, requires reviewing multiple forms of electronic information such as PDF files, deposition transcripts, JPEG photos, and video, then DEVONthink represents the best tool for working with that data.  DEVONthink also offers some very sophisticated features such as a complete concordance of all words and some unique grouping and tagging capabilities. Although there are a few quirks, such as keyboard shortcuts which differ from the standard keyboard shortcuts in MacOS X, and a steep learning curve, the rewards for using the software are well worth the effort.

Typically, demonstrating  this type of software requires a screen cast. Unfortunately, the only data currently available for display includes information that needs to be redacted. So, a series of screenshots will have to do along with highlighting a few favorite features.

PDF page specific linking

DEVONthink comes with its own built-in PDF viewer. The PDF viewer built into DEVONthink allows annotation just as you might accomplish using Preview. More importantly, the built-in PDF viewer allows copying a link to the specific page you’re viewing. So, for example, when reviewing a large multipage PDF such as medical records or depositions, the user can copy and paste selected text into a separate note. The user can then copy a page specific link for later reference back to the excerpt.

Now, with the desired text on the clipboard, a new RTF entry can be made in the chronology.

Once the new entry is created, the link to the specific PDF page can be pasted. The blue underlining indicates a clickable link to return to the specific page for the quoted text. Of course, links can also be generated for a specific entry and dropped into another entry for cross-reference or words can be made into links and WikiWords are also automatically recognized.  Tagging can also be added, or, the entry can be made to exist under multiple groups. In this screenshot, the entry initially created in the chronology group also exists under the tag “credibility” and the group Analysis.  You can also see that the entries are sorted chronologically. Clicking on either Analysis or the tag “credibility” would also reveal this particular entry as well as any others contained within that group or tag.

One of the nice things about using the RTF format is that if you are using a screen clipping software such as Skitch, Little Snapper, or, Snagit, you can drop screen clippings of particular medical records or deposition transcripts directly into the note entry. Then the original can be seen next to any annotations, a feature which can be usefule when working with handwritten notes that have been scanned into a PDF format such as a doctor’s chart.

Complete concordance

DEVONthink also provides, much like Windows case analysis software Summation or Concordance, a complete concordance of all words contained within a particular database. You can imagine as an attorney how useful it can be to find all words within deposition transcripts as well as searchable text PDF files. And, of course, in conjunction with the concordance, the entire database is completely searchable and includes fuzzy word searching. So for example misspelled words or words improperly OCR’d can still turn up in the word search. Searches can be limited to particular groups or tags within a database, or can be expanded to include even other databases.

Panel window magic

DEVONthink is one of those rare pieces of software that the more data shovedinto it, the more useful it becomes. DEVONthink’s side window offers several useful features including an immediate access to entry specific concordance, i.e. all words in the currently displayed document. Single-clicking a word allows working through that entry/document while double-clicking any one of these words will reveal the search window for the whole database, or selected portions thereof.

Another side panel is the “magic hat” side panel. This panel can be especially useful in very large databases because it will pull up other, similar, relevant documents. Additionally, it can be useful if using the inbox for the initial import of documents in order to better classify the newly imported document because DEVONthink does the thinking for you and points out the most likely groups wherein the place it.

Getting Info Into DEVONthink

The ability to shoot information into DEVONthink in a variety of ways makes it an easily accessible tool and place to stash things.  Inevitably, while researching Issue A on Case A, attorneys come across another reference that fits perfectly for Issue B on Case B.  DEVONthink provides the ability to quickly shoot that nugget off to DEVONthink, even if DEVONthink is not running, and associate with the proper case for later use. A variety of keyboard shortutcs, print to PDF services, an omnipresent but unintrusive  transparent tab at the side of the screen, and web browser bookmarklets ensure information gets filed in DEVONthink quickly and in the right place without interrupting workflow.

Hard drive folders and files can be imported into DEVONthink, leaving the original copies in their places. Or, DEVONthink can ‘index’ a folder and update the DEVONthink database when items are added or deleted.

New Case Analysis Best Bet for Mac Using Attorneys: DEVONthink Pro

DEVONthink Pro is the way to go if you’re looking for case analysis, knowledge management or research gathering in the legal environment.

DEVONthink offers far more feature than can be covered here.  However, the developers offer a free trial and, rather than being limited to 30 days, the program is free to use for a set number of hours. This is a very nice way to run the trial because DEVONthink is so deep and legal practice often harried the 30 day trial might expire before you had the opportunity to fully explore DEVONthink’s capabilities. By limiting the trial period to hours of usage, you can work into it gradually and will likely soon find it an indispensable tool, one well worth the $149 purchase price.

A highly recommended complement to DEVONthink is Joel Kissel’s “Getting Started with DEVONthink,” a $10 e-book available for download. The book is well-written and easy to read with detailed explanations for the more intricate functions of DEVONthink.

A Word About DEVONthink as a Casemap Replacement for Switchers

Casemap tracks data in four basic ‘tables.’ Facts, Persons, Documents, and Issues. Because DEVONthink lacks an initial structure, it could easily be dismissed as unworkable for replacing Casemap.  However, any apparent lack of structure falls short as criticism. A creative attorney (or any knowledge worker, for that matter) will see a huge opportunity for creating their own structure, one without artificial limits. As a starting point for migrating from using Casemap, you might wish to create Groups in DEVONthink reflecting the four tables in Casemap. Creating an ‘AllFacts’ group for dumping everything factual, an ‘Issues’ group for dumping in issues and a People group for all people in the case can ease some anxiety for the switcher.  DEVONthink already contains a smartfolder for tracking All PDF Documents, so you won’t need that group.

From this point on, your options are wide open. See an issue or item that needs to be tracked across all of these ‘tables?’ Simply add a tag for that issue in order to gather them all in one place, create a separate Group and then replicate the entry to the Group (fyi, ‘replicating’ an entry to a Group is as simple as typing the Group name in the field at the bottom of the entry), or create a new smart folder that updates automatically with the item by keyword.  For example, in a birth injury case, the fetal heart rate might be at issue and span both facts, issues and other documents. The user can simply tag each of these ‘fhr’ and have them all automatically tracked under that tag, create a separate Group and replicate those entries into that Group, or create a smart folder that tracks all instances of ‘fhr.’ Finally, because you can conduct a global search, the ability to exceed Casemap’s artificial table limits should become immediately apparent. In Casemap, one can only search within a given table. In DEVONthink, you can search across the entire case including inside pdf files. More impressive, there doesn’t appear to be anything so powerful and customizable available on the Windows side at this price point. DEVONthink Pro FTW.

PersonalBrain Screencast

PersonalBrain offers some really nice features which may be of interest to lawyers. Years ago I tried to use this software in lieu of Casemap, while still working in the Windows environment.  Originally called ‘The Brain’ it had a lot of flash, but was thin on substance.  Since that time, upgrades and improvements have come a long way…. tagging, attachments etc. Here’s a screencast showing PersonalBrain in action with some legal research originally collected and kept in the now defunct Journler. Apologies for the crappy YouTube resolution. FWIW, click on the ‘fullscreen’ & ‘HD’ buttons, bottom right, for best viewing.

Three things not mentioned in the screencast. First, the software is cross-platform and can be used on both Windows and Mac provided you have licenses for both. Second, because the software is cross-platform and because it has been around for quite some time, it is likely that it will continue to be around for some time. Finally, the software has a great export feature which allows you to export the entire ‘Brain’ as a self-sufficient webpage. I haven’t tried this out yet, but the possibilities of being able to share a brain with an expert and/or client are tantalizing.

3 Reasons to Join MILO

MILO is the Google Groups forum “Macs In Law Offices.” Recently, there have been three reallyMILO Logo great posts by users on that forum.

  1. You can tether an iPhone to your Mac for internet access over the 3G network without hacking or jailbreaking. MILO user Christian Frank pointed everyone to But, there are better instructions at mydigitallife.
  2. MILO user Grace Suarez revealed a superb Firefox plug in called CiteGenie. If you’ve ever struggled with getting a properly quoted and cited copy/paste from Westlaw or Lexis into your document, this plugin eliminates hassle, allowing you to focus on the legal and analytical aspect of your work. CiteGenie truly represents the goal of getting computers to do the grunt work so you can focus on higher reasoning skills.
  3. You cannot tether an iPhone with the new 3.1 software update, as hinted at by MILO user Rob Ruffner and confirmed by comments in the mydigitallife how-to.

MILO is a great place to learn and ask questions, a superb resource for any Mac using lawyer.

Switch Resources

If you are one of the lucky folks making the switch to Mac by way of a gift this year, you might want to check out these two really great resources. First, The Unauthorized Apple Weblog has a great line of posts on switching.  They cover everything in their Mac 101 series from Address Book to booting from a USB drive.

Then, of course, Apple has their own resource for switchers, Switch 101. It is a bit more basic, but much more organized the TUAW’s Mac 101 series. Finally, don’t forget that you can get your data migrated over from a PC with the help of a genius at an Apple Store Genius Bar… just remember to make an appointment before you go.

Finally, when all else fails, hit Google. The venerable search behemoth can probably point you in the right direction, especially if you use site focused searching. For example, don’t just hammer search terms in, but search a specific site (or even subsite) like this: 

site: itunes deauthorize

Typing the above will pull all references out of the support pages at Apple on deauthorizing computers from iTunes.

Happy Holidays!

A Gripe and A Fix.

Part of the Apple experience comes from aesthetics. The hardware to the software all look so good and make interfacing with a computer a more human experience, less geeky and, I believe, makes work more enjoyable… of course a stable OS goes a long way too.

But, Apple (and many other manufacturers) miss the boat by not including a ‘Pointing Stick’ style mouse in their laptops. Years of use with IBM laptops (now Lenovo) convinced me the convenience of a Trackpoint or Pointing Stick on the keyboard outweighed the ugly. Moreover, after adapting to Apple’s trackpad only configuration, I have wrist pain in my right wrist from mousing. Switching to a lefty mouser helps, but probably only forestalls the inevitable, pain developing in the left wrist.

Although not a full-time solution, there are available desktop USB keyboards with built-in Pointing Sticks which a Macbook will recognize, so that while at a desk, an alternative and wrist relieving option exists.

Lenovo sells a full-size Ultra-Nav USB Keyboard that has both a Trackpoint and Trackpad option built in. Because it has a Windows key (shudder), you still get your command key for the Mac. The keyboard also has additional USB ports so your not going to lose a USB port by plugging it in. It costs a measly $99 and, as an added benefit, you get that beautiful IBM snap on the keyboard, a huge benefit for any touch typist. If you really want to kick it old school, sells an old style IBM keyboard, the Endurapro, that actually uses springs underneath the keys. This is that old-school clickety-clackety sounding keyboard, but those springs and the tactile feedback are much missed by many typing pros, authors, writers and geeks. The Endurapro does not, however, have additional USB ports but does have that ugly retro welcome to 1991 feel that you just can’t find anywhere else. It retails for $99 as well.

Somebody Finally Said…

what we’ve all been thinking, there may be “rot at Apple’s core” according to The Dallas’ Morning News Techblogger Victor Godinez. According to Godinez, the rot shows through because of shaky iPhone 2.0 software, the MobileMe fiasco (wherein loads of paying .Mac customers have lost emails or been frozen out entirely), and the ‘bundling’ of Safari and forced installation of MobileMe components alongside iTunes on Windows platforms. Linkbait? Maybe. My own personal experience while attempting to purchase a 3G phone seems to support the decay of a shiny Apple into a razor blade loaded Halloween treat.

While at the local Apple store, I considered picking up a new 3G iPhone. I dutifully went to the end of the line and asked the Apple store employee how long the wait would be and he informed me about an hour. Eeeesh. O.K. well, it’s Sunday and I have a good book in hand so, I’ll wait a while. After about fifteen minutes, another fellow queued up behind me. I noticed he had a small white tag which read “3G” in big letters. I asked him about it an he told me that I needed a ‘pre-qualification’ tag in order to be in the line I was in. Back inside the store to get the prequal tag, the manager pointed me back out to the line I was just standing in and told me I needed to ask the Apple employee for the prequal and that there was a ‘separate’ line in that line outside. “Really? I line to wait in line? It’s not like the Beatles are playing here.” Smug smug Apple certified smile and no vocal response, only a finger pointing me back outside. By now, five other people had walked up to the line. I decided to go read my book at home.

Of course, this doesn’t mean Apple is rotting away, growing moldy, wormy and ridden with holes. Rather, this is the inevitable slide that customer service takes whenever a huge success occurs. I simply cannot imagine anyone is more disappointed in the iPhone activation and hour plus wait for purchase than Steve Jobs. So, here’s hoping that the company can get through the growing pains of such enormous recent success and move back toward the solid company and customer service we all know and love.