Summary of features supported for Workspace integration

The following sections summarize the features supported with Workspace integrations, including:

• Google Forms
• Google Chat (Chat apps) and Google Docs (smart chips)

Summary of features supported for Google Forms integration

The following table summarizes the supported form input types and how Google Forms data types are converted to AppSheet data types.

Google Forms input type	AppSheet data type
Multiple choice or drop-down (including grids)	Enum
Checkboxes	EnumList
Date (including year and time)	DateTime
Date (including year no time)	Date
Date (no year or time)	Text
File upload	File
File upload (restricted to images)	Image
File upload (restricted to video)	Video
Time (Duration)	Duration
Time (Time)	Time
Linear scale	Enum
Short answer	Text
Paragraph	LongText

The following table summarizes how common form response fields are converted to AppSheet columns.

Google Forms Response Field	AppSheet column
Response ID	Type=Text, Key=true
Respondent Email (if collected)	Type=Email
LastSubmittedTime Note: CreatedTime is not currently supported.	Type=DateTime

 

Summary of features supported for Chat and Docs integration

The following sections summarize the AppSheet app features that are supported with Google Chat and Google Docs Workspace integration: 

• View types and settings
• Column types and settings
• Actions and settings
• AppSheet functions
• Format rules
• Theme and brand settings

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:

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
• Unsupported view types and settings

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:
	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:
	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: 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:
	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. Example integration: 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.
	Form	Note: Supported when using the smart chips @ menu only. 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: Note: For unsupported fields, users are prompted to open the app to edit the information.

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.

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
• Supported column type settings
• Unsupported column type settings

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 Note: One or more values must be defined for the column.	DecoratedText	SelectionInput (Type = DROPDOWN)
EnumList Note: One or more values must be defined for the column.	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
• Unsupported actions
• Supported action settings
• Unsupported action settings

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.