Airtable is an easy-to-use online platform for creating and sharing relational databases. The user interface is simple, colorful, friendly, and allows anyone to spin up a database in minutes. You can store, organize, and collaborate on information about anything - like event planning, expenses tracking, and customer relation management. You don’t even have to learn what SQL stands for, let alone any scripting.

 

As shown below, The basic components or building blocks of an Airtable database include:

• Base - A base is a single database with all the information you need for your project. Your base might be called “Dog Records”. It contains the infomration on all your dogs, i.e., name, DOB, sex, microchip #, AKC registration, etc.

• Table - A table is used to hold a list of data about one particular type of item. Each base can have one or more tables. For example, your Dog Records base can include Registration & Certificate table, Medical History table, Showing Planner table, and so on.

• Field - Each column in a table is called a field. Fields are the equivalent of spreadsheet columns, though fields are designed to bring consistency to your data. Each field has a name and can be customized to hold a wide variety of content, like photos, attachments, phone numbers, dates, checkboxes, and more.

• Record - Each record is a cell item in your table. In a table of Registration & Certificate, for example, each record is a different dog, with data in each field to detail their name, DOB, AKC registration #, and more. A dog name can be associated with multiple tables, i.e., Medical History, Feeding Chart, etc.

• View - Views allow the records fitting certain criteria to be displayed at once. Each table can have many views. For example, the Registration & Certificate table can be viewed by sex, or other criteria.