Condition expression reference for governance policies

The following lists the column names and types, and the valid values that you can include in the Condition expression when defining governance policies . The column names are organized by AppSheet component, such as actions, settings, tables, and so on.

The following AppSheet functions are notsupported for use in the Condition expression:

EXTRACT() , EXTRACTCHOICE() , EXTRACTDATES() , EXTRACTDATETIMES() , EXTRACTDOMAINS() , EXTRACTDURATIONS() , EXTRACTEMAILS() , EXTRACTHASHTAGS() , EXTRACTMENTIONS() , EXTRACTNUMBERS() , EXTRACTPHONENUMBERS() , EXTRACTPRICES() , EXTRACTTIMES() , HERE() , HYPERLINK() , INPUT() , LAT() , LATLONG() , LATLONGDISTANCE() , LINKTEXT() , LINKTOAPP() , LINKTOFILTEREDVIEW() , LINKTOFORM() , LINKTOPARENTVIEW() , LINKTOROW() , LINKTOVIEW() , LINKURL() , LONG() , NOW() , OCRTEXT() , RANDBETWEEN() , SNAPSHOT() , TEXTICON() , TIMENOW() , TODAY() , UNIQUEID() , UTCNOW() , and XY()

Also, the CONTEXT() function is only supported using the following keywords: AppName or OwnerEmail

The following AppSheet functions are not supported for use in the policy Condition setting when Stage is set to Enforce Always:

USEREMAIL() , USERLOCALE() , USERNAME() , USERROLE() , USERSETTINGS() , and USERTIMEZONE() .

AppSheet component

Column name

Column type

Description

Actions

ActionType

Enum

Type of action. See Action types . Valid values include:

ADD_RECORD
ADD_RECORD_TO
CALL
COMPOSITE
COPY_EDIT_ROW
DELETE_RECORD
EDIT_RECORD
EMAIL
EXPORT_VIEW
IMPORT_FILE
NAVIGATE_APP
NAVIGATE_BACK
NAVIGATE_DIFFERENT_APP
NAVIGATE_URL
OPEN_FILE
REF_ACTION
SET_COLUMN_VALUE
SMS
TRIGGER_PROCESS

API settings

EnableAPI

Yes/No

Setting that specifies whether the API is enabled. See Enable the API for cloud-based service communication .

App settings

Description

Text

Description of the app. See App properties .

App settings

DisableAutoUpdate

Yes/No

Setting that specifies whether Automatic updatesis turned off. See Can I have my app update automatically?

App settings

Id

Text

App ID. View the App ID when enabling the API as described in Enable the API for cloud-based service communication .

App settings

IsPublic

Yes/No

Setting that specifies whether the app is public. See Share your app with anyone (public access) .

App settings

IsTeamPublic

Yes/No

Setting that specifies whether the app is a team sample. See Share resources with your team .

App settings

Name

Yes/No

Name of the app. See App properties .

App settings

OwnerId

Number

ID of the app owner.

App settings

Title

Text

Short description of the app. See App properties .

App settings

UsePublicOwner

Yes/No

Setting that specifies whether Use public app owneris turned on to display the public app owner to users of the app. See Set the public app owner .

Behavior settings

DelayedSync

Yes/No

Setting that specifies whether Delayed syncis turned on to queue up changes until you explicitly choose to sync. See Delayed sync .

Behavior settings

DeltaSync

Yes/No

Setting that specifies whether Delta syncis turned on to maintain timestamps for the last time each table was fetched. See C onfigure the data caçhe settings .

Behavior settings

EnableCaching

Yes/No

Setting that specifies whether Server caching is turned on to maintain cached copies of read-only tables for up to five minutes. See C onfigure the data cache settings .

Behavior settings

FiveButtonFooter

Yes/No

Setting that specifies whether Allow five views in the bottom navigation baris turned on. See System Buttons .

Behavior settings

FullOfflineCaching

Yes/No

Setting that specifies whether Store content for offline useis turned on so that AppSheet caches images and documents for offline use. See Cache images and documents .

Behavior settings

HideDefinition

Yes/No

Setting that specifies whether Hide app definitionis turned on when sharing samples apps with your team. See Share resources with your team .

Behavior settings

HighPrecisionGeocoding

Yes/No

Setting that specifies whether Use my Google Maps integrationis turned on. See Map view configuration settings.

Behavior settings

LaunchOffline

Yes/No

Setting that specifies whether The app can start when offlineis turned on to allow the app to start when there is no internet connection. See Enable app to start when offline .

Behavior settings

PullToSync

Yes/No

Setting that specifies whether Pull to refreshis turned on. See General configuration settings.

Behavior settings

SyncOnStart

Yes/No

Setting that specifies whether Sync on startis turned on to sync data every time the app starts to make sure the user has the latest data. See Sync: App to Cloud .

Bots

Disabled

Yes/No

Setting that specifies whether the bot automation is disabled. See Enable or disable a bot .

Chatbot settings

EnableChatbot

Yes/No

Setting that specifies whether Chat bots are enabled. See Chat apps: The Essentials .

Columns

Name

Text

Name of the column. See Columns: The Essentials .

Columns

Type

Text

Type of column. See Column data types .

Description

DesignDetails

Text

Design details of the app. See App documentation .

Description

IsWhitelabel

Yes/No

Setting that specifies whether the app is branded. See Branded apps: Establish your own branding .

Description

Purpose

Text

Purpose of the app. See App documentation .

Security

AllowAllSignedInUsers

Yes/No

Setting that specifies whether all signed-in users have access. See Share you apps with all signed-in users .

Security

AuthDomain

Text

Display name of the authentication domain. See Domain integration: The Essentials .

Security

AuthDomainSource

Text

Name of authentication domain source. See Domain integration: The Essentials .

Security

AuthGroup

Text

Name of authentication group.

Security

AuthGroupId

Text

ID of authentication group.

Security

AuthProvider

Text

Authentication provider. See Require sign-in: The Essentials .

Security

AuthRequired

Yes/No

Setting that specifies whether authentication is required. See Require sign-in: The Essentials .

Security

AutoBackgroundUpdate

Yes/No

Setting that specifies whether Automatic updatesis turned on. See Can I have my app update automatically?

Security

CanMakePublic

Yes/No

Setting that specifies whether the Yes, I am authorized to set up an insecure appis turned on. See Share app with anyone (public access) .

Security

ConsentAuthorizedPublicApp

Yes/No

Setting that specifies whether the Yes, I am authorized to set up a public appis turned on. See Share you apps with all signed-in users .

Security

ConsentPublicApp

Yes/No

Setting that specifies whether the Yes, this is a public appis turned on. See Share app with anyone (public access) and Share you apps with all signed-in users .

Security

DisableAppSharing

Yes/No

Setting that specifies whether the Disable Share button is turned on. See System Buttons .

Security

DomainAuthRequired

Yes/No

Setting that specifies whether Require domain authenticationis turned on. See Domain integration: The Essentials .

Security

EncryptLocalData

Yes/No

Setting that specifies whether Encrypt device datais turned on.

Security

HasExternalAuth

Yes/No

Setting that specifies whether app creators can use external data sources and external authentication domains. See:

Security

RequireImageAndFileUrlSigning

Yes/No

Setting that specifies whether Require Image and File URL signingis turned on. See External URL for image files .

Security

RequireUserConsent

Yes/No

Setting that specifies whether Require user contentis turned on to require users to consent before using the app. See Security: The Essentials.

Security

SecureImageAccess

Yes/No

Setting that specifies whether Secure Image accessis turned on to not cache an image in Cloud CDN. See Document and image caching .

Security

SecurePDFAccess

Yes/No

Setting that specifies whether Secure PDFis turned on to not cache a PDF file in Cloud CDN. See Document and image caching .

Security

TreatAllDataAsPII

Yes/No

Setting that specifies whether Treat all data columns as Sensitiveis turned on. See Sensitive Personally Identifiable Information (PII) data policy .

Tables

CloudObjectStore

Text

Name of the cloud object store. Configure a relational database as a cloud object store .

Tables

DataAccessMode

Text

Access mode. See Access mode: as app creator or app user . Valid values include:

as app creator (default if invalid or no value provided)
as app user

Tables

DataSourceName

Text

Name of data source. See Summary of data source types .

To restrict access to team data sources to only specific team members, use the :Team: string in a governance policy condition. See Restrict access to team data sources .

Tables

DisableAutoUpdate

Yes/No

Setting that specifies whether automatic updates is turned off. See Can I have my app update automatically?

Tables

Name

Text

Name of the table. See Table: The Essentials .

Tables

ProviderName

Text

Name of the provider. Valid values include:

airtable
apigee_api
apple
aws_cognito_domain
big_query
box
data_studio ( Looker Studio )
database (all cloud and on-premises databases)
dropbox
dynamodb
google
google_calendar
google_tables (see also Disable AppSheet databases )
integration_connector
mariadb
microsoft
mysql
odata
okta_domain
openid_connect
oracle
postgres
redshift
salesforce
sqlserver
sketch (to create an view apps using Spec )
smartsheet

See Summary of data source types .

Tables

UpdateMode

Enum

Type of updates allowed in a table. See Control add, update, and delete operations . Valid values include:

ADDS_AND_DELETES
ADDS_AND_UPDATES
ADDS_ONLY
ALL_CHANGES
DELETES_ONLY
READ_ONLY
UNASSIGNED
UPDATES_AND_DELETES
UPDATES_ONLY

Tasks

Type

Enum

Type of automation task. See Supported task types . Valid values include:

AiCategorize
AiExtract
AiExtractTable (Extract rows)
AiSummarize
AppsScript
Chat
Email
IsAITask
MakeDoc
Notification
SMS
Webhook

UserDomains

Domain

Text

Name of the user domain. See Domain integration: The Essentials .

UserWhiteList

Email

Text

User email allowlist. See Share: The Essentials .

UXSettings

BackgroundImageUrl

Text

URL of the background image. See Display images, documents, and audio files .

UXSettings

HideSystemButtons

Yes/No

Setting that specifies whether system actions are hidden. See Use system actions .

UXSettings

LogoUrl

Text

URL of the logo image. See Display images, documents, and audio files .

UXSettings

PhotoResolution

Text

Resolution used for images. See Capture images .

UXSettings

RespectShowIfEverywhere

Yes/No

Setting that specifies whether Apply show-if constraints universallyis turned on. See Scope of Show_If .

UXSettings

ShowPreviewRollouts

Yes/No

Setting that specifies whether the Preview new features setting is turned on to gain access to app features that are in the AppSheet preview program .

Was this helpful?

How can we improve it?