Notification

The AppSheet Help Center documentation can now be viewed in Japanese - AppSheet ヘルプセンターのドキュメントが日本語で表示できるようになりました。. Learn more

Summary of features supported for Workspace integration

AppSheet apps can currently run in Google Chat, as Chat apps, or Google Docs, as smart chips.

The following sections summarize the AppSheet app features that can be used with Workspace integration: 

If your app uses a feature that’s not currently supported by one of AppSheet’s Workspace integration surfaces (that is, Chat apps or smart chips), app users who try to interact with that feature will be prompted to open the web version of the app to view or edit it.

For example, to edit a Color type field in a Chat app, app users need to open the web version of the app:

Color data type field used in Chat app; prompted to open in app to edit the field

In addition, a warning message similar to the following displays:

This view contains certain column types which cannot be edited in Google Chat

View types and settings

The supported and unsupported view types and settings for Workspace integration with AppSheet are summarized in the following sections:

Supported view types and settings

The following table summarizes the view types and settings that are supported for Workspace integration with AppSheet. 

Workspace integration View type Description
Chat apps Deck

Chat cards are used to display deck views.

All deck view options are supported.

The Position view option, used to define where the button used to access the view is located, is not supported at this time.

Example integration:

Deck view in Google Chat

Detail

Chat dialogs are used in to display detail views if opened from a card.

Chat cards are used to display detail views if opened from an automation.

A detail view of a record can show a list of other records that are referencing that row.

The following detail view options are supported:

  • Main image
  • Column order
  • Display name
  • Icon
All other detail view options, such as Quick edit columns or Desktop layout, are not supported at this time.
 
In addition, the Position view option, used to define where the button used to access the view is located, is not supported at this time.

Example integration:

Detail view in Google Chat

Form

 Chat dialogs are used to display form views.

The following form view options are supported:

  • Column order
  • Display name
  • Icon
  • Row key
All other form view options are not supported at this time.
 
In addition, the Position view option, used to define where the button used to access the view is located, is not supported at this time. 

Example integration:

Form view in Google Chat

Note: For unsupported fields, users are prompted to open the app to edit the information.
Smart chips in Docs Deck

Chat cards are used to display deck views.

All deck view options are supported.

Action buttons are rendered as icon-only due to space constraints.

The Position view option, used to define where the button used to access the view is located, is not supported at this time.

Example integration:

Smart chip integration deck view example

Detail

Chat dialogs are used to display detail views if opened from a card.

Chat cards are used to display detail views if opened from an automation.

A detail view of a record can show a list of other records that are referencing that row.

The following detail view options are supported:

  • Main image
  • Column order
  • Display name
  • Icon
All other detail view options, such as Quick edit columns or Desktop layout, are not supported at this time.
 
In addition, the Position view option, used to define where the button used to access the view is located, is not supported at this time.

Example integration:

TBD

Unsupported view types and settings

The following view types are not supported for Workspace integration with AppSheet: calendar, card, chart, dashboard, gallery, map, onboarding, and table. In addition, smart chip integration doesn't support form views.

The global General, View type, and Location settings, described in View settings: The Essentials, are not supported for Workspace integration with AppSheet.

Column types and settings

The supported and unsupported column types and settings for Workspace integration with AppSheet are summarized in the following sections:

Supported column types

The following table summarizes the column types that are supported for Workspace integration with AppSheet and the data types used for corresponding read-only and editable fields. 

Note: Currently, editing of column data is only available with Chat apps.

Column Type

Read-only field type

Editable field type

Address

DecoratedText

TextInput

App

DecoratedText (open link action)

N/A (read-only)

ChangeCounter

DecoratedText N/A (read-only)

ChangeLocation

DecoratedText N/A (read-only)

ChangeTimestamp

DecoratedText N/A (read-only)

Color

DecoratedText

Not supported in Chat.

App user is prompted to open app in web browser to edit.

Date

DecoratedText TextInput

DateTime

DecoratedText TextInput

Decimal

DecoratedText TextInput

Drawing

DecoratedText

Not supported in Chat.

App user is prompted to open app in web browser to edit.

Duration

DecoratedText TextInput

Email

DecoratedText TextInput

Enum

DecoratedText SelectionInput (Type = DROPDOWN)

EnumList

DecoratedText SelectionInput (Type = DROPDOWN)

File

DecoratedText (open link action)

Not supported in Chat.

App user is prompted to open app in web browser to edit.

Image

Image

Not supported in Chat.

App user is prompted to open app in web browser to edit.

LatLong

DecoratedText

TextInput

List

DecoratedText 

Not supported in Chat.

App user is prompted to open app in web browser to edit.

LongText

DecoratedText TextInput

Name

DecoratedText TextInput

Number

DecoratedText TextInput

Percent

DecoratedText TextInput

Phone

DecoratedText TextInput

Price

DecoratedText TextInput

Progress

DecoratedText

Not supported in Chat.

App user is prompted to open app in web browser to edit.

Ref

DecoratedText SelectionInput (Type = DROPDOWN)

Show

DecoratedText N/A (read-only)

Signature

DecoratedText (open link action)

Not supported in Chat.

App user is prompted to open app in web browser to edit.

Text

DecoratedText TextInput

Thumbnail

Image

Not supported in Chat.

App user is prompted to open app in web browser to edit.

Time

DecoratedText TextInput

Url

DecoratedText (open link action) TextInput

Video

DecoratedText (open link action)

Not supported in Chat.

App user is prompted to open app in web browser to edit.

XY

DecoratedText TextInput

Yes/No

DecoratedText SelectionInput (Type = RADIO_BUTTON)

Supported column type settings

The following column type settings are supported for Chat app integration with AppSheet:

  • Label?
  • Editable?
  • Require?
  • Show?
  • Valid if

Unsupported column type settings

The following column type settings are not supported for Workspace integration with AppSheet:

  • Type Details (such as maximum and minimum length for text values)
  • Suggested values under Auto Compute
  • Description
  • Valid if values that return a List type, such as dependent drop-downs

Supported actions and settings

The supported and unsupported actions and settings that are supported for Workspace integration with AppSheet are summarized in the following sections:

Supported actions

The following table summarizes the actions that are supported for Workspace integration with AppSheet and their behavior.

Action type

Behavior

App: copy this row and edit the copy

Navigates to new form view with row copied

Note: This action type is not supported at this time.

App: go to another AppSheet app

Opens new tab

App: go to another view within this app

Navigates to view

App: open a form to add a new row to this table (not a row-level action)

Navigates to form view for table

App: open a form to edit this row

Navigates to form view with row context

Data: add a new row to another table by using values from this row

Creates a new row in another table

Data: delete this row

Deletes row

Data: execute an action on a set of rows

Executes the action on specified rows

Data: set the values of some columns in this row

Updates row

External: go to a website

Opens URL in a new tab

External: open a file

Opens new tab

External: start an email

Opens new tab with mailto:email

External: start a phone call

Opens new tab with tel:phone_number

External: start a text message

Opens new tab with sms:phone_number

Unsupported actions

The following table summarizes the unsupported actions for Workspace integration with AppSheet.

 

Workspace integration

Unsupported actions

Chat app

The following actions are not supported for Chat app integration with AppSheet:

  • App: export this view as a CSV file (not a row-level action)
  • App: import a CSV file for this view (not a row-level action)
  • Grouped: execute a sequence of actions

Smart chip in Docs

The following actions are not supported for smart chip integration with AppSheet:

  • App: export this view as a CSV file (not a row-level action)
  • App: import a CSV file for this view (not a row-level action)
  • Grouped: execute a sequence of actions

The following actions are not supported for smart chip integration in web browsers (desktop):

  • External: start a phone call
  • External: start a text message

Supported action settings

The following table summarizes the supported action settings for Workspace integration with AppSheet.

Workspace integration

Supported action settings

Chat app

The following action settings are supported with Chat integration with AppSheet:

  • Action icon
  • Display name
  • Only if this condition is true

Smart chip in Docs

The following action settings are supported with smart chip integration with AppSheet:

  • Action icon
  • Display name (on hover)
  • Only if this condition is true

Unsupported action settings

The following action settings are not supported for Workspace integration with AppSheet at this time:

 

Workspace integration

Unsupported action settings

Chat

The following action settings are not supported in Chat integration with AppSheet at this time:

  • Prominence
  • Action confirmation settings, including:
    • Needs confirmation?
    • Confirmation Message

Smart chip in Docs

The following action settings are not supported in smart chip integration with AppSheet at this time:

  • Prominence
  • Action confirmation settings, including:
    • Needs confirmation?
    • Confirmation Message

AppSheet functions

The following AppSheet functions are not supported for use in any Workspace integration:

  • CONTEXT("View") and CONTEXT("ViewType") - The Chat app view currently visible to the user is not available to AppSheet.
  • HERE() - The Chat app user's location information is not available to AppSheet.

The following AppSheet functions are not supported at this time for use in Chat apps:

  • INPUT() 
  • USERLOCALE() - Set to the default table or app locale.

Format rules

The format rules are not supported for Workspace integration with AppSheet at this time.

Theme and brand settings

The theme and brand settings for Chat Apps with AppSheet are not supported at this time.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
14616472365568622158
true
Search Help Center
true
true
true