The following sections summarize the features supported with Workspace integrations, including:
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) |
|
|
Checkboxes |
|
|
Date (including year and time) |
|
|
Date (including year no time) |
|
|
Date (no year or time) |
|
|
File upload |
|
|
File upload (restricted to images) |
|
|
File upload (restricted to video) |
|
|
Time (Duration) |
|
|
Time (Time) |
|
|
Linear scale |
|
|
Short answer |
|
|
Paragraph |
|
The following table summarizes how common form response fields are converted to AppSheet columns.
|
Google Forms Response Field |
AppSheet column |
|
Response ID |
Type= |
|
Respondent Email (if collected) |
Type= |
|
LastSubmittedTime Note: CreatedTime is not currently supported. |
Type= |
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
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:
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:
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:
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:
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
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.
|
Column Type |
Read-only field type |
Editable field type |
|
Address |
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 |
|
|
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 |
Not supported in Chat. App user is prompted to open app in web browser to edit. |
|
|
LatLong |
TextInput | |
|
List |
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 |
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
Listtype, 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 |
|
External: start a phone call |
Opens new tab with |
|
External: start a text message |
Opens new tab with |
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:
|
|
Smart chip in Docs |
The following actions are not supported for smart chip integration with AppSheet:
The following actions are not supported for smart chip integration in web browsers (desktop):
|
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:
|
|
Smart chip in Docs |
The following action settings are supported with smart chip integration with AppSheet:
|
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:
|
|
Smart chip in Docs |
The following action settings are not supported in smart chip integration with AppSheet at this time:
|
AppSheet functions
The following AppSheet functions are not supported for use in any Workspace integration:
CONTEXT("View")CONTEXT("ViewType")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.