🅰️About Airtable

What is Airtable?

Airtable is a modern spreadsheet tool with database functionalities and inbuilt automations. It is simple, user-friendly, and allows anyone to quickly create a database.

Airtable makes it easier to interact with your data, while at the same time enabling programmatic management of your data.

Basics of Airtable

Bases

Bases are collections of Tables (similar to Workbook in Excel). Bases are like projects. For every new project you start, you'll likely create a new base.

Workspace

A workspace is a collection of Bases in Airtable. If bases are folders that hold Excel files, a workspace would be the hard drive that holds those folders.

Table

Tables are where your data is stored. They are similar to spreadsheets. Tables have columns, rows, and fields (which we'll get to in a minute).

Views

Views are a powerful Airtable feature that allows you to configure how you view the data in a table. The Grid view is probably most familiar because it is almost exactly like a spreadsheet. The Calendar view can be useful for Tables with dates, like deadlines. The Grantt view may be helpful if items have start and end dates, it shows them in a timeline.

Fields

Fields are similar to the cells of spreadsheet. Fields can do more than just hold text. Currently, Airtable has 29 field types, including Single-line text, Long text, Attachment (which can be used to save images, audio, and other files), and Date.

Relational Database

Airtable has this powerful feature which has ability to link records from one table to another This will create a relationship between those two tables.

For example, imagine creating a database for your CS Firm. These are some of the tables you would likely need:

• Tasks

• Forms (keeping records of all forms uploaded on MCA)

• Clients (details of Companies / LLP)

• Directors / Partners

All of these tables will be related to at least one other table. A task consists of forms and clients. A Clients consists of one or more Directors / Partners. In Airtable, you would create a link for each of those relationships.