Software:Tables (Google)

From HandWiki
Short description: Cloud-based collaborative database software
Tables
Google Tables Logo.png
Developer(s)Google LLC
Initial releaseSeptember 22, 2020; 3 years ago (2020-09-22)
Written inJavaScript
Type
Websitetables.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]

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]

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:[9]

  • Tables: containers of rows and columns of structured data. Columns (aka "fields") define the table structure and enforce data type/format and relationships.
  • Workspaces: allow users to group tables together in a tabbed interface. Tables can be in more than one workspace.
  • Views: allow users to create customized views of the data with different layouts, groupings, and filters/sorts applied. Layouts allow you to switch between different ways to visualize the table records, such as a ticket queue, kanban board, or map.[10][11]
  • Forms: allow users to collect input without giving access to the table. Tables forms are separate from Google Forms.
  • Bots: allow users to automate tasks, such as send emails, update data, or send weekly reports, and send data to 3rd party webhooks to trigger Google Chat or Slack notifications or Zapier workflows.[12]

Data types[13]

Tables allow users to set specific data types for columns:

Linked data Connect related data from other tables together.
Simple data Text, numbers, dates
Rich data People, file attachments, locations
Rich entry Dropdowns, tags, checkboxes, checklists
Calculated Automatic ID numbers
Metadata Row creator, updater, create/update time

Integrations

  • Tables allows users to import data directly from a Google Sheet or CSV file, and also performs a one-way recurring sync of data from a table into Google Sheets.[14]
  • Person-type columns in Tables allow the user to search for and select Google users from your Gmail contacts.
  • Sharing in Tables allows the user to share with existing Google users, Google Groups, or with their entire work domain.
  • Tables also offers a public API[15] and the ability to call the Tables API via Apps Script.

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[16]

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.

References

  1. "How to use Google Tables (by Area 120) - Google Tables Help Center". https://support.google.com/area120-tables/answer/9902872. 
  2. Yuen, Carlin. "Tables by Google - Tables helps teams easily track & automate tasks" (in en). https://www.producthunt.com/posts/tables-by-google. 
  3. "Make tracking your work easier than ever with Tables" (in en). 2020-09-22. https://blog.google/technology/area-120/tables/. 
  4. "TechCrunch" (in en-US). 22 September 2020. https://social.techcrunch.com/2020/09/22/google-launches-a-work-tracking-tool-and-airtable-rival-tables/. 
  5. "Google's Area 120 launches Tables, a rules-based automation platform for documents" (in en-US). 2020-09-22. https://venturebeat.com/2020/09/22/googles-area-120-launches-tables-a-rules-based-automation-platform-for-documents/. 
  6. Finnegan, Matthew (2020-09-23). "Google takes on Airtable, Microsoft Lists with Tables work-tracking app" (in en). https://www.computerworld.com/article/3576291/google-takes-on-airtable-microsoft-lists-with-tables-work-tracking-app.html. 
  7. "LumApps". https://www.cloudconnectcommunity.com/a/cloudconnectcommunity/ccc/login?r=%2Fccc%2Fhelp-make-google-cloud-better-surveys%2Falpha-testing-survey&error=NEED_LOGIN. 
  8. "Tables Beta Update & FAQ" (in en-US). 2021-06-11. https://support.google.com/area120-tables/answer/10831919. 
  9. Collins, Ben (2020-09-23). "Google Tables: How I Use Google's New Workflow Tool" (in en). https://www.benlcollins.com/tables/google-tables/. 
  10. "Google Tables beta the FREE Airtable alternative". SaaS Master. https://www.youtube.com/watch?v=Y8h90nxjXWg. 
  11. "How do I configure a custom view of my table? - Google Tables Help Center". https://support.google.com/area120-tables/answer/9903078?hl=en&ref_topic=9901548. 
  12. "Introducing Google Tables". Keep Productive. 2020-09-23. https://www.youtube.com/watch?v=EPs6BhLav94. 
  13. "What data types does Tables support? - Google Tables Help Center". https://support.google.com/area120-tables/answer/9904372?hl=en&ref_topic=9901548. 
  14. "Can I sync this data with Sheets? (IMPORTDATA) - Google Tables Help Center". https://support.google.com/area120-tables/answer/9904107?hl=en&ref_topic=9901548. 
  15. "Is there a Tables API I can use? - Google Tables Help Center". https://support.google.com/area120-tables/answer/10011390?hl=en&ref_topic=10081846. 
  16. "Sharing - Google Tables Help Center". https://support.google.com/area120-tables/topic/10011299?hl=en&ref_topic=9934691,9904104,. 

External links