AppSheet

    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
    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 .
    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 (preview)
    • AiExtract (preview)
    • AppsScript
    • Chat
    • Email
    • 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?

    Need more help?

    Try these next steps:

    Contact us Tell us more and we’ll help you get there
    true
    Enable Dark Mode
    Search
    Clear search
    Close search
    Google apps
    Main menu
    12913858896790673864
    true
    Search Help Center
    true
    true
    true
    false
    false
    false
    false
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: