[qubn] Data Tables 1.3.2

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+

---

Data Tables v1.3.1 - upgrade step slug unique key sequencing fix​

Fixes DuplicateKeyException when upgrading from v1.2.x with existing records. Unique key now added after slug data migration completes.

---

Data Tables v1.3.0 - Friendly URLs, CSV Import/Export, Icon Picker, and Enhanced UI​

v1.3.0 adds friendly record URLs with breadcrumbs, clickable table rows, CSV import and export, field visibility controls, unlisted table definitions, per-definition FontAwesome icon picker, enhanced public page layouts, bulk record operations, and inline field display order editing.

New Features​

• Friendly URLs - Records are now accessible at /data-tables/record/{table-slug}/{record-slug}/ with auto-generated unique slugs. Legacy ?record_id=N 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. Action buttons still function independently.
• Field visibility - Per-field "Show in table" toggle to hide columns from the table view while still displaying them on record detail pages.
• Unlisted definitions - Hide tables from the public index while keeping them accessible via direct URL. "Unlisted" badge in AdminCP.
• CSV Import - Upload CSV files from the AdminCP record list page. Supports comma, tab, semicolon, and pipe delimiters. Automatic column mapping, 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 field display order - Edit display order values directly from the field list page without opening each field individually.
• FontAwesome icon picker - Per-definition custom icon selectable from 1,500+ FontAwesome icons (e.g., fa-car, fa-wrench, fa-database). Displayed 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 use a consistent icon + title block header pattern for visual cohesion across all Data Tables pages.
• Bulk select & delete - Admin record list has select-all checkbox and batch delete button with dynamic count display.

Changed​

• Record detail URL changed from /data-tables/{slug}/view-record?record_id=N to /data-tables/record/{slug}/{record-slug}/
• Table view headers respect the field "Show in table" setting
• Record slugs are stable - editing a record no longer changes its URL
• Table lookup autocomplete mode (>50 options) uses count-first strategy instead of loading all records into memory

Fixed​

• Lookup option ID stability - Editing a lookup field (e.g., adding a new option) no longer reassigns option IDs, so existing records keep their values
• Boolean required validation - Boolean fields marked "required" no longer block record creation with false-positive errors
• Definition slug upgrade step - Upgrading from v1.2.x now correctly adds the slug column to definitions
• Case-insensitive option matching - Renaming a lookup option's casing preserves the option ID
• Lookup zero-value rejection - Option ID 0 is no longer accepted as valid
• Orphaned table lookup display - Deleted targets now show "(Unknown)" consistently
• Field type change cleanup - Changing a field type now clears stale reference IDs from records
• syncRecordRefs transaction safety - Record reference sync wrapped in transaction
• CSV import path traversal - File path validation prevents directory traversal attacks
• Cross-definition validation - Admin controller now validates field/record ownership across table definitions

Upgrading​

Upload the ZIP via Admin CP > Add-ons > Install/upgrade from archive. Seven automatic migration steps handle everything: adding slugs to definitions and records, generating slugs for existing data, adding field visibility and definition listing columns, adding the icon column, and creating indexes for slug lookups. No manual steps required. Existing record URLs will 301-redirect to the new friendly format. All permissions and data are preserved.

Requirements​

• XenForo 2.3.0+

Data Tables v1.2.1 - Permission fix​

v1.2.0 had an empty permissions.xml which caused the Data Tables permission group to disappear after upgrading. This release restores all 4 permission definitions (viewDataTable, addRecord, editRecord, deleteRecord).

After upgrading to v1.2.1, go to Admin CP > Groups & permissions > User group permissions, you should see the "Data table permissions" group with all 4 permissions configurable.

If you already set permissions before v1.2.0, you may need to re-configure them.

---

Data Tables v1.2.0 - Multi-Select, Public Edit/Delete, Autocomplete & More​

v1.2.0 adds multi-select table lookups, public edit/delete permissions, required field validation, autocomplete search for large lookup lists, and inline edit for linked records.

New Features​

• Multi-select table lookups - Table Lookup fields can now be marked as multi-select for many-to-many relationships. Rendered as a multi-select dropdown (or autocomplete tags when >50 options). Cell display shows comma-separated linked items with clickable links to each.
• Public edit/delete - Records can now be edited and deleted from public pages. Two new permissions: "Edit records" (default: Allow) and "Delete records" (default: Deny). Edit and Delete buttons appear on both table view rows and record detail pages.
• Required field validation - Fields can be marked as required. Validation is enforced across all 4 save actions (admin create/edit, public create/edit) with clear error messages.
• Autocomplete search - Table Lookup fields with more than 50 options automatically switch from a standard dropdown to an AJAX-powered autocomplete with debounced search. Multi-select uses removable tag pills.
• Inline edit linked record - A pencil icon appears next to single-select Table Lookup fields. Click it to open an overlay and edit the referenced record in-place. The option label refreshes on save without page reload.
• Overlay form reset - After overlay save, the container DOM is removed to force a fresh fetch on next open, preventing stale form data.

Fixed​

• Display field dropdown - Fixed the display field dropdown not populating when selecting a linked table for Table Lookup fields (reported by briansol).
• Deleted record references - Skip deleted record references instead of showing broken links in "Referenced by" sections.
• Button styling - Consistent text-only action buttons across admin and public views with proper inline-flex layout and matching button sizes.
• Inline styles extracted to LESS - All static inline styles moved to addon LESS files using XF theme variables for full theme compatibility.
• Lookup field options - Added "Add option" button so you can add unlimited lookup options without saving and reloading (reported by briansol).
• Table lookup display labels - Dropdowns and record lists now show the first text value from linked records instead of "#1", "#2" or "Record detail #N" when display field is not explicitly set (reported by briansol).
• Accessibility - Autocomplete widget now includes proper ARIA attributes (role=combobox, aria-expanded, role=listbox, role=option).

Upgrading​

Upload the ZIP via Admin CP > Add-ons > Install/upgrade from archive. One automatic upgrade step adds the is_multi_select column to the field table and registers the new edit/delete permissions. All existing data is preserved. Seamless upgrade from v1.0.0 or v1.1.0.

Requirements​

• XenForo 2.3.0+

Data Tables v1.1.0 - Cross-Table Relational Lookups & Inline Record Creation​

v1.1.0 adds cross-table relational lookups and inline record creation via overlay.

New Features​

• Cross-table relational lookups - a new "Table Lookup" field type lets you reference records from another table. Select a linked table and choose which field to display as the label. Users pick from existing records via dropdown, and values render as clickable links to the referenced record's detail page.
• Inline "Create New" overlay - a "+" button appears next to every Table Lookup dropdown. Click it and a modal opens with the linked table's record form. Fill it out, save, and the new record is automatically selected in the parent dropdown - no page reload, no navigating away. Works in both AdminCP and public pages (permission-gated).
• Record detail pages - every record now has its own page at /data-tables/{slug}/view-record?record_id=N showing all fields in a clean layout. A "Referenced by" section at the bottom lists records from other tables that point to this one - giving you automatic reverse navigation between related data.
• Clickable cross-links - Table Lookup values display as clickable links in both admin and public table views. Click a manufacturer name in a products table and jump straight to that manufacturer's detail page.
• Clickable URL fields - URL-type field values now render as clickable links (safe protocols only - http/https).
• AJAX field configuration - when editing fields in the AdminCP, selecting "Table Lookup" as the field type dynamically loads linked table and display field dropdowns via AJAX - no page reload needed.
• Reference tracking - denormalized xf_qubn_dt_record_ref table for fast reverse lookups between tables.
• 17 new phrases for relational lookup and overlay UI.

Changed​

• Cell output restructured to support clickable cells in both admin and public views.
• Setup.php refactored to use getTables() helper (prevents install/uninstall drift).
• URL field values validated for safe protocols.

Fixed​

• Definition deletion now cleans up orphaned linked_definition_id references in other tables' fields.

Upgrading​

Upload the ZIP via Admin CP > Add-ons > Install/upgrade from archive. Two upgrade steps run automatically to add the new xf_qubn_dt_record_ref table and linked_definition_id / display_field_key columns to the field table. All existing data is preserved. Database tables: 5 (was 4). No class extensions - zero conflict risk.

Requirements​

• XenForo 2.3.0+