:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import './ConditionalFormattingTab.scss'
import { useActions, useValues } from 'kea'
import { IconPlusSmall, IconTrash } from '@posthog/icons'
import {
LemonButton,
LemonCollapse,
LemonColorGlyph,
LemonColorPicker,
LemonInput,
LemonSelect,
LemonTag,
} from '@posthog/lemon-ui'
import { ConditionalFormattingRule } from '~/queries/schema/schema-general'
import { dataVisualizationLogic } from '../../dataVisualizationLogic'
import { FORMATTING_TEMPLATES } from '../../types'
import { conditionalFormattingLogic } from './conditionalFormattingLogic'
export const DEFAULT_PICKER_COLORS = [
'#FFADAD', // Current default
'#E8A598',
'#FFD6A5',
'#FFCFD2',
'#FDFFB6',
'#C1FBA4',
'#9BF6FF',
'#A0C4FF',
'#BDB2FF',
'#FFC6FF',
]
const getRuleHeader = (rule: ConditionalFormattingRule): string => {
if (!rule.columnName || !rule.input) {
return 'New rule'
}
const template = FORMATTING_TEMPLATES.find((n) => n.id === rule.templateId)
if (!template) {
return 'New rule'
}
if (template.hideInput) {
return `${rule.columnName} ${template.label.toLowerCase()}`
}
return `${rule.columnName} ${template.label.toLowerCase()} ${rule.input}`
}
export const ConditionalFormattingTab = (): JSX.Element => {
const { conditionalFormattingRules, conditionalFormattingRulesPanelActiveKeys } = useValues(dataVisualizationLogic)
const { addConditionalFormattingRule, setConditionalFormattingRulesPanelActiveKeys } =
useActions(dataVisualizationLogic)
return (
<div className="flex flex-col ConditionalFormattingTab p-3">
<p>You can add rules to make the cells in the table change color if they meet certain conditions.</p>
{conditionalFormattingRules.length > 0 && (
<LemonCollapse
activeKeys={conditionalFormattingRulesPanelActiveKeys}
onChange={(activeKeys) => setConditionalFormattingRulesPanelActiveKeys(activeKeys)}
multiple={true}
className="mb-2"
size="small"
panels={conditionalFormattingRules.map((rule) => ({
key: rule.id,
header: (
<>
<LemonColorGlyph color={rule.color} />
<span className="ml-2">{getRuleHeader(rule)}</span>
</>
),
content: <RuleItem rule={rule} key={rule.id} />,
className: 'p-2',
}))}
/>
)}
<LemonButton
className="mt-1"
onClick={() => addConditionalFormattingRule()}
icon={<IconPlusSmall />}
fullWidth
type="secondary"
>
Add rule
</LemonButton>
</div>
)
}
const RuleItem = ({ rule: propsRule }: { rule: ConditionalFormattingRule }): JSX.Element => {
const { columns, responseLoading, dataVisualizationProps } = useValues(dataVisualizationLogic)
const builtCFLogic = conditionalFormattingLogic({ key: dataVisualizationProps.key, rule: propsRule })
const { selectColumn, updateInput, selectTemplate, selectColor, deleteRule } = useActions(builtCFLogic)
const { rule, template } = useValues(builtCFLogic)
return (
<div className="gap-2 flex flex-col">
<LemonSelect
placeholder="Column"
className="w-full"
value={rule.columnName || null}
options={columns.map(({ name, type }) => ({
value: name,
label: (
<div className="items-center flex-1">
{name}
<LemonTag className="ml-2" type="default">
{type.name}
</LemonTag>
</div>
),
}))}
disabledReason={responseLoading ? 'Query loading...' : undefined}
onChange={(value) => {
const column = columns.find((n) => n.name === value)
if (column) {
selectColumn(column.name)
}
}}
/>
<LemonSelect
className="w-full"
options={FORMATTING_TEMPLATES.filter((n) => {
const column = columns.find((n) => n.name === rule.columnName)
return column ? n.availableColumnTypes.includes(column.type.name) : true
}).map(({ id, label }) => ({ label, value: id }))}
value={rule.templateId}
onSelect={(value) => selectTemplate(value)}
/>
<div className="flex flex-1">
<LemonColorPicker
selectedColor={rule.color}
onSelectColor={selectColor}
colors={DEFAULT_PICKER_COLORS}
showCustomColor
hideDropdown
/>
<LemonInput
placeholder="value"
className="ml-2 flex-1"
onChange={(value) => updateInput(value)}
value={rule.input}
disabled={template.hideInput}
/>
<LemonButton
icon={<IconTrash />}
status="danger"
title="Delete rule"
className="ml-1"
noPadding
tooltip="Delete formatting rule"
onClick={() => deleteRule()}
/>
</div>
</div>
)
}