Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet. The fields in an Airtable table are similar to cells in a spreadsheet, but have types such as ‘checkbox’, ‘phone number’, and ‘drop-down list’, and can reference file attachments like images.
Users can create a database, set up column types, add records, link tables to one another, collaborate, sort records and publish views to external websites.
Components:
- Bases: All the information needed to create a project is contained in a Base. Bases can be built from existing templates provided by Airtable. They can also be built from scratch, from a spreadsheet or from an existing Base.
- Tables: A table is similar to a spreadsheet. A base is a collection of tables.
- Views: Views show the result sets of data queries and can be saved for future purposes.
- Fields: Each entry in a table is a field. They are not just restricted to hold text. Airtable currently offers 16 basic field types. These are: single-line texts, long text articles, file attachments, check-boxes, single select from drop-down list, multiple-selects from drop-down lists, date and time, phone numbers, email ids, URLs, numbers, currency, percentage, auto-number, formulae and barcodes.
- Records: Each row of a Table is a Record.
- Workspaces: A workspace is a collection of Bases in Airtable.
- API: After you’ve created and configured the schema of an Airtable base from the graphical interface, your Airtable base will provide its own API to create, read, update, and destroy records (CRUD, alternative to Firebase ?).
Free offer
La version gratuite autorise un nombre illimité de bases, avec maximum 1200 enregistrements et 2 Go d’espace disque (par base).
Pricing
Les versions payantes (10$ et 20$) permettent de dépasser ces limites.
Date of last update: 10 December 2019