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:
|
| 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:
|
| 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:
|
| Tasks | Type |
Enum |
Type of automation task. See Supported task types. Valid values include:
|
| 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. |