8/28/2021»»Saturday

Airtable Website

8/28/2021
    29 - Comments

Take our free Airtable Crash Course!Stuck? See how we can help!our Ai. Create a website, intranet, client portal and anything else you can imagine with Airtable as your back end. Build massive websites, in minutes. Airconnex lets you build your website from the back end, using a spreadsheet like interface to manage and refine your database directly.

Formagrid, Inc.
Collaborative software
Founded2012
HeadquartersSan Francisco, California, US
Founder(s)
  • Howie Liu
  • Andrew Ofstad
  • Emmett Nicholas
IndustryInternet
URLairtable.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 $3 million from Caffeinated Capital, Freestyle Capital, Data Collective, CrunchFund.[4]
  • April 2015: Airtable launches its API and embedded databases.[5]
  • May 2015: Raised $7.6 million 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]
  • November 2018: Raised $100 million in Series C funding.[12]
  • September 2020: Raised $185 million in Series D funding.[13]
  • March 2021: Raised $270 million in Series E funding.[14]

Airtable Software

Basic components[edit]

An example table in a restaurant Base

Airtable has six basic components:[15]

  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. 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.[16] 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.[17]
  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.[18]

Collaboration[edit]

Airtable

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.[19] 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.[19] 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 the 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.[20]

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.[citation needed]

Mobile apps[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.[21]

API[edit]

Airtable provides an API to provide ability to users to build applications that cannot be built within the table constraints. 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.[22]

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

Security[edit]

It also uses 256-bit SSL/TLS encryption in data transit.[23]

Airtable website reviews

See also[edit]

References[edit]

  1. ^'Airtable review: A drop-dead easy relational database management system'. Macworld. Retrieved January 26, 2017.
  2. ^Martin, James A. '3 ways Airtable for iOS can help you ditch spreadsheets'. CIO. Retrieved January 26, 2017.
  3. ^'Airtable CrunchBase'. www.crunchbase.com. Retrieved February 8, 2016.
  4. ^Lawler, Ryan; Contributor. 'With $3M in Funding, Airtable Makes Complex Databases Usable on Your Mobile Phone'. TechCrunch. Retrieved February 6, 2016.
  5. ^Russell, Kyle. 'Airtable Launches Its API And Embedded Databases'. TechCrunch. Retrieved February 6, 2016.
  6. ^'Airtable lands $7.6M round to help build simple, extensible database apps'. VentureBeat. Retrieved February 6, 2016.
  7. ^ ab'Create Forms in a Snap!'. Covering Bases. Retrieved February 6, 2016.
  8. ^'Airtable and Slack: Keeping Your Team In Sync'. Covering Bases. Retrieved February 6, 2016.
  9. ^ ab'Airtable Introduces Newly Redesigned iOS App to Make Database Creation Available to Anyone With an iPhone'. Marketwire. Retrieved February 6, 2016.
  10. ^'A Brief History of Barcodes'. Covering Bases. Retrieved February 6, 2016.
  11. ^'Airtable Raises $52 Million and Launches Airtable Blocks..'BusinessWire. March 15, 2018. Retrieved March 16, 2018.CS1 maint: discouraged parameter (link)
  12. ^Lunden, Ingrid (November 15, 2018). 'Airtable, maker of a coding platform for non-techies, raises $100M at a $1.1B valuation'. TechCrunch. Archived from the original on April 15, 2019. Retrieved April 15, 2019.
  13. ^'Airtable raises $185M and launches new low-code and automation features'. TechCrunch. Retrieved September 14, 2020.
  14. ^'Cloud-based software company Airtable'. mg21. April 20, 2021.
  15. ^'An Introduction to Databases – Airtable Guide'. Airtable Guide. Retrieved February 7, 2016.
  16. ^'Setting Up Field Types – Airtable Guide'. Airtable Guide. Retrieved February 6, 2016.
  17. ^'Guide to the basic field types'. Airtable – Support. Retrieved February 7, 2016.
  18. ^'Linking to another record'. Airtable – Support. Retrieved February 6, 2016.
  19. ^ ab'Collaborating with a Team – Airtable Guide'. Airtable Guide. Retrieved February 7, 2016.
  20. ^'Airtable Integrations'. Airtable. Retrieved February 6, 2016.
  21. ^'Here's how to use Airtable, the user-friendly spreadsheet app that's taking Silicon Valley by storm'. Business Insider. Retrieved August 8, 2018.
  22. ^'Airtable – API'. airtable.com. Retrieved February 15, 2016.
  23. ^'Airtable security practices'. Airtable – Support. Retrieved February 6, 2016.
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Airtable&oldid=1019273000'

ISO/IEC 27001 certification

ISO/IEC 27001:2013 is a specification for an information security management system (ISMS), which is a framework for an organization's information risk management processes.

SOC 2 compliance

Airtable has undergone a Service Organization Controls audit (SOC 2 type 2). Please contact your account manager or [email protected] to request Airtable's most recent report.

Airtable Website Builder

Privacy compliance and data processing addendum

We take our privacy obligations — and the protection of your information — seriously, and we comply with all applicable privacy laws and regulations.

You can learn more about Airtable’s privacy practices in our Privacy Policy, and learn more about Airtable’s commitment to compliance with the General Data Protection Regulation (“GDPR”) here.

You can sign our Data Processing Addendum by entering your information at this link. You will be able to download and review the DPA before signing it. In addition, you can find a current list of Airtable’s data subprocessors at the end of the DPA and at this link.

At any time, you may export data from Airtable to CSV files or by using the Airtable API.

Network and system security

When you visit the Airtable website or use one of the Airtable apps, the transmission of information between your device and our servers is protected using 256-bit TLS encryption. At rest, Airtable encrypts data using AES-256.

Airtable servers are located in the US, in data centers that are SOC 1, SOC 2 and ISO 27001 certified. Airtable’s data centers have round-the-clock security, automatic fire detection and suppression, fully redundant power systems, and strict controls for physical access.

We regularly install security updates and patches to keep servers up to date. Servers are segmented based on role and protected using restrictive firewalls.

Service reliability and durability

Airtable utilizes industry-leading Amazon Web Services (AWS) hosting infrastructure. Backups are geo-redundantly replicated across multiple availability zones for data durability. Airtable maintains business continuity and disaster recovery plans. Components of the disaster recovery plan include multiple site operations playbooks, which are regularly reviewed and rehearsed. Airtable implements extensive service monitoring, and our operations team is on call 24x7x365.

Product security

Within the Airtable product, collaborator permissions can be managed at the workspace level or the base level. These permissions allow you to control who you share a workspace or base with and whether they can modify the workspaces or bases that you’ve shared with them. Airtable also enables you to restrict access to a base or view share link with a password or with an email domain.

Airtable also provides record-level revision history that shows a visual activity feed of the changes made to each record.

Airtable recommends enabling two-factor authentication (2FA) for your account if you’re using password-based authentication. For more details and instructions to configure 2FA, please see our docs.

Airtable supports SAML-based Single Sign On (SSO) and additional administration features for teams on the Enterprise Plan. Additional information is available here.

Organizational and information security

Airtable vets employees and performs background checks in accordance with local laws. Employees complete annual security training which covers topics such as data privacy, information security, and password security.

On the taskbar, select the Ethernet network icon the Ethernet network connection. Under Ethernet, select the Ethernet network connection. Under Properties, look for your IP address listed next to IPv4 address. Open Wi-Fi setting. My IP - shows your computer IP address, that is seen by web servers and network. IP address is exposed to any network service (web, FTP, etc.). If behind router / firewall, then gateway address is shown. Smart Whois - find out an owner / registrar of an IP address or IP address. My IP address information shows your location; city, region, country, ISP and location on a map. Many proxy servers, VPNs, and Tor exit nodes give themselves away. IP address lookup, location, proxy detection, email tracing, IP hiding tips, blacklist check, speed test, and forums. Ip address lookup. WhatIsMyIP.com® is the industry leader in providing IP address information. Moreover, we provide tools that allow users to perform an Internet Speed Test, Location Lookup, Proxy Detection, Whois Lookup, and more. Extensive tutorials that show users how to trace an email address are also available. Furthermore, knowing your IP address is crucial for online gaming, using remote.

Table2site

Employee workstations are configured with full-disk encryption, strong passwords, and automatic locking. Employees are prohibited from installing unauthorized software or using portable media.

Airtable Website

Airtable maintains separate production and testing environments.

Airtable operates a “bug bounty” program to work with the security community in identifying potential issues.

Application security

Airtable runs automated application-level security scans on a daily basis, package dependency security advisory scans on a weekly basis, and endpoint scans on a monthly basis. In addition to internal scans, Airtable commissions external penetration tests on a regular basis.

As part of the software development process, code and configuration changes are thoroughly reviewed. Before being deployed, these changes are tested during the quality assurance process to help ensure a consistent experience across all devices, platforms, and browsers that are supported by Airtable.

How to report an issue

Table2site

If you believe you've discovered a security-related issue, please report the issue on our HackerOne bug bounty program or contact us at [email protected]