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.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu