Data Tables 1.4.6

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+