


That sheet could contain very simple information, such as a list of names and addresses. You probably already know that you can put information into an online spreadsheet, such as Google Sheets, and invite people to view or edit it with you. This all may sound vague, but it's hard to describe the app without giving examples or making comparisons, so let's do that. The information might be ideas, inventory, tasks, or something else. What Is Airtable? What Can You Do With It?Īirtable is an online system where a group of collaborators can store, share, and collaboratively edit information. For its versatility and ease of use, it's an Editors' Choice among collaboration apps. It's different from other, older database management systems because it looks like an app that anyone could learn to use, with simple language, friendly color schemes, and helpful icons. You can use it to manage work, track and organize inventories, plan an event, and much more. Before you brush it off as boring because of the word database, know that Airtable is easy to use and extremely versatile.
#Airtable database how to#
How to Set Up Two-Factor AuthenticationĪirtable is a relational database tool that's also an online collaboration tool.
#Airtable database Pc#
How to Record the Screen on Your Windows PC or Mac.How to Convert YouTube Videos to MP3 Files.How to Save Money on Your Cell Phone Bill.
#Airtable database free#
How to Free Up Space on Your iPhone or iPad.How to Block Robotexts and Spam Messages.If you want to enhance your Airtable API, check out the Micro Airtable API library on Github. To use the API, open up Postman and make your first call.Airtable has automatically generated API documentation based on your Base and Table’s schema.Next, go to /api and select the Base you just created.Note: Your API key can be used to access all your data in Airtable, so be sure to keep it secure.Next, generate an API key by going to /account and generating an API key.Create a “base” - Airtable’s word for a new database - and add some data to one or more tables.You basically just have to create an account and set up a base. Using Airtable is one of the simplest ways to turn your data into an API. Single API key is not as secure as OAuth or similar server-client flow.Authenticating users requires them to have an Airtable account and generate their own API key.Officially only allows up to 5 API requests per second, which might be fine for light use, but could be limiting as you scale up.Some issues with Airtable as an API include: In fact, you’ll quickly run into its limitations if you have a lot of traffic and can’t cache the data. API is automatic every Airtable you make already has API accessĪirtable is far from perfect.Excellent automatic documentation generated for each table.User roles allow limited role-based permissions.Query by complex functions for advanced filtering and searching of records.Can use with Zapier to trigger events in other services, send emails, etc.Input forms to allow users to add content.Permissions using sharing settings in UI.Authentication via a single API key is very simple.Super simple to get started, a zero-code solution.Some of the advantages to using Airtable as a no-code API include: Plus, you can use Zapier to trigger custom actions when new items show up in Airtable. The big advantage to using Airtable for your API is that they have an excellent visual user interface and integrations with many other tools built in. I’ve started using Airtable for almost everything that I used to pack into spreadsheets.
