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 not supported 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 updates is 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 owner is 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 sync is 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 sync is turned on to maintain timestamps for the last time each table was fetched. See Configure 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 Configure the data cache settings.
Behavior settings	FiveButtonFooter	Yes/No	Setting that specifies whether Allow five views in the bottom navigation bar is turned on. See System Buttons.
Behavior settings	FullOfflineCaching	Yes/No	Setting that specifies whether Store content for offline use is 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 definition is 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 integration is turned on. See Map view configuration settings.
Behavior settings	LaunchOffline	Yes/No	Setting that specifies whether The app can start when offline is 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 refresh is turned on. See General configuration settings.
Behavior settings	SyncOnStart	Yes/No	Setting that specifies whether Sync on start is 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 updates is 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 app is 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 app is 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 app is 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 authentication is turned on. See Domain integration: The Essentials.
Security	EncryptLocalData	Yes/No	Setting that specifies whether Encrypt device data is turned on.
Security	RequireImageAndFileUrlSigning	Yes/No	Setting that specifies whether Require Image and File URL signing is turned on. See External URL for image files.
Security	RequireUserConsent	Yes/No	Setting that specifies whether Require user content is 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 access is turned on to not cache an image in Cloud CDN. See Document and image caching.
Security	SecurePDFAccess	Yes/No	Setting that specifies whether Secure PDF is 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 Sensitive is 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.
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. 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: AppsScript Email MakeDoc Notification Semantic SMS TakeAction 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 universally is 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.