Tool Crush: What’s So Great About Airtable?

5 Simple But Powerful Airtable Features

So I wrote/recorded a whole IG series about my love for Airtable and I decided to put it all together and post it as one big post to make it easier to find and watch.

So Exactly What Is Airtable?

 

View this post on Instagram

I don’t know if you know this, but I kind of geek out about online tools. ❤️ Ok, I a lot geek out about them. 🤓 But I’m not going to tell you about the newest shiniest thing I just found that is so amazing omg. 😉 I’m going to tell you about my old flame. My always and forever crush, Airtable. 😍 In Ye Olden Times… (say like 2007?) I was using this “lovely” database software called Access from Microsoft. Perhaps you’ve heard of it 😝 I cannot adequately express to you the mental anguish caused by trying to get data to work together using this tool. 🤬 And I know you all know what Excel is. Or Google sheets, or Numbers or whatever the Mac users have it’s been so long I have no idea. 🤓 Excel is a pretty awesome tool, but it has limits. Yes, you macro wizards out there can get it to do some sweet calculations. It’s marvelous at calculations and formulas, and turning tables of data into pretty charts. All day long my go-to-gal. 🤓 So Imagine if the Beautiful tables of Excel and the theoretical data flexibility and connectivity of Access got together and had a baby, and it was beautiful, and web-based and easy to use and could connect to things all over the internet. 🦄 That baby is Airtable. 🦄 It’s free to use (like you can get a LOT just using the free version) and you can use it for so many things (both business and personal) that I cannot even start to name them all. 🦄 Instead I want to show you some of things I love about Airtable. So I’m going to be posting video walkthroughs (super short) here about 5 of my fav features of Airtable ❤️ I realized that I geek out about this stuff all day long because I already love spreadsheets and can instantly see the potential of a tool like this – but not everyone thinks like me. Duh. 🤓 So I thought it would be helpful to spread the love and awesomeness of Airtable by showing you some of the things it can help you do. ❤️ Because it really is my favorite data organization tool for businesses and can simplify your customer research and feedback SOO much. * If you’ve made it this far, I’d love to know if you use Airtable! 😍 Have a great day! 🤓 Karyn #airtable #iloveairtable #businesstools #techtools #database

A post shared by Karyn (@hey.karyn) on

 

1. Column Data Types

View this post on Instagram

Anything you want? You got it. Data types I mean. 🤓 What’s my #1 favorite thing about Airtable? She’s versatile. And of COURSE she’s a woman. Able to hold practically infinite types of data, all in close proximity, sort out what she needs on a whim and link it all together? Woman. 😉 There I said it. Airtable is a woman. If a woman were a sweet sweet database tool. 💃 Anyhow… today I’m showing you my first favorite thing about Airtable. The ability to put different types of data in any column. The video walks you through and shows you what I’m talking about but basically in any column in your “base” aka database, you can choose and format the kind of data you want to go in that column. I’ll get into some of the different options later in my favorites because some of them are …you know… my favorites, but here is a nice list of all the different data types you can choose from. Eeeeeeek. Single line text Long text Attachment Checkbox Multiple Select Single select Collaborator Date Phone number Email URL Number Currency Percent Duration Rating Formula Rollup Count Lookup Created time Last Modified Time Autonumber Barcode Link to another record I mean. 😍x ♾ So what does this mean? It means you can hold ANY of these, EACH of these, and ALL of these data types in ONE table inside your database. So versatile and ready to be of use. Next up? My #2 favorite thing about Airtable? That Multiple Select option up there. SOO cool. #airtable #iloveairtable #ihaveacrushonairtable #airtableismybff #businesstools #database #techtools #testimonialtoolkit

A post shared by Karyn (@hey.karyn) on

2. Multiple Select ❤

View this post on Instagram

This is when I truly fell in love. 💕 Multiple Select So I mentioned this feature in the Column Data Types post as one of your data options for each column. It's magic. It's my favorite. Basically it allows you to create a list of options to choose from for that column. I'll explain how I use it as an example. Say I want to use that column to categorize a quote or bit of language I have from a piece of customer feedback. I go ahead and create a list of categories for that column that relate to how I might use this quote in my marketing copy. So my categories might be… Benefits Struggle/Problem Trigger Situation Dream Anxiety/Fears Experience Delight/Surprises Before After You can have as MANY as you want. So I have a quote and I want to categorize it as Benefits. Great. But what if that same quote also speaks about their experience? Do I need to create a whole new line of data? Nope, just ALSO select Experience and they are both selected for that line in that column. It makes categorizing, or as I call it coding or tagging your data SO MUCH EASIER. Easier to do, easy to sort through and if you have multiple columns using multiple select… 🤯 So much more powerful. Hoory for Multiple Select! Can you think of ways you could use this feature with your business infomation?? Comment let me know! #airtable #iloveairtable #ihaveacrushonairtable #businesstools #database #techtools #testimonialtoolkit

A post shared by Karyn (@hey.karyn) on

3. Forms!

4. Checkboxes ✔

View this post on Instagram

What is so great about a checkbox? Have I mentioned that Airtable is versatile? Ok to give you some examples of things you can use the checkbox option for… My favorite = A workflow board Imagine taking one of those glorious whiteboard project workflow boards and putting it in digital form. Sortable by checkmarks. 😍 Also, simply just being able to use that "Done" ✔ functionality to a different kind of project or task table. Marking things paid. Also it DOES play well with other tools, like Typeform. I checked. It's not the shiniest feature on the block but it sure is useful. Can you think of a way you could use checkboxes in your workflow? #airtable #iloveairtable #ihaveacrushonairtable #airtableismybff #businesstools #database #techtools #testimonialtoolkit #airtablecrushweek

A post shared by Karyn (@hey.karyn) on

5. Grouping & Filtering

View this post on Instagram

If you liked organizing your toys, this feature is for you. We all know what filtering is. So yeah, you can filter. Great. BUT, you can also GROUP. Which is like sorting BUT you still get to see everything AND it's neatly organized into separated groups. The video shows this if you need the visual and I walk you through some examples. So if you have a column that shows the status of the projects or tasks and you want to see more clearly how many items are in each status group, you use grouping feature for that column and it groups them, spaced out so that you can quickly and clearly see what's in each group. And you can do multiple groups, and add in filtering and sorting and get as fancy as you want, to see the data you need to see. AND if you like a view so much you want to use it all the time, you can. You can create a "grid" view of that data, add the exact filters, groups, etc that you want and it will stay that way and be ready to view any time without having to set it up each time. So that's it for 5 of my favorite Airtable features to get you started. Did you learn anything new? Do you think it's worth checking out Airtable? Next up I'll be doing some live (and not live) videos (over on Facebook) walking you through how to set up Airtable for collecting and organizing your customer feedback. Both in a general database form and for use with surveys. Thanks for nerding out with me. #airtable #iloveairtable #ihaveacrushonairtable #airtableismybff #businesstools #database #techtools #testimonialtoolkit #airtablecrushweek

A post shared by Karyn (@hey.karyn) on

 

 Let me know if this was helpful and if you have any Airtable questions!! Thanks!

Related Articles

How To Decide Who to Interview

How To Decide Who to Interview

Tips for Selecting Customers to Interview   You Want Diversity of Perspectives Whenever possible, you want people with different perspectives, experiences and goals. This gives you the widest range of stories for others to connect with if you are using your...

Stay Up to Date With The Latest News & Updates

Pin It on Pinterest

Share This