WriteBackExtreme
WebsiteAll products
V5.0
V5.0
  • Prologue
    • WriteBackExtreme v5
    • Release Notes
    • Changelogs
    • Architecture
      • Data Handling and Security in WriteBackExtreme (SaaS)
  • Installation guide
    • Requirements
      • Windows
      • Linux
    • Getting started
      • Windows
      • Linux
      • Containerization
        • Docker standalone
        • Docker compose
        • Repository database
        • ODBC connections
    • Installation wizard
      • License
      • Repository database
        • SQL Server
        • MySQL
        • PostgreSQL
        • SQLite
      • Create a user
      • URL & SSL Certificate
      • Run as a service
      • Summary
        • Running on Linux
    • Configuration panel
      • Home page
      • Domain & SSL Management
      • Repository Database
      • License Management
      • User Management
      • Ip Whitelisting
      • Primary keys in Data Add
    • Upgrade
      • Upgrade from 2.x
    • Update license
    • Moving to production
  • Product Guide
    • Getting started
    • Tableau Extension
      • Getting started
        • Create a worksheet with Username()
        • Add the Extension to your dashboard
        • Ready to start
      • Configuration
        • General
          • Schemas
          • Authentication
          • Popup
          • Theming
          • Tabs
          • Mapping
          • Tableau
          • Import/Export
          • Tableau Datasource
        • Schemas
          • General
            • Editable Conditions
          • Field Formatting
            • Single line text
            • Paragraph text
            • Number
            • Boolean
            • Dropdown select
              • Dynamic Populated content
              • Cascading dropdown
            • Date/DateTime
          • Form Builder
            • Features
            • Dynamic Values
              • Troubleshoot | values
        • Changelog
      • End-user
        • Features
          • Dynamic Filtering
          • Bulk Import
          • Audits (History)
          • Bulk Edit
          • Duplicate rows
        • Add Data
          • Overview
          • Add rows
          • Edit rows
        • Collaboration
          • Overview
          • Add / Edit
          • Reply
        • Data Helper
          • Overview
          • Add rows
          • Edit rows
        • Data Correction
          • Add records
          • Edit records
          • Remove records
          • Interpolate
          • Calculations
          • Vertical layout
        • SSO/SAML or Oauth authentication
    • Management console
      • Setup security
        • OAuth Setup
          • Microsoft Entra
          • Auth0
          • Google
        • SSO Setup
          • OKTA Example
          • PingOne Example
          • Azure Example
          • Troubleshooting SSO
      • Connections
      • Schemas
        • Permissions
        • Audits
        • Import/export
        • Row Level Security
        • Schema data
        • Workflows
          • Stored procedures
          • Tutorial (video)
      • Tableau sync
      • User management
      • Group management
      • Info & License
    • Database Connections
      • DataBricks
        • Windows
        • Linux
      • Snowflake
        • Using ODBC
          • Windows
          • Linux
        • OAuth Authentication
        • Key Pair
    • NEW: InputTables
  • Support
    • Troubleshoot
      • Errors
    • FAQ
Powered by GitBook
On this page
  • Allow editing records only when a condition is met
  • Allow adding records only when a condition is met

Was this helpful?

  1. Product Guide
  2. Tableau Extension
  3. Configuration
  4. Schemas
  5. General

Editable Conditions

PreviousGeneralNextField Formatting

Was this helpful?

Editable conditions are incompatible with the DataCorrection PowerTools feature.

Allow editing records only when a condition is met

Set conditions to allow or deny users the ability to edit a row in WriteBackExtreme, if this condition isn’t met then the logged in user will not be able to edit the comment. For example if the status of the row is ‘Current’ then that row can be editable, all rows that do not have a current status will be uneditable, or if you wish to have comments only about ‘Phones’ this is also possible. Conditions for editing can be based on either a data source from your dashboard, or on existing records within the underlaying WriteBackExtreme schema.

Allow adding records only when a condition is met

This feature does not work with Data Correct module.

There may be situations where you want to restrict the ability of your users to add new records in WriteBackExtreme. For example, you only want your users to be able to add a comment to data within the current fiscal period, or based on the total amount of sales related to a selected mark.

Set your condition using the editor in the “worksheet-schema | general” tab in the WriteBackExtreme configuration screen. In this example, we will limit the adding of records to any mark with SUM(Sales) above 250000. This will allow your users to only add comments on marks where SUM(Sales) exceeds US$250.000.

As seen in the example below, the “add record” button (the pink + plus sign) is disabled when a mark is selected that does not match the condition setup previously (SUM(Sales) must exceed US$250.000).