Jump to content

Tables (Google): Difference between revisions

From Wikipedia, the free encyclopedia
Content deleted Content added
Declining submission: nn - Submission is about a topic not yet shown to meet general notability guidelines (be more specific if possible) (AFCH 0.9.1)
m v2.05b - Bot T20 CW#61 - Fix errors for CW project (Reference before punctuation)
 
(22 intermediate revisions by 11 users not shown)
Line 1: Line 1:
{{AFC submission|d|nn|u=Carlinyuen|ns=118|decliner=Salimfadhley|declinets=20201007132802|ts=20201007031632}} <!-- Do not remove this line! -->

{{AFC comment|1=This subject is probably notable, but the article makes excessive use of primary sources. Please rewrite the article so that it is a summary of what secondary sources say. [[User:Salimfadhley|Salimfadhley]] ([[User talk:Salimfadhley|talk]]) 13:28, 7 October 2020 (UTC)}}

----

{{short description|Cloud-based collaborative database software}}
{{short description|Cloud-based collaborative database software}}


{{More citations needed|date=December 2020}}
{{Infobox software
{{Infobox software
| title = Google Tables by Area 120
| name = Tables
| logo = Google_Tables_Logo.png
| name = Google Tables
| logo = Google_Tables_Logo.png
| logo caption =
| screenshot =
| logo caption =
| caption =
| screenshot = Google_Tables_screenshot.png
| author =
| caption = An example of a Google Tables workspace
| developer = [[Google|Google LLC]]
| author =
| released = {{start date and age|2020|9|22}}
| developer = [[Google|Google LLC]]
| ver layout = stacked
| released = {{start date and age|2020|9|22}}
| programming language = [[JavaScript]]
| ver layout = stacked
| genre = {{Plainlist | *[[Collaborative software]]}}
| programming language = [[JavaScript]]
| website = {{URL|https://tables.area120.google.com}}
| genre = {{Plainlist | *[[Collaborative software]]}}
| website = {{URL|https://tables.area120.google.com/about/|Google Tables}}
}}
}}
'''Google Tables'''.<ref>{{Cite web|title=Google Tables by Area 120|url=https://tables.area120.google.com/about|access-date=2020-10-07|website=tables.area120.google.com}}</ref> is a collaborative database program developed out of [[Google|Google's]] [https://area120.google.com/ Area 120] incubator<ref>{{Cite web|title=How to use Google Tables (by Area 120) - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9902872|access-date=2020-10-07|website=support.google.com}}</ref>. Google Tables is available as a [[web application]]. The app allows users to collaborate in real-time to track work and automate tasks without deep coding expertise.
'''Tables''' is a collaborative database program developed out of [[Google]]'s [[Area 120]] incubator.<ref>{{Cite web|title=How to use Google Tables (by Area 120) - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9902872|access-date=2020-10-07|website=support.google.com}}</ref> Tables is available as a [[web application]]. The app allows users to collaborate in real-time to track work more efficiently using automation.<ref>{{Cite web|last=Yuen|first=Carlin|title=Tables by Google - Tables helps teams easily track & automate tasks|url=https://www.producthunt.com/posts/tables-by-google|access-date=2020-10-13|website=Product Hunt|language=en}}</ref>


== History ==
== History ==
Google Tables originated as an experiment within [[Google|Google's]] [https://area120.google.com/ Area 120] product incubator, and launched to a public beta in the [[United States]] on September 22nd, 2020<ref>{{Cite web|date=2020-09-22|title=Make tracking your work easier than ever with Tables|url=https://blog.google/technology/area-120/tables/|access-date=2020-10-07|website=Google|language=en}}</ref><ref>{{Cite web|title=TechCrunch|url=https://social.techcrunch.com/2020/09/22/google-launches-a-work-tracking-tool-and-airtable-rival-tables/|access-date=2020-10-07|website=TechCrunch|language=en-US}}</ref><ref>{{Cite web|date=2020-09-22|title=Google’s Area 120 launches Tables, a rules-based automation platform for documents|url=https://venturebeat.com/2020/09/22/googles-area-120-launches-tables-a-rules-based-automation-platform-for-documents/|access-date=2020-10-07|website=VentureBeat|language=en-US}}</ref><ref>{{Cite web|last=Finnegan|first=Matthew|date=2020-09-23|title=Google takes on Airtable, Microsoft Lists with Tables work-tracking app|url=https://www.computerworld.com/article/3576291/google-takes-on-airtable-microsoft-lists-with-tables-work-tracking-app.html|access-date=2020-10-07|website=Computerworld|language=en}}</ref>. It was first released as a test for a limited number of early testers on March 5th, 2020, and then expanded to a larger early access program on May 5th, 2020<ref>{{Cite web|title=LumApps|url=https://www.cloudconnectcommunity.com/a/cloudconnectcommunity/ccc/login?r=%2Fccc%2Fhelp-make-google-cloud-better-surveys%2Falpha-testing-survey&error=NEED_LOGIN|access-date=2020-10-07|website=www.cloudconnectcommunity.com}}</ref>. Google Tables is not part of the [[Google Drive]] or [[Google Workspace]] service.
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.<ref>{{Cite web|date=2020-09-22|title=Make tracking your work easier than ever with Tables|url=https://blog.google/technology/area-120/tables/|access-date=2020-10-07|website=Google|language=en}}</ref><ref>{{Cite web|title=TechCrunch|url=https://social.techcrunch.com/2020/09/22/google-launches-a-work-tracking-tool-and-airtable-rival-tables/|access-date=2020-10-07|website=TechCrunch|date=22 September 2020 |language=en-US}}</ref><ref>{{Cite web|date=2020-09-22|title=Google's Area 120 launches Tables, a rules-based automation platform for documents|url=https://venturebeat.com/2020/09/22/googles-area-120-launches-tables-a-rules-based-automation-platform-for-documents/|access-date=2020-10-07|website=VentureBeat|language=en-US}}</ref><ref>{{Cite web|last=Finnegan|first=Matthew|date=2020-09-23|title=Google takes on Airtable, Microsoft Lists with Tables work-tracking app|url=https://www.computerworld.com/article/3576291/google-takes-on-airtable-microsoft-lists-with-tables-work-tracking-app.html|access-date=2020-10-07|website=Computerworld|language=en}}</ref> 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.<ref>{{Cite web|title=LumApps|url=https://www.cloudconnectcommunity.com/a/cloudconnectcommunity/ccc/login?r=%2Fccc%2Fhelp-make-google-cloud-better-surveys%2Falpha-testing-survey&error=NEED_LOGIN|access-date=2020-10-07|website=www.cloudconnectcommunity.com}}</ref> 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".<ref>{{Cite web|url=https://support.google.com/area120-tables/answer/10831919|language=en-US|title=Tables Beta Update & FAQ|date=2021-06-11|website=Tables Help Center}}</ref>

In June of 2023, features available in Tables became generally available in [[AppSheet]] as databases.<ref name=":0">{{Cite web |title=Tables Beta Update & FAQ - Tables Help Center |url=https://support.google.com/area120-tables/answer/10831919 |access-date=2024-03-14 |website=support.google.com}}</ref> [[AppSheet Database]] offers similar features and interface to Tables but integrates with the broader AppSheet platform.<ref>{{Cite web |title=What is an AppSheet database? - AppSheet Help |url=https://support.google.com/appsheet/answer/12631542?hl=en&ref_topic=12632222&sjid=11791367478452100432-NC |access-date=2024-03-14 |website=support.google.com}}</ref>

As of December 2023, Tables no longer allows new users to enroll in the beta.<ref name=":0" /> 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 ==
== Platforms ==
Google Tables is available as a [[web application]] supported on Google Chrome, Microsoft Edge, Apple Safari, and Mozilla Firefox web browsers.
Tables is available as a [[web application]] supported on the [[Google Chrome]], [[Microsoft Edge]], [[Apple Safari]], and [[Mozilla Firefox]] web browsers.


== Key Features ==
== Key Features ==


=== Core concepts ===
=== Core concepts ===
Google Tables anchors around several core concepts'''<ref name=":0">{{Cite web|title=What’s the difference between tables, workspaces, and views? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9903077?hl=en&ref_topic=9904105|access-date=2020-10-07|website=support.google.com}}</ref>'''<ref>{{Cite web|last=Ben|first=Author|date=2020-09-23|title=Google Tables: How I Use Google’s New Workflow Tool|url=https://www.benlcollins.com/tables/google-tables/|access-date=2020-10-07|language=en}}</ref>:
Tables anchors around several core concepts:<ref>{{Cite web |last=Collins |first=Ben |date=2020-09-23 |title=Google Tables: How I Use Google's New Workflow Tool |url=https://www.benlcollins.com/tables/google-tables/ |access-date=2020-10-07 |language=en}}</ref>


* '''Tables:''' containers for a list of structured data. Each table has an ordered list of rows (aka records), which contain all the data. Tables also have a set of columns (aka fields), which define the table “schema” and enforce data type/format and relationships on the row data.
* '''Tables''': containers of rows and columns of structured data. Columns (aka "fields") define the table structure and enforce data type/format and relationships.
* '''Workspaces:''' a way to group tables together. Opening a workspace opens its tables in a tabbed view. Tables can be in more than one workspace, and tables can also exist as standalone items without a workspace.
* '''Workspaces''': allow users to group tables together in a tabbed interface. Tables can be in more than one workspace.
* '''Views:''' a way to define a customized view of a table’s data. Views are part of a table and you can configure and save multiple views of a table, which can have 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<ref>{{Cite web|title=How do I configure a custom view of my table? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9903078?hl=en&ref_topic=9901548|access-date=2020-10-07|website=support.google.com}}</ref>.
* '''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.<ref>{{Cite web|last=|first=|date=|title=Google Tables beta the FREE Airtable alternative|url=https://www.youtube.com/watch?v=Y8h90nxjXWg|archive-url=|archive-date=|access-date=|website=Youtube|publisher=SaaS Master}}</ref><ref>{{Cite web|title=How do I configure a custom view of my table? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9903078?hl=en&ref_topic=9901548|access-date=2020-10-07|website=support.google.com}}</ref>
* '''Forms''': allow users to collect input without giving access to the table. Tables forms are separate from [[Google Forms]].
* '''Forms'''<ref>{{Cite web|title=How to use Forms - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/10011562?hl=en&ref_topic=10011704|access-date=2020-10-07|website=support.google.com}}</ref>''':''' a way to collect input from people without giving them access to your table. A form is created and owned by a table, and a table can have multiple forms, to allow for use cases like having different forms for different audiences or in different languages. Tables has its own type of form that is separate from [[Google Forms]].
* '''Bots'''<ref>{{Cite web|title=How to use Bots - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/10011787?hl=en&ref_topic=10011707|access-date=2020-10-07|website=support.google.com}}</ref>''':''' a way to define automated triggers and actions with no code to do things like automate email notifications, data updates, and data hand-offs in your table. Users can use bots to send data to 3rd party [[Webhook|webhooks]], to trigger [[Google Chat]] or [[Slack (software)|Slack]] channel notifications or [[Zapier]] workflows.
* '''Bots''': allow users to automate tasks, such as send emails, update data, or send weekly reports, and send data to 3rd party [[webhook]]s to trigger [[Google Chat]] or [[Slack (software)|Slack]] notifications or [[Zapier]] workflows.<ref>{{Cite web|last=|first=|date=2020-09-23|title=Introducing Google Tables|url=https://www.youtube.com/watch?v=EPs6BhLav94|archive-url=|archive-date=|access-date=|website=Youtube|publisher=Keep Productive}}</ref>


=== Data types<ref>{{Cite web|title=What data types does Tables support? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9904372?hl=en&ref_topic=9901548|access-date=2020-10-07|website=support.google.com}}</ref> ===
=== Data types<ref>{{Cite web|title=What data types does Tables support? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9904372?hl=en&ref_topic=9901548|access-date=2020-10-07|website=support.google.com}}</ref> ===
Google Tables allow users to define rich data types for fields for each record in a table:
Tables allow users to set specific data types for columns:
{| class="wikitable"
{| class="wikitable"
|'''Linked data'''
|'''Linked data'''
Line 61: Line 61:
|'''Metadata'''
|'''Metadata'''
|Row creator, updater, create/update time
|Row creator, updater, create/update time
|-
|'''Smart data'''
|Sentiment prediction, language detection (alpha access only)
|}
|}


=== Integrations ===
=== 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]].<ref>{{Cite web|title=Can I sync this data with Sheets? (IMPORTDATA) - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9904107?hl=en&ref_topic=9901548|access-date=2020-10-07|website=support.google.com}}</ref>

* Tables allows users to import data directly from a Google Sheet or CSV file<ref>{{Cite web|title=How do I import from Sheets? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9904106?hl=en&ref_topic=9901548|access-date=2020-10-07|website=support.google.com}}</ref>, and also perform a one-way recurring sync of data from a table into Google Sheets<ref>{{Cite web|title=Can I sync this data with Sheets? (IMPORTDATA) - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/9904107?hl=en&ref_topic=9901548|access-date=2020-10-07|website=support.google.com}}</ref>.
* Person-type columns in Tables allow the user to search for and select Google users from your [[Gmail]] contacts.
* 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.
* 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<ref>{{Cite web|title=Is there a Tables API I can use? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/10011390?hl=en&ref_topic=10081846|access-date=2020-10-07|website=support.google.com}}</ref> and the ability to call the Tables API via Apps Script<ref>{{Cite web|title=Can I use Apps Script with Tables? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/10011387|access-date=2020-10-07|website=support.google.com}}</ref>.
* Tables also offers a public API<ref>{{Cite web|title=Is there a Tables API I can use? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/10011390?hl=en&ref_topic=10081846|access-date=2020-10-07|website=support.google.com}}</ref> and the ability to call the Tables API via Apps Script.


=== Collaboration and revision history ===
=== Collaboration and revision history ===
Google 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.
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<ref>{{Cite web|last=|first=|date=|title=Sharing - Google Tables Help Center|url=https://support.google.com/area120-tables/topic/10011299?hl=en&ref_topic=9934691,9904104,|url-status=live|archive-url=|archive-date=|access-date=2020-10-07|website=support.google.com}}</ref> ===
=== Sharing and access control<ref>{{Cite web|last=|first=|date=|title=Sharing - Google Tables Help Center|url=https://support.google.com/area120-tables/topic/10011299?hl=en&ref_topic=9934691,9904104,|archive-url=|archive-date=|access-date=2020-10-07|website=support.google.com}}</ref> ===
Users can share their tables and workspaces from Google Tables using a similar permissioning roles as [[Google Drive]], such as editors, commenters, and viewers. Tables also supports an additional "writer" role that allows users to modify data in the table, but not the actual table schema or column definition itself<ref>{{Cite web|title=What levels of sharing and permissioning can I give others? - Google Tables Help Center|url=https://support.google.com/area120-tables/answer/10011392?hl=en&ref_topic=10011299|access-date=2020-10-07|website=support.google.com}}</ref>
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.
Users can share tables and workspaces with other individual Google users, [[Google Groups]], or with their entire work domain.
Line 89: Line 85:
== External links ==
== External links ==


* [https://tables.area120.google.com/about Official website]
* {{Official website|https://tables.area120.google.com/about}}
* [https://support.google.com/area120-tables/#topic=9904105 Official help center]

{{Google LLC}}
{{Google LLC}}

__FORCETOC__
[[:Category:Collaborative software]]
[[Category:Collaborative software]]
[[Category:Google software]]
__INDEX__
__NONEWSECTIONLINK__

Latest revision as of 10:32, 19 March 2024

Tables
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[edit]

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

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

Key Features[edit]

Core concepts[edit]

Tables anchors around several core concepts:[11]

  • 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.[12][13]
  • 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.[14]

Data types[15][edit]

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

  • 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.[16]
  • 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[17] and the ability to call the Tables API via Apps Script.

Collaboration and revision history[edit]

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

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

  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. ^ a b "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.

External links[edit]