PowerTable
Go to websiteCommunityContact Us
  • INTRODUCTION
    • Welcome to PowerTable
  • GET STARTED
    • Prerequisites
    • Supported Data Platforms
    • Admin Setup Guide (15-day Free Trial)
  • PRODUCT TOUR
    • Explore a sample app
    • Build your first app
    • Layout & User Interface
  • CREATE TABLE APP
    • Introduction
    • Import Spreadsheet Data
    • Connect to Database
    • Enter Data Manually
    • Get Data from Semantic Model
  • WORKING WITH POWERTABLE
    • Basic Table Operations
      • Edit data
      • Bulk Edit
      • Insert rows
      • Bulk Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Column Insights
    • Conditional Formatting
  • COLUMN SETUP
    • Configure Properties
      • General
      • Lookup and Relation
      • Display
    • Upload/Download Configuration
    • Add a Column
      • Add Visual Column
        • Add Formula Column
        • Add Multi-select Relationship Column
        • Add Reference Column
      • Add Database Column
  • ACCESS CONTROL
    • Manage Access
    • Row Permissions
    • Column Permissions
  • APPROVALS
    • Set up Approval Workflow
    • User Approvals
    • Rule-based Approvals
    • Approval using a Lookup Table
    • Multi-level Approvals
    • Notify Approvers via MS Teams
    • Handling Changes Before Approval
    • Review Changes - Approval process
  • WORKFLOWS, AUTOMATION & NOTIFICATIONS
    • Workflow automation
    • Send Mail notifications
    • MS Teams notifications
    • Webhooks
    • Cascade Updates
  • Pause an Automation
  • AUDIT
    • Audit logs
  • COMMENTING & COLLABORATION
    • Commenting
    • View all comments & track changes
    • Assign users & task status
  • APPEARANCE
    • Basic formatting
    • Display Settings
  • USER MANAGEMENT & LOGS
    • PowerTable Console
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • PowerTable managed DB
  • MISCELLANEOUS
    • Keyboard Shortcuts
    • Formulas & Functions
Powered by GitBook
On this page
  1. ACCESS CONTROL

Column Permissions

PreviousRow PermissionsNextSet up Approval Workflow

Last updated 1 month ago

Just as you can set row permissions, you can also establish column permissions.

By default, all workspace users who have access to the PowerTable item can view and modify all columns. Access control for each column can be configured through the 'Manage Access' menu. Here, you can clearly specify who is allowed to write values to each column.

To set up access permissions to the columns,

  1. Click on the Manage Access menu from the Setup tab.

  1. Choose Column Access tab.

  1. To set permissions for a column, enter the name or email ID of the users to whom you wish to provide the access in the 'Who Can Edit' field.

In the example below, we are setting access control for the 'Product SKU' column by specifying the users' name.

  1. You can enter as many users as you want. You can also type in the email ID of your organization group or active directory list.

  1. You can uncheck the 'Allow Edits' checkbox to prevent users from editing specific columns. Typically, the primary key field is locked from editing. Click Save to save the settings.

Manage Access
Column access
Specify access control list
Access control list who can edit 'Product SKU' column
Save the settings