Overview Version (2) Discussion (2)

• 

  Data Tables

  Data Tables lets administrators create stand-alone, fully customizable data tables within XenForo

  admin tools

  data tables

  tabular data
  About this resource

  

  
  Data Tables lets administrators create stand-alone, fully customizable data tables within XenForo - no code required. Define your own columns, set up dropdown lookups, link records across tables, and manage structured data right from the AdminCP, with clean public-facing display pages wrapped in your forum's theme.
  
  Perfect for product catalogs, game databases, team rosters, pricing tables, inventory lists, or any structured data that doesn't fit neatly into forum threads.
  
  

  ---

  
  

  Key Features

  • Dynamic Table Definitions - Create unlimited tables, each with its own title, URL slug, description, and display order. Toggle tables active/inactive without deleting data.
  • Listed/Unlisted Tables - Hide definitions from the public table index while keeping them accessible via direct URL. "Unlisted" badge in AdminCP.
  • 8 Field Types - Build columns using: Text, Number, URL, Date, Lookup (dropdown), Table Lookup (cross-table reference), Text Area, and Yes/No (boolean). Each field supports sortable and filterable flags.
  • Field Visibility - Per-field "Show in table" toggle to hide columns from the table view while still showing them on record detail pages.
  • Lookup Columns (Relational Dropdowns) - Define dropdown options for any field. Options are stored relationally (not as flat strings), enabling clean data entry and consistent display.
  • Cross-Table Relational Lookups - Link records between tables with the Table Lookup field type. Select a linked table and a display field, and users pick from records in that table via dropdown. Values render as clickable links to the referenced record.
  • Inline "Create New" Overlay - A "+" button next to every Table Lookup dropdown opens a modal to create a new record in the linked table. Saves via AJAX and auto-selects in the parent dropdown - no page reload, no navigating away. Works in both AdminCP and public pages.
  • Friendly URLs - Records accessible at /data-tables/record/{table-slug}/{record-slug}/ with auto-generated unique slugs. Legacy URLs 301-redirect to the new format.
  • Breadcrumbs - Full navigation trail on all public pages: Home > Data Tables > Table Name > Record Title.
  • Clickable Table Rows - Click anywhere on a table row to navigate to the record detail page. Ctrl/Cmd+click opens in a new tab.
  • Record Detail Pages - Each record has its own detail page showing all fields and a "Referenced by" section listing records from other tables that point to it.
  • CSV Import - Upload CSV files from the AdminCP record list page. Supports comma, tab, semicolon, and pipe delimiters. Automatic column mapping by header name, 5-row preview, lookup resolution with optional auto-creation of missing options.
  • CSV Export - Download table data as CSV with formatted cell values (lookup labels, boolean Yes/No, table lookup display labels).
  • Inline Display Order Editing - Edit field display order values directly from the field list page without opening each field individually.
  • FontAwesome Icon Picker - Choose a custom icon for each table definition from 1,500+ FontAwesome icons (e.g., fa-car, fa-wrench, fa-database). Icons appear on the table list, table view header, and record detail header.
  • Enhanced Table List - Public table directory uses rich card rows with definition icon, description, field count, and record count badge with smooth hover transitions.
  • Unified Page Headers - Table view and record detail pages share a consistent icon + title block header pattern for visual cohesion across all pages.
  • Bulk Select & Delete - Admin record list has select-all checkbox and batch delete button with dynamic count display.
  • Admin Record Management - Full CRUD for records within the AdminCP. Dynamic forms automatically adapt to your field definitions - text fields become text inputs, lookups become dropdowns, numbers get spinners, booleans get checkboxes.
  • Public Table Display - Clean, responsive public pages at /data-tables/ showing all listed tables, with individual table views at /data-tables/{slug}/. Full theme integration.
  • Column Sorting - Mark fields as "sortable" in the admin, and users can click column headers on the public table view to sort ascending/descending.
  • Public Record Submission - Optionally allow members to submit new records from the public side (permission-controlled).
  • Multi-Select Table Lookups - Table Lookup fields can be marked multi-select for many-to-many relationships. Rendered as a multi-select dropdown (or autocomplete tags for large lists). Cell display shows comma-separated linked items with clickable links.
  • Public Edit/Delete - Record owners can edit and delete records from public pages. Controlled by dedicated permissions with sensible defaults (edit: Allow, delete: Deny).
  • Required Field Validation - Mark fields as required. Enforced across all save actions (admin and public) with clear error messages.
  • Autocomplete Search - Table Lookup fields with more than 50 options automatically switch from dropdown to AJAX autocomplete with debounced search and removable tag pills for multi-select.
  • Inline Edit Linked Record - Pencil icon next to single-select Table Lookup fields opens an overlay to edit the referenced record. Option label refreshes on save without page reload.
  • Permission-Controlled Access - Four permissions out of the box:
    • View data tables (default: Allow for all)
    • Add records (default: Deny)
    • Edit records (default: Allow)
    • Delete records (default: Deny)
  • Pagination - Both admin and public views paginate at 50 records per page.
  • AJAX Field Configuration - When editing fields, selecting "Table Lookup" dynamically shows linked table and display field dropdowns via AJAX - no page reload needed.
  • Clickable URL Fields - URL-type field values render as clickable links in both admin and public table views.
  • Clean Uninstall - All 5 database tables are dropped on uninstall. No leftover data.

  
  

  ---

  
  

  How It Works

  1. Create a Definition - Go to AdminCP > Tools > Data Tables > Add Definition. Give it a title (e.g., "Product Catalog") and a URL slug (e.g., "products").
  2. Add Fields - Click "Fields" to define your columns. For example:
     • Name (Text, Required, Sortable)
     • Category (Lookup - with options like "Electronics", "Clothing", "Home")
     • Price (Number, Sortable)
     • In Stock (Yes/No)
     • Website (URL)
     • Manufacturer (Table Lookup - linked to a "Manufacturers" table, displaying the "Name" field)
  3. Add Records - Click "Records" to start entering data. The form automatically generates the right input type for each field. Need a new linked record? Click the "+" next to any Table Lookup dropdown and create one inline.
  4. Import Data - Have existing data? Click "Import CSV" on the record list page, upload your file, map columns, preview, and import.
  5. View Publicly - Visit /data-tables/products/ to see your table with sortable columns, resolved lookup values, clickable cross-links, and clean formatting. Click any row to see its detail page at a friendly URL.

  
  

  ---

  
  

  Cross-Table Relationships Example

  Say you have two tables: "Manufacturers" and "Products". Add a Table Lookup field to Products that points to Manufacturers. Now when adding a product, users pick from existing manufacturers via dropdown. In the Products table, manufacturer names appear as clickable links to the manufacturer's detail page. On the manufacturer's detail page, a "Referenced by" section lists all products that reference it.
  
  

  ---

  
  

  Technical Details

  • Architecture: Hybrid JSON + normalized lookups across 5 database tables
    • xf_qubn_dt_definition - table definitions (title, slug, status, is_listed)
    • xf_qubn_dt_field - column definitions per table (type, options, is_show_in_table)
    • xf_qubn_dt_lookup_option - dropdown options for lookup fields
    • xf_qubn_dt_record - data rows (JSON blob per record, slug for friendly URLs)
    • xf_qubn_dt_record_ref - denormalized cross-table reference tracking
  • Performance: Lookup values resolved in a single batch query. Cross-table references tracked via denormalized table for fast reverse lookups. Composite indexes on frequently-queried columns. Paginated to 50 records per page.
  • Compatibility: XenForo 2.3.x. No class extensions - completely self-contained with zero conflicts.
  • Code Quality: PHPStan level 3 clean. 122 automated browser tests. All user input filtered. CSRF protection on all forms.
  • Upgrade: Seamless upgrade from any prior version (v1.0.0 through v1.2.1) with automatic migration steps.

  
  

  ---

  
  

  Installation

  1. Download and extract the ZIP file
  2. Upload the Qubn/DataTables/ folder to src/addons/
  3. Go to AdminCP > Add-ons > Install from archive (or Install/upgrade)
  4. Navigate to AdminCP > Tools > Data Tables to start creating tables
• Version

  1.3.2 Stable Available Mar 25, 2026 · 1

  Download

  File size: 54.1 KB

  SHA-256: 2fe95d2224abac8cb27475f3b3b7e4a354c8b6dd1ff36b71b5e607dc22cda418

  SHA-256 verified Package valid Compatibility checked Last verified: Wednesday at 12:10 AM

  Data Tables v1.3.2 - Title Field Selector, Editable Slugs, and Slug Regeneration.
  
  

  Data Tables v1.3.2 - Title Field Selector, Editable Slugs, and Slug Regeneration

  v1.3.2 fixes the record title showing "#58" instead of field values, adds a title field selector per definition, makes slugs editable, and adds a one-click slug regeneration button.
  
  

  ---

  
  

  New Features

  • Title field selector - Choose which field is the record's display title from a dropdown on the definition edit page. Used in the page header, browser tab title, and URL slug generation. Defaults to "Auto (first text field)" for backward compatibility.
  • Editable record slugs - Admin record edit form now shows the URL slug field for manual editing.
  • Regenerate slugs button - One-click button on the admin record list page that regenerates all record slugs using the title field. Fixes generic slugs like record-2 created during the v1.3.0 migration.

  
  

  Fixed

  • Record title shows "#N" instead of field value - Title resolution now uses the definition's title field setting, then falls back to the first text field. Previously it could show the raw record ID when the first field value wasn't a plain string.
  • Bulk delete button count not resetting - Unchecking all checkboxes on the admin record list now correctly resets the button text to "Delete selected" instead of keeping the old count.
  • Slug generation uses title field - New records now generate their URL slug from the title field value instead of always using the first field.

  
  

  How to Fix Existing Records

  If you upgraded from v1.2.x and have generic slugs like record-2:
  

  1. Go to AdminCP > Tools > Data Tables > edit your definition
  2. Set the Title field dropdown to the field you want (e.g., "Model" for a vehicles table)
  3. Save
  4. Go to the record list for that definition
  5. Click Regenerate slugs on the right side

  All record URLs and page titles will update automatically. Old URLs will need manual redirects if shared externally.
  
  

  Upgrading

  Upload the ZIP via Admin CP > Add-ons > Install/upgrade from archive. One automatic migration step adds the title_field_id column. All existing data and permissions are preserved.
  
  

  Requirements

  • XenForo 2.3.0+

  1.0.0 Stable Available Mar 14, 2026 · 1

  Download

  File size: 27.3 KB

  SHA-256: dd64cd56ec5f70572617aa00267640831b00a7b230bf0049cf24c4bc95c62e83

  SHA-256 verified Package valid Compatibility checked Last verified: Wednesday at 12:10 AM

  View attachment 5763​

  
  Data Tables lets administrators create stand-alone, fully customizable data tables within XenForo - no code required. Define your own columns, set up dropdown lookups, link records across tables, and manage structured data right from the AdminCP, with clean public-facing display pages wrapped in your forum's theme.
  
  Perfect for product catalogs, game databases, team rosters, pricing tables, inventory lists, or any structured data that doesn't fit neatly into forum threads.
  
  

  ---

  
  

  Key Features

  • Dynamic Table Definitions - Create unlimited tables, each with its own title, URL slug, description, and display order. Toggle tables active/inactive without deleting data.
  • Listed/Unlisted Tables - Hide definitions from the public table index while keeping them accessible via direct URL. "Unlisted" badge in AdminCP.
  • 8 Field Types - Build columns using: Text, Number, URL, Date, Lookup (dropdown), Table Lookup (cross-table reference), Text Area, and Yes/No (boolean). Each field supports sortable and filterable flags.
  • Field Visibility - Per-field "Show in table" toggle to hide columns from the table view while still showing them on record detail pages.
  • Lookup Columns (Relational Dropdowns) - Define dropdown options for any field. Options are stored relationally (not as flat strings), enabling clean data entry and consistent display.
  • Cross-Table Relational Lookups - Link records between tables with the Table Lookup field type. Select a linked table and a display field, and users pick from records in that table via dropdown. Values render as clickable links to the referenced record.
  • Inline "Create New" Overlay - A "+" button next to every Table Lookup dropdown opens a modal to create a new record in the linked table. Saves via AJAX and auto-selects in the parent dropdown - no page reload, no navigating away. Works in both AdminCP and public pages.
  • Friendly URLs - Records accessible at /data-tables/record/{table-slug}/{record-slug}/ with auto-generated unique slugs. Legacy URLs 301-redirect to the new format.
  • Breadcrumbs - Full navigation trail on all public pages: Home > Data Tables > Table Name > Record Title.
  • Clickable Table Rows - Click anywhere on a table row to navigate to the record detail page. Ctrl/Cmd+click opens in a new tab.
  • Record Detail Pages - Each record has its own detail page showing all fields and a "Referenced by" section listing records from other tables that point to it.
  • CSV Import - Upload CSV files from the AdminCP record list page. Supports comma, tab, semicolon, and pipe delimiters. Automatic column mapping by header name, 5-row preview, lookup resolution with optional auto-creation of missing options.
  • CSV Export - Download table data as CSV with formatted cell values (lookup labels, boolean Yes/No, table lookup display labels).
  • Inline Display Order Editing - Edit field display order values directly from the field list page without opening each field individually.
  • FontAwesome Icon Picker - Choose a custom icon for each table definition from 1,500+ FontAwesome icons (e.g., fa-car, fa-wrench, fa-database). Icons appear on the table list, table view header, and record detail header.
  • Enhanced Table List - Public table directory uses rich card rows with definition icon, description, field count, and record count badge with smooth hover transitions.
  • Unified Page Headers - Table view and record detail pages share a consistent icon + title block header pattern for visual cohesion across all pages.
  • Bulk Select & Delete - Admin record list has select-all checkbox and batch delete button with dynamic count display.
  • Admin Record Management - Full CRUD for records within the AdminCP. Dynamic forms automatically adapt to your field definitions - text fields become text inputs, lookups become dropdowns, numbers get spinners, booleans get checkboxes.
  • Public Table Display - Clean, responsive public pages at /data-tables/ showing all listed tables, with individual table views at /data-tables/{slug}/. Full theme integration.
  • Column Sorting - Mark fields as "sortable" in the admin, and users can click column headers on the public table view to sort ascending/descending.
  • Public Record Submission - Optionally allow members to submit new records from the public side (permission-controlled).
  • Multi-Select Table Lookups - Table Lookup fields can be marked multi-select for many-to-many relationships. Rendered as a multi-select dropdown (or autocomplete tags for large lists). Cell display shows comma-separated linked items with clickable links.
  • Public Edit/Delete - Record owners can edit and delete records from public pages. Controlled by dedicated permissions with sensible defaults (edit: Allow, delete: Deny).
  • Required Field Validation - Mark fields as required. Enforced across all save actions (admin and public) with clear error messages.
  • Autocomplete Search - Table Lookup fields with more than 50 options automatically switch from dropdown to AJAX autocomplete with debounced search and removable tag pills for multi-select.
  • Inline Edit Linked Record - Pencil icon next to single-select Table Lookup fields opens an overlay to edit the referenced record. Option label refreshes on save without page reload.
  • Permission-Controlled Access - Four permissions out of the box:
    • View data tables (default: Allow for all)
    • Add records (default: Deny)
    • Edit records (default: Allow)
    • Delete records (default: Deny)
  • Pagination - Both admin and public views paginate at 50 records per page.
  • AJAX Field Configuration - When editing fields, selecting "Table Lookup" dynamically shows linked table and display field dropdowns via AJAX - no page reload needed.
  • Clickable URL Fields - URL-type field values render as clickable links in both admin and public table views.
  • Clean Uninstall - All 5 database tables are dropped on uninstall. No leftover data.

  
  

  ---

  
  

  How It Works

  1. Create a Definition - Go to AdminCP > Tools > Data Tables > Add Definition. Give it a title (e.g., "Product Catalog") and a URL slug (e.g., "products").
  2. Add Fields - Click "Fields" to define your columns. For example:
     • Name (Text, Required, Sortable)
     • Category (Lookup - with options like "Electronics", "Clothing", "Home")
     • Price (Number, Sortable)
     • In Stock (Yes/No)
     • Website (URL)
     • Manufacturer (Table Lookup - linked to a "Manufacturers" table, displaying the "Name" field)
  3. Add Records - Click "Records" to start entering data. The form automatically generates the right input type for each field. Need a new linked record? Click the "+" next to any Table Lookup dropdown and create one inline.
  4. Import Data - Have existing data? Click "Import CSV" on the record list page, upload your file, map columns, preview, and import.
  5. View Publicly - Visit /data-tables/products/ to see your table with sortable columns, resolved lookup values, clickable cross-links, and clean formatting. Click any row to see its detail page at a friendly URL.

  
  

  ---

  
  

  Cross-Table Relationships Example

  Say you have two tables: "Manufacturers" and "Products". Add a Table Lookup field to Products that points to Manufacturers. Now when adding a product, users pick from existing manufacturers via dropdown. In the Products table, manufacturer names appear as clickable links to the manufacturer's detail page. On the manufacturer's detail page, a "Referenced by" section lists all products that reference it.
  
  

  ---

  
  

  Technical Details

  • Architecture: Hybrid JSON + normalized lookups across 5 database tables
    • xf_qubn_dt_definition - table definitions (title, slug, status, is_listed)
    • xf_qubn_dt_field - column definitions per table (type, options, is_show_in_table)
    • xf_qubn_dt_lookup_option - dropdown options for lookup fields
    • xf_qubn_dt_record - data rows (JSON blob per record, slug for friendly URLs)
    • xf_qubn_dt_record_ref - denormalized cross-table reference tracking
  • Performance: Lookup values resolved in a single batch query. Cross-table references tracked via denormalized table for fast reverse lookups. Composite indexes on frequently-queried columns. Paginated to 50 records per page.
  • Compatibility: XenForo 2.3.x. No class extensions - completely self-contained with zero conflicts.
  • Code Quality: PHPStan level 3 clean. 122 automated browser tests. All user input filtered. CSRF protection on all forms.
  • Upgrade: Seamless upgrade from any prior version (v1.0.0 through v1.2.1) with automatic migration steps.

  
  

  ---

  
  

  Installation

  1. Download and extract the ZIP file
  2. Upload the Qubn/DataTables/ folder to src/addons/
  3. Go to AdminCP > Add-ons > Install from archive (or Install/upgrade)
  4. Navigate to AdminCP > Tools > Data Tables to start creating tables
• Discussion

  This resource has a discussion thread on the forum where you can ask questions, report issues, and talk with the author and other users.

  Join the discussion (2)