Airtable

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Airtable
Type of site
Cloud collaboration service
Founded2012
HeadquartersSan Francisco
Founder(s)Howie Liu, Andrew Ofstad, Emmett Nicholas
IndustryInternet
Websitehttps://airtable.com
RegistrationRequired
Current statusActive

Airtable is a cloud collaboration service headquartered in San Francisco. It was founded in 2012 by Howie Liu, Andrew Ofstad, and Emmett Nicholas.

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.[1][2]

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.

History[edit]

  • 2012: Airtable founded.[3]
  • Feb 2015: Raised $3M from Caffeinated Capital, Freestyle Capital, Data Collective, CrunchFund.[4]
  • April 2015: Airtable launches its API and embedded databases.[5]
  • May 2015: Raised $7.6M funding from Charles River Ventures and Ashton Kutcher.[6]
  • July 2015: Introduced Airtable Forms to collect and organize data.[7]
  • August 2015: Airtable made "Add to Slack" option available to integrate Airtable with Slack.[8]
  • December 2015: Airtable redesigned its iOS app.[9]
  • December 2015: Airtable introduced barcode as new field type.[10]
  • March 2018: Raised $52 million in Series B funding; announced the launch of Airtable Blocks[11]

Basic components[edit]

An example table in a restaurant Base

Airtable has six basic components:[12]

  1. Bases: All the information needed to create a project is contained in a Base. Bases can be built from existing templates provided by Airtable. In addition, they can also be built from scratch, from a spreadsheet or from an existing Base.
  2. Tables: A table is similar to a spreadsheet. A Base is a collection of tables.
  3. Views: Views show the result sets of data queries and can be saved for future purposes.
  4. Fields: Each entry in a Table is a field. They are not just restricted to hold text. Airtable currently offers 16 basic field types.[13] 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.[14]
  5. Records: Each row of a Table is a Record.
  6. Workspaces: A workspace is a collection of Bases in Airtable.

Key Features[edit]

Linking between tables[edit]

To avoid the need to form a single large table when there is related data in multiple tables, Airtables provides an option to link records of different tables. Airtable allows linking existing tables of related records, creating a new linked table and also multiple links between existing tables.[15]

Collaboration[edit]

Airtable allows multiple users to work simultaneously on the same Base allowing more productivity at workplace. A new collaborator is added by clicking share button found at top of Base and providing the email ID of the collaborator. The owner can set the permission level of collaborator while sharing the Base.[16] There are three permission levels in Airtable Base, namely "Creator", "Edit Only" and "Read Only".

If multiple Bases are required then a Team is formed in Airtable.[16] An Airtable Team can hold multiple Bases and collaborators of the Team can work on all the available Bases in the Team. There are four permission levels in Team, unlike for a Base which only has three. The extra permission level in Team is Owner, who has full access to Team Base.

Publishing views[edit]

Bases can be easily shared with public. One need not have an Airtable account to view the published Bases. These view only Bases shared in public are called Airtable views. These views can be embedded into one's own website and allows the website users see the real time information in Base, without needing them to have an Airtable account. One possible use-case is Airtable Form, which can be used to take a survey of a product. The feedback received from a customer can also be shown to public by sharing the Airtable View.

Airtable Forms[edit]

An example Airtable Form.

Airtable introduced Forms in July 2015.[7] Forms could be used to collect data from others like co-workers, customers or the public. A Form can be easily created from an existing Base, and the data collected by the Form is automatically organized in the Airtable Base. Airtable allows user to organize the required fields in the Form. A separate link is created for every Airtable Form. This link can be shared with others to get the required data. An Airtable Form can also be embedded in a website, to get the feedback from the website users.

Airtable integration[edit]

Airtable's API can be used to connect to other web services by which information can be exchanged between external web applications and Airtable. Using the Zapier platform, Airtable can connect to over 450 applications and websites. Changes can be set up as triggers for actions in connected applications.[17]

Airtable can be integrated with other project management tools, including Asana, Basecamp, Trello, Dropbox, Box, Evernote, Slack and many more file management, communication tools.[18]

Snapshot[edit]

Airtable provides a greater sophistication to backup the data than just allow the users to undo/redo. Airtable periodically snapshots the Base. When a previous version of a Base is needed, the appropriate snapshot is selected by the user from the snapshots list. In addition, the user can manually snapshot a Base at any time.

Mobile Access[edit]

Airtable introduced its version 2.0 iOS application on December 2015.[9], allowing users to work on tables from their iPhone. Airtable for Android is also available.[19]

API[edit]

Airtable provides an API to provide ability to users to build application solutions fitting their exact problems. A key which is present at overview section is necessary to use Airtable's API. The key should be kept secret. The API follows REST semantics, uses JSON to encode objects, and uses standard HTTP codes to signal operation outcomes.[20]

Initially, the user has to create a Base in Airtable. Then, Airtable's API can be used to create, update, read or delete records. As of 2016, Airtable's API does not allow users to create or modify the Base schema.

Security[edit]

Airtable uses 256 bit Advanced Encryption Standard (AES) to protect the data. It also uses 256-bit SSL/TLS encryption in data transit.[21]

See also[edit]

References[edit]

  1. ^ "Airtable review: A drop-dead easy relational database management system". Macworld. Retrieved 2017-01-26.
  2. ^ Martin, James A. "3 ways Airtable for iOS can help you ditch spreadsheets". CIO. Retrieved 2017-01-26.
  3. ^ "Airtable | CrunchBase". www.crunchbase.com. Retrieved 2016-02-08.
  4. ^ Lawler, Ryan; Contributor. "With $3M in Funding, Airtable Makes Complex Databases Usable on Your Mobile Phone". TechCrunch. Retrieved 2016-02-06.
  5. ^ Russell, Kyle. "Airtable Launches Its API And Embedded Databases". TechCrunch. Retrieved 2016-02-06.
  6. ^ "Airtable lands $7.6M round to help build simple, extensible database apps". VentureBeat. Retrieved 2016-02-06.
  7. ^ a b "Create Forms in a Snap!". Covering Bases. Retrieved 2016-02-06.
  8. ^ "Airtable and Slack: Keeping Your Team In Sync". Covering Bases. Retrieved 2016-02-06.
  9. ^ a b "Airtable Introduces Newly Redesigned iOS App to Make Database Creation Available to Anyone With an iPhone". Marketwire. Retrieved 2016-02-06.
  10. ^ "A Brief History of Barcodes". Covering Bases. Retrieved 2016-02-06.
  11. ^ "Airtable Raises $52 Million and Launches Airtable Blocks..." BusinessWire. 15 March 2018. Retrieved 16 March 2018.
  12. ^ "An Introduction to Databases – Airtable Guide". Airtable Guide. Retrieved 2016-02-07.
  13. ^ "Setting Up Field Types – Airtable Guide". Airtable Guide. Retrieved 2016-02-06.
  14. ^ "Guide to the basic field types". Airtable – Support. Retrieved 2016-02-07.
  15. ^ "Linking to another record". Airtable – Support. Retrieved 2016-02-06.
  16. ^ a b "Collaborating with a Team – Airtable Guide". Airtable Guide. Retrieved 2016-02-07.
  17. ^ "Airtable Integrations". Airtable. Retrieved 2016-02-06.
  18. ^ "34 Top Project Management Tools to Drive Your Business". Biz 3.0. Retrieved 2018-12-06.
  19. ^ "Here's how to use Airtable, the user-friendly spreadsheet app that's taking Silicon Valley by storm". Business Insider. Retrieved 2018-08-08.
  20. ^ "Airtable – API". airtable.com. Retrieved 2016-02-15.
  21. ^ "Airtable security practices". Airtable – Support. Retrieved 2016-02-06.