Monday 1 May 2017

Airtable online database creator

The Informed Librarian Online has a recent post titled "Is There Such a Thing as an Easy to Use, Lightweight Relational Database?" by Dana DeFebbo, a law librarian at the Tarlton Law Library at U of Texas. The article is about Airtable, a new online resource for building databases. The author says that "Airtable is a cloud-based, lightweight relational database that integrates the relational database function of something like Microsoft Access with the overall easier to understand layout of a spreadsheet program like Microsoft Excel. However, Airtable is by and large much easier to use than Access and Excel, it is web-based so it can run on any machine with nothing to download, and it is mostly free."
Airtable is flexible like a spreadsheet, but it's made for organization rather than number crunching. You can use it to organize anything and when you start using the website you can view and explore of the ways Airtable is used for collections of information and project management. A nice feature is that you can customize your fields for a large variety of data types including text, attachments (like photos), checkboxes, date, email address, number, currency, formula, barcode, and many other types of information. Airtable has some preconfigured templates that you can modify for your own needs; you can also import an existing .csv file to create your own "base" from scratch. The interface is very user-friendly with "help" and "information" popups readily available.

No comments: