Skip to main content

Pivot Table Conditional Formatter

Overview

The Pivot Table Conditional Formatter Plugin iterates over table rows, dynamically evaluating conditions for specific columns and applying classes based on the condition outcomes. It replaces placeholders with actual column values, verifies the existence of columns, and displays error messages for invalid column names, ensuring robust condition handling and visual feedback.

Use Cases

  • This plugin is ideal for applications that require conditional formatting of data tables. It allows you to visually highlight rows based on custom conditions, such as performance thresholds, status flags, or alert levels, providing clear visual cues directly in the table.

Installing the plugin

Prerequisites:

  1. The page must have a pivot table component
  2. Javascript must be enabled (applicable if your're on trial account)

Step-by-Step Installation:

  1. Navigate to the page with this pivot table, this can be a parent or child page. 
  2. Click on the Plugins
  3. Find the Pivot Table Conditional Formatter plugin
  4. Select the pivot table

Removing the Plugin

To remove the plugin, find the Javascript code that is surrounted with a comment for the plugin name and delete the code. Do the same for the CSS as well.