आपने जिस पेज का अनुरोध किया है वह फ़िलहाल आपकी भाषा में उपलब्ध नहीं है. पेज के निचले हिस्से से कोई दूसरी भाषा चुनी जा सकती है. इसके अलावा, किसी भी वेबपेज का अपनी पसंदीदा भाषा में झटपट अनुवाद भी किया जा सकता है. इसके लिए, आपको Google Chrome की पहले से मौजूद अनुवाद करने की सुविधा का इस्तेमाल करना होगा.

Summary of features supported for Workspace integration

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)

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: 

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.
Example integration:
Example detail view for Google Forms 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:

Example form view for Google Forms 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. 

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

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:

Contact us Tell us more and we’ll help you get there
true
Search
Clear search
Close search
Main menu
16324837010180161962
true
Search Help Center
true
true
true
false
false