Tables (Google)

Last updated
Tables
Developer(s) Google LLC
Initial releaseSeptember 22, 2020;3 years ago (2020-09-22)
Written in JavaScript
Type
Website tables.area120.google.com

Tables is a collaborative database program developed out of Google's Area 120 incubator. [1] Tables is available as a web application. The app allows users to collaborate in real-time to track work more efficiently using automation. [2]

Contents

History

Tables originated as an experiment within Google's Area 120 product incubator, and launched to a public beta in the United States on September 22, 2020. [3] [4] [5] [6] It was first released as a test for a limited number of early testers on March 5, 2020, and then expanded to a larger early access program on May 5, 2020. [7] Tables is not part of the Google Drive or Google Workspace service.

In June of 2021, it was announced that the Area 120 experiment was a success and that Google Cloud "has committed to investing in this product area long-term". [8]

In June of 2023, features available in Tables became generally available in AppSheet as databases. [9] AppSheet Database offers similar features and interface to Tables but integrates with the broader AppSheet platform. [10]

As of December 2023, Tables no longer allows new users to enroll in the beta. [9] The developers continue to maintain the current beta version of Tables for existing users, but do not plan on adding new functionality. Users interested in using Tables should consider alternative services like AppSheet Database or Google Sheets to manage their workflow.

Platforms

Tables is available as a web application supported on the Google Chrome, Microsoft Edge, Apple Safari, and Mozilla Firefox web browsers.

Key Features

Core concepts

Tables anchors around several core concepts: [11]

Data types [15]

Tables allow users to set specific data types for columns:

Linked dataConnect related data from other tables together.
Simple dataText, numbers, dates
Rich dataPeople, file attachments, locations
Rich entryDropdowns, tags, checkboxes, checklists
CalculatedAutomatic ID numbers
MetadataRow creator, updater, create/update time

Integrations

Collaboration and revision history

Tables allows users to collaborate in real-time on records in a table. Tables can be shared, opened, and edited by multiple users simultaneously and users are able to see field-by-field changes as collaborators make edits. All changes to table records are automatically saved to Google's servers, and a change history for records are automatically kept so past edits may be viewed and reverted to. Deleted rows, columns, tables, and workspaces can also be restored within a given timeframe.

Sharing and access control [18]

Users can share their tables and workspaces from Tables using similar permissioning roles as Google Drive, such as editors, commenters, and viewers. Tables also supports an additional "writer" role that allows users to modify rows in the table, but not the table or columns.

Users can share tables and workspaces with other individual Google users, Google Groups, or with their entire work domain.

Tables and workspaces can be shared independently of each other, and you can restrict access to a table within a workspace to provide more granular control of which users can see which data.

Related Research Articles

A collaborative real-time editor is a type of collaborative software or web application which enables real-time collaborative editing, simultaneous editing, or live editing of the same digital document, computer file or cloud-stored data – such as an online spreadsheet, word processing document, database or presentation – at the same time by different users on different computers or mobile devices, with automatic and nearly instantaneous merging of their edits.

Google Workspace is a collection of cloud computing, productivity and collaboration tools, software and products developed and marketed by Google. It consists of Gmail, Contacts, Calendar, Meet and Chat for communication; Currents for employee engagement; Drive for storage; and the Google Docs Editors suite for content creation. An Admin Panel is provided for managing users and services. Depending on edition Google Workspace may also include the digital interactive whiteboard Jamboard and an option to purchase add-ons such as the telephony service Voice. The education edition adds a learning platform Google Classroom and today has the name Workspace for Education.

Wrike, Inc. is an American project management application service provider based in San Jose, California. Wrike also has offices in Dallas, Tallinn, Nicosia, Dublin, Tokyo, Melbourne and Prague.

This is a comparison of online backup services.

<span class="mw-page-title-main">Google Fusion Tables</span> Data management web service

Google Fusion Tables was a web service provided by Google for data management. Fusion tables was used for gathering, visualising and sharing data tables. Data are stored in multiple tables that Internet users can view and download.

<span class="mw-page-title-main">Google Apps Script</span> Scripting platform developed by Google

Google Apps Script is a scripting platform developed by Google for light-weight application development in the Google Workspace platform. Google Apps Script was initially developed by Mike Harm as a side project while working as a developer on Google Sheets.

Google Drive is a file storage and synchronization service developed by Google. Launched on April 24, 2012, Google Drive allows users to store files in the cloud, synchronize files across devices, and share files. In addition to a web interface, Google Drive offers apps with offline capabilities for Windows and macOS computers, and Android and iOS smartphones and tablets. Google Drive encompasses Google Docs, Google Sheets, and Google Slides, which are a part of the Google Docs Editors office suite that permits collaborative editing of documents, spreadsheets, presentations, drawings, forms, and more. Files created and edited through the Google Docs suite are saved in Google Drive.

Google APIs are application programming interfaces (APIs) developed by Google which allow communication with Google Services and their integration to other services. Examples of these include Search, Gmail, Translate or Google Maps. Third-party apps can use these APIs to take advantage of or extend the functionality of the existing services.

<span class="mw-page-title-main">Google Slides</span> Cloud-based presentation software

Google Slides is a presentation program included as part of the free, web-based Google Docs suite offered by Google. Google Slides is available as a web application, mobile app for: Android, iOS, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft PowerPoint file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by a user with a revision history presenting changes. An editor's position is highlighted with an editor-specific color and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering and "tasks to other users.

Google Cloud Platform (GCP), offered by Google, is a suite of cloud computing services that provides a series of modular cloud services including computing, data storage, data analytics, and machine learning, alongside a set of management tools. It runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, and Google Docs, according to Verma, et.al. Registration requires a credit card or bank account details.

Google Forms is a survey administration software included as part of the free, web-based Google Docs Editors suite offered by Google. The service also includes Google Docs, Google Sheets, Google Slides, Google Drawings, Google Sites, and Google Keep. Google Forms is only available as a web application. The app allows users to create and edit surveys online while collaborating with other users in real-time. The collected information can be automatically entered into a spreadsheet.

<span class="mw-page-title-main">Google Sheets</span> Cloud-based spreadsheet software

Google Sheets is a spreadsheet application included as part of the free, web-based Google Docs Editors suite offered by Google. Google Sheets is available as a web application; a mobile app for: Android, iOS, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft Excel file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by which user made them, along with a revision history. Where an editor is making changes is highlighted with an editor-specific color and cursor. A permissions system regulates what users can do. Updates have introduced features that use machine learning, including "Explore", which offers answers based on natural language questions in the spreadsheet. Sheets is one of the services provided by Google that also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep.

<span class="mw-page-title-main">Pyrus (software)</span>

Pyrus is a cloud-based workflow automation and document management system developed by Simply Good Software, Inc. Pyrus comes as SaaS and offers a web-based interface to launch workflows, assign tasks, and manage documents. It is a unified corporate communication environment, accessible from any device. Mobile versions are available for all platforms, including iOS, Android, and Android Wear. Users are able to set up and route workflows without coding and IT assistance.

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

Notion is a freemium productivity and note-taking web application developed by Notion Labs Inc. It offers organizational tools including task management, project tracking, to-do lists, and bookmarking. Additional offline features are offered by desktop and mobile applications available for Windows, macOS, Android, and iOS. Users can create custom templates, embed videos and web content, and collaborate with others in real-time.

AppSheet is an application that provides a no-code development platform for application software, which allows users to create mobile, tablet, and web applications using data sources like Google Drive, DropBox, Office 365, and other cloud-based spreadsheet and database platforms. The platform can be utilized for a broad set of business use cases including project management, customer relationship management, field inspections, and personalized reporting.

<span class="mw-page-title-main">Google Chat</span> Enterprise messaging software developed by Google

Google Chat is a communication service developed by Google. Initially designed for teams and business environments, it has since been made available for general consumers. It provides direct messaging, group conversations, and spaces, which allow users to create and assign tasks and share files in a central place in addition to chatting. It can be accessed through its own website and app or through the Gmail website and app.

<span class="mw-page-title-main">Collabora Online</span> Online office suite based on LibreOffice

Collabora Online is an open source online office suite built on LibreOffice Technology, enabling web-based collaborative real-time editing of word processing documents, spreadsheets, presentations, and vector graphics. Optional apps are available for desktops, laptops, tablets, smartphones, and Chromebooks.

Google Docs Editors is a web-based productivity office suite offered by Google within its Google Drive service. The suite includes Google Docs, Google Sheets (spreadsheet), Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep. It used to also include Google Fusion Tables until it was discontinued in 2019.

References

  1. "How to use Google Tables (by Area 120) - Google Tables Help Center". support.google.com. Retrieved 2020-10-07.
  2. Yuen, Carlin. "Tables by Google - Tables helps teams easily track & automate tasks". Product Hunt. Retrieved 2020-10-13.
  3. "Make tracking your work easier than ever with Tables". Google. 2020-09-22. Retrieved 2020-10-07.
  4. "TechCrunch". TechCrunch. 22 September 2020. Retrieved 2020-10-07.
  5. "Google's Area 120 launches Tables, a rules-based automation platform for documents". VentureBeat. 2020-09-22. Retrieved 2020-10-07.
  6. Finnegan, Matthew (2020-09-23). "Google takes on Airtable, Microsoft Lists with Tables work-tracking app". Computerworld. Retrieved 2020-10-07.
  7. "LumApps". www.cloudconnectcommunity.com. Retrieved 2020-10-07.
  8. "Tables Beta Update & FAQ". Tables Help Center. 2021-06-11.
  9. 1 2 "Tables Beta Update & FAQ - Tables Help Center". support.google.com. Retrieved 2024-03-14.
  10. "What is an AppSheet database? - AppSheet Help". support.google.com. Retrieved 2024-03-14.
  11. Collins, Ben (2020-09-23). "Google Tables: How I Use Google's New Workflow Tool" . Retrieved 2020-10-07.
  12. "Google Tables beta the FREE Airtable alternative". Youtube. SaaS Master.
  13. "How do I configure a custom view of my table? - Google Tables Help Center". support.google.com. Retrieved 2020-10-07.
  14. "Introducing Google Tables". Youtube. Keep Productive. 2020-09-23.
  15. "What data types does Tables support? - Google Tables Help Center". support.google.com. Retrieved 2020-10-07.
  16. "Can I sync this data with Sheets? (IMPORTDATA) - Google Tables Help Center". support.google.com. Retrieved 2020-10-07.
  17. "Is there a Tables API I can use? - Google Tables Help Center". support.google.com. Retrieved 2020-10-07.
  18. "Sharing - Google Tables Help Center". support.google.com. Retrieved 2020-10-07.