Table Filter

WHAT IT DOES

Table Filter is a floating panel that brings powerful, spreadsheet‑like filtering to any table on the web. The panel automatically detects all tables on the current page and lets you filter rows by column values using a wide range of operators: equals, contains, starts with, greater than, less than, and between (for numeric or date ranges). You can chain multiple filters together using AND or OR logic, and save entire filter configurations as named sets that persist across page reloads. The panel shows a real‑time count of visible rows, and you can choose between two modes: hide non‑matching rows (the default) or highlight matching rows while keeping all rows visible. Filter values can be typed in or selected from a list of unique values automatically detected in the selected column. Perfect for data analysts, researchers, project managers, or anyone who regularly works with large tables and needs to quickly drill down to relevant information.

WHERE IT RUNS

The panel overlays any website that loads the BotGentz extension—whether you're on a data dashboard, a CRM, a project management tool, a spreadsheet view, a reporting page, or any other web page. It works on all modern Chromium‑based browsers (Chrome, Edge, Brave, Arc) and Firefox. The script injects a self‑contained UI element that does not interfere with the host page's layout, styles, or JavaScript execution. It runs client‑side only, with no external API calls or cloud dependencies.

HOW TO USE

After installing the free BotGentz extension, visit any page and click the extension icon to activate the panel. The first time you use Table Filter, it will appear as a draggable widget near the bottom‑right corner of your viewport. To filter a table:

- Select a table from the dropdown. The panel automatically detects all tables on the page.

- Select a column from the column dropdown.

- Choose an operator (equals, contains, starts with, greater than, less than, or between).

- Enter a filter value (and a second value for "between").

- Click "Add Filter" to add it to the active filter list.

- Add additional filters as needed, and choose AND (all must match) or OR (any can match) logic.

- Click "Apply Filters" to hide non‑matching rows or highlight matches (depending on the highlight toggle).

The panel displays a live count of visible rows. To manage filters:

- Click "Clear Filters" to remove all filters and show all rows.

- Use "Save Current Filter Set" to store the current filter configuration with a name.

- Use the load dropdown and "Load Selected Set" to restore a saved filter configuration.

The panel remembers your filters and highlight mode preference across sessions.

INTELLIGENT TYPE‑AWARE COMPARISON ENGINE WITH MULTI‑FILTER LOGIC

Unlike simple text‑based filters that only support exact matches, this panel uses an intelligent type‑aware comparison engine that automatically detects whether a column contains numeric, date, or string data. The engine samples the column values and determines the appropriate type, then applies the correct comparison logic for each operator. For numeric values, it strips commas and parses floats; for dates, it converts to timestamps; for strings, it performs case‑insensitive comparison. This ensures that "between" works correctly for dates (e.g., "Jan 1, 2024" to "Jan 31, 2024") and numbers (e.g., "100" to "500"). The multi‑filter engine evaluates each row against the active filter list using a configurable logic mode (AND/OR). Each filter is evaluated independently, and the results are combined using short‑circuit evaluation for performance. The engine also includes a debounced apply mechanism that prevents excessive reflows during rapid filter changes. The unique values detector scans the selected column and returns a sorted list of distinct values, which can be used as quick‑select options for filter values.

THE PANEL

- Drag: Click and hold the panel's header bar to move it anywhere on the screen.

- Per‑site position: The panel stores its last position separately for each domain (e.g., different positions for Salesforce vs. Jira) using the browser's localStorage, keyed by hostname.

- Snap: When dragged near any edge of the viewport, the panel snaps to that edge with a 16px margin for a clean, docked feel.

- Collapse: Click the "−" button in the header to collapse the panel to a compact title bar, preserving all current values. Click "+" to expand it back.

- Resize: Drag the bottom‑right corner handle to resize the panel from 280px to 600px wide and 200px to 500px tall; the layout adapts responsively.

- Escape: Press the Escape key while the panel is focused to close it entirely (you can reopen it from the extension toolbar).

PLEASE NOTE

This script requires the free BotGentz extension to run—it is not a standalone bookmarklet or user script. Websites frequently update their DOM structures and security policies; while we strive to keep the panel functional across thousands of sites, occasional updates may be needed. The filter performs all operations entirely in your browser—no data is sent to any server, and no cookies or tracking identifiers are used. Your table selections, filter configurations, and saved filter sets remain private to your local session and are persisted only via GM_setValue (the extension's local storage) for convenience, not shared across devices or sessions. Filtering large tables (500+ rows) may cause brief performance delays—the panel is optimized for tables up to a few hundred rows. The "between" operator is inclusive of the lower bound and exclusive of the upper bound for numeric and date comparisons. For complex filtering needs (regex, case‑sensitive, etc.), consider using dedicated data analysis tools.