Skip to main content

Airtable: I'll take that data to go

Will Porter's review of Airtable is online now at Macworld:

http://www.macworld.com/article/3036505/software/airtable-review-a-drop-dead-easy-relational-database-management-system.html

Rucksack TeXnology clients may be very interested in Airtable. It's a relational database management system that has many advantages. It's free to get started (and possibly free to stay with). On computers, it runs in any web browser in pretty much any operating system. On smart phones, at the moment it's available only for iOS devices, but an Android app is in the works and coming soon.

How's Airtable compare to FileMaker?

FileMaker is a much more powerful tool: not just a more powerful RDBMS, but a much more powerful application development system, that is, a more powerful user-interface builder.

But surprisingly often, you don't need the user-interface tools that FileMaker provides. You just need to store data for later retrieval. In that case, Airtable may beat the pants off FileMaker, because Airtable costs nothing to start using and may cost nothing to keep using, and because it's so easy to use.

Photography analogy: FileMaker Pro is like my Olympus O-MD E-M1: Powerful, customizable, but challenging. Airtable is like the DxO ONE: Powerful, too, albeit in a more limited way, yet delightfully easy to use.

I like FileMaker Pro and even if I didn't, there's simply no way for me to rewrite CMAssistant or Acquittal or my other key apps using Airtable. But I like Airtable a lot, too, for different things. It's great to have more than one tool available. I'll be writing more about Airtable in the future and I expect I'll be recommending it  to some of my clients.

Labels:

Comments

Post a Comment

Popular posts from this blog

Setting up OAUTH with Google in FileMaker 16

Setting up OAuth with Google in FileMaker 16 Posted by William Porter Intended audience: Intermediate to Advanced FileMaker developers Date of publication: 2017-June-06 Updated: 2018-June-06 One of the many exciting features in FileMaker 16 (released May 2017) is OAuth or Open Authentication. Open Authentication allows users to connect to a FileMaker database after authenticating with an external (non-FileMaker) account. At the present time, FileMaker supports OAuth through Google, Amazon and Microsoft. If you're a developer there are two main questions to answer. First, should I do this? And second, how do I do it? I'll answer the first question later. It's important. But the other question-- How  do I setup OAuth?--is answered in the attached document. I wrote this tutorial with the help of my friend and colleague Taylor Sharpe of Taylor Made Services , also here in Dallas. We provide step-by-step instructions on how to get your users authenticating in...
6 comments
Read more

Virtual List Basics

The concept The basic trick behind virtual lists is the wonderful GetValue() function. GetValue() takes two parameters: A list of return-delimited values A number specifying which value in the list to get For example say you have a field in a single record called “List of Values” and it contains the following:    Apple    Boy    Cat    Doorknob    Elephant    Fish When that record is selected, GetValue ( MYTABLE::List of Values ; 4 ) will return “Doorknob”. The brilliant idea is to replace the list of values stored in a field with a list in a global variable . The basic implementation, part one Create a table called VIRTUALLIST. In it, define these two fields: VALUE NUMBER: a number field Value_calc: calc field returning text value, = “GetValue ( $$VALUES; VALUENUMBER )”. Make sure that this value is an unstored calculation. Go to the layout for the VIRTUALLIST table and create s...
Post a Comment
Read more

Chrome becomes my default browser

Just discovered quite by accident that I can now zoom text in Chrome on the Mac (version 42) by double-tapping with two fingers . I gather this may have been added a little earlier this year but I only just noticed it. Anyway, that eliminates the last reason to keep using Safari, for me, anyway. The other major advantage of Chrome is what Chrome calls "presentation mode". This provides  true full-screen browsing , that is, the ability to fill the display with the contents of a single tab without menus, the bookmark bar, the location bar or visible tabs. Safari (version 8.0.5) can't do it at all. Opera Beta can do it, but does it badly. In Opera, once you hide the location bar, you can't type Cmd-L to enter a new URL. Presentation mode doesn't mean a lot to me on my iMac's big display, but on my 11" Macbook Air, getting rid of everything but the content area really makes a difference. I'm getting closer to my dream: a world where all my hardware co...
Post a Comment
Read more