Airtable update – it’s like building a custom app

My first post on this updated blog, “Collaborative care for the choir” was an initial review of Airtable: www.airtable.com. Now that I have used it pretty solidly, here are my take-aways:

  • Collaboration tools are pretty good – we use it mostly to communicate changes and updates to our choir section leaders. The fact that Airtable puts a timestamp on record changes is really helpful.
  • It is fast. Syncing is instant, and works great on mobile or desktop.
  • The ability to create a web form is handy and really useful – and different from what you would do with a Google form. Google forms are great for collecting info, but Airtable forms are good for getting data into your own….
  • CUSTOM APP! Seriously, it’s like building your own app. Linked tables are the secret sauce to making it work.

Online form

Our choir had an awesome opportunity to sing with Michael W. Smith here in Knoxville for an event that Olympic ice skater Scott Hamilton organized. I put the signup form out via Airtable and had a custom app for the event where I could assign the singers their seating row and handle the number of passes and tickets needed.

I made this as a separate project in Airtable, but I should have made it as a table within my choir roster – and then folks could have simply checked their name off the list and I would already have their contact info at hand. Slick!

True database power

The most incredible use of Airtable is how we are now using it as the data backend for the Knoxville Area Handbell Festival. It now serves as registrar, checkbook ledger, financial reporter, music archivist, contact database, and legal document organizer. For the first time ever, I will be able to handle the duties of treasurer without having to lug around my computer and my black zippered binder stuffed with documents.

Using Airtable requires a bit of database understanding to really get going, but nowhere near as much as any other program I have ever messed with. Access? Forget it. Filemaker? Whatever. Fusion Tables? Still kind of intimidating. Airtable? YES.

Hey Airtable – think you could raise the limit on the number of rows allowed in your free version? Or maybe come up with a slightly lower price for the first tier of paid service? I don’t really know how much it would cost because of the whole “per user” charge thing. Just my 2 cents…

IMG_0063
Cedar Springs Sanctuary Choir rehearsing with Michael W. Smith at the Knoxville Civic Colosseum
Advertisements

2 thoughts on “Airtable update – it’s like building a custom app

    1. Hi Lindsay,

      I currently have the following fields setup: Date, Check#, Description, Notes, Amount, Documentation (file attachment), and Cleared (checkbox). In your first transaction, put the value of your account. For subsequent transactions, enter negative amounts for debits and positive amounts for credits. It won’t show a running balance on your phone or ipad, but on your computer Airtable will show a running total along the bottom. Hope that helps!

      Andrew

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s