Type of site | Cloud collaboration service |
---|---|
Founded | 2012 |
Headquarters | San Francisco, California |
Founder(s) | Howie Liu,Andrew Ofstad,Emmett Nicholas |
Industry | Internet |
URL |
airtable |
Registration | Required |
Current status | Active |
Airtable is a cloud collaboration service headquartered in San Francisco. It was founded in 2012 by Howie Liu, Andrew Ofstad, and Emmett Nicholas. It aims to improve productivity and organizing data.
Airtable is a spreadsheet-database hybrid i.e., the features of a database are applied to a spreadsheet. The fields in an Airtable table are similar to a cell of a spreadsheet but have the power to do lot more than just hold text. The fields can have file attachments like images, check-boxes, phone numbers, drop-down lists, etc.
After registering to use the site, users can create a database, set up field types, add records, link tables, collaborate with a team, sort the records based on a field and publish views to external websites. When an Airtable database is created, it is automatically hosted to the cloud [1]. The values in the fields are updated real time.
Airtable has five basic components [10]:
For example, in the adjacent restaurant template which contains all the information we need to store about the restaurants. We can have a ‘Restaurants’ table to store the names of restaurants along with information about their addresses, ratings, menus, etc. We can have a view to show our favourite restaurants. Each record in the Restaurants table is kept for a particular restaurant. ‘Rating’ can be kept as a field, to help generate ‘My favourite restaurants’ view.
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 us to link existing tables of related records, create a new linked table and also to create multiple links between existing tables. [13]
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 [14]. There are three permission levels in Airtable Base. They are:
Creator: Creator level lets the user have full access of the Base. The creator can manage collaborators and even can delete the Base.
Edit Only: Edit Only level lets the collaborator modify the records but cannot change the field type of the columns.
Read Only: By Read Only level permission, the user can only view the Base and its content but cannot add or change any record.
If multiple Bases are required then a Team is formed in Airtable [14]. 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.
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 ones 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 introduced Forms in July 2015. [15] 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's API can be used to connect to other web services by which information can be exchanged between external web applications and Airtable. Using Zapier platform, Airtable can be made to connect over 450 applications and websites. First the user should have an account with Zapier. Then API key of Airtable and API key of other web service is provided to Zapier account. For example, if you want to manage job postings using Airtable and Slack, both these apps should be registered in Zapier, and then Airtable is configured as a trigger app unlike Slack, which is configured as an action app. Suppose if we require that adding a job posting as a record in Airtable to create a posting in Slack, then a trigger in Zapier account is configured to detect an addition of record in Airtable and post the relevant job in Slack. [16]
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 anytime.
Airtable introduced its version 2.0 iOS application on December 2015. [8] This allows the users to work on the entire database creation just using their iPhone. Mobile access and API features from Airtable will enable enthusiast application developers to develop more mobile applications based on Airtable. A beta version of Airtable application for Android platform is available for public. [17]
Airtable provides 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 secretive. The API follows REST semantics, uses JSON to encode objects, and uses standard HTTP codes to signal operation outcomes. [17]
Initially, the user has to create a Base in Airtable. Then, Airtable's API can be used to create, update, read or delete records. At present, Airtable's API does not allow users to create or modify the Base schema. These features will be made available in Airtable's Metadata API which is stated to be released soon. [18]
Airtable uses 256 bit Advanced Encryption Standard (AES) to protect the data. It also uses 256-bit SSL/TLS encryption in data transportation. [19]
The main competitors of Airtable are Google Docs and Microsoft Excel. Compared to its competitors, Airtable has advanced UI and a mobile version with good user experience. Mircrosoft Excel could be preferred if there are lots of computations and cell manipulations. Using simple spreadsheets would not be scalable, and could be difficult to collaborate and share. [20]
{{
cite web}}
: |last2=
has generic name (
help)
Type of site | Cloud collaboration service |
---|---|
Founded | 2012 |
Headquarters | San Francisco, California |
Founder(s) | Howie Liu,Andrew Ofstad,Emmett Nicholas |
Industry | Internet |
URL |
airtable |
Registration | Required |
Current status | Active |
Airtable is a cloud collaboration service headquartered in San Francisco. It was founded in 2012 by Howie Liu, Andrew Ofstad, and Emmett Nicholas. It aims to improve productivity and organizing data.
Airtable is a spreadsheet-database hybrid i.e., the features of a database are applied to a spreadsheet. The fields in an Airtable table are similar to a cell of a spreadsheet but have the power to do lot more than just hold text. The fields can have file attachments like images, check-boxes, phone numbers, drop-down lists, etc.
After registering to use the site, users can create a database, set up field types, add records, link tables, collaborate with a team, sort the records based on a field and publish views to external websites. When an Airtable database is created, it is automatically hosted to the cloud [1]. The values in the fields are updated real time.
Airtable has five basic components [10]:
For example, in the adjacent restaurant template which contains all the information we need to store about the restaurants. We can have a ‘Restaurants’ table to store the names of restaurants along with information about their addresses, ratings, menus, etc. We can have a view to show our favourite restaurants. Each record in the Restaurants table is kept for a particular restaurant. ‘Rating’ can be kept as a field, to help generate ‘My favourite restaurants’ view.
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 us to link existing tables of related records, create a new linked table and also to create multiple links between existing tables. [13]
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 [14]. There are three permission levels in Airtable Base. They are:
Creator: Creator level lets the user have full access of the Base. The creator can manage collaborators and even can delete the Base.
Edit Only: Edit Only level lets the collaborator modify the records but cannot change the field type of the columns.
Read Only: By Read Only level permission, the user can only view the Base and its content but cannot add or change any record.
If multiple Bases are required then a Team is formed in Airtable [14]. 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.
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 ones 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 introduced Forms in July 2015. [15] 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's API can be used to connect to other web services by which information can be exchanged between external web applications and Airtable. Using Zapier platform, Airtable can be made to connect over 450 applications and websites. First the user should have an account with Zapier. Then API key of Airtable and API key of other web service is provided to Zapier account. For example, if you want to manage job postings using Airtable and Slack, both these apps should be registered in Zapier, and then Airtable is configured as a trigger app unlike Slack, which is configured as an action app. Suppose if we require that adding a job posting as a record in Airtable to create a posting in Slack, then a trigger in Zapier account is configured to detect an addition of record in Airtable and post the relevant job in Slack. [16]
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 anytime.
Airtable introduced its version 2.0 iOS application on December 2015. [8] This allows the users to work on the entire database creation just using their iPhone. Mobile access and API features from Airtable will enable enthusiast application developers to develop more mobile applications based on Airtable. A beta version of Airtable application for Android platform is available for public. [17]
Airtable provides 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 secretive. The API follows REST semantics, uses JSON to encode objects, and uses standard HTTP codes to signal operation outcomes. [17]
Initially, the user has to create a Base in Airtable. Then, Airtable's API can be used to create, update, read or delete records. At present, Airtable's API does not allow users to create or modify the Base schema. These features will be made available in Airtable's Metadata API which is stated to be released soon. [18]
Airtable uses 256 bit Advanced Encryption Standard (AES) to protect the data. It also uses 256-bit SSL/TLS encryption in data transportation. [19]
The main competitors of Airtable are Google Docs and Microsoft Excel. Compared to its competitors, Airtable has advanced UI and a mobile version with good user experience. Mircrosoft Excel could be preferred if there are lots of computations and cell manipulations. Using simple spreadsheets would not be scalable, and could be difficult to collaborate and share. [20]
{{
cite web}}
: |last2=
has generic name (
help)