Promotions

New products

  • Optical Store Management – Complete Optician Platform for Dolibarr

    Turn Dolibarr into a complete optical store platform: dashboard, patients, appointments and agenda, eye examinations, prescriptions, frames, corrective lenses, contact lenses, accessories, workshop jobs with a Kanban workflow, repairs, warranties, health insurance claims, quotations, native invoicing, stock lots and expiry, suppliers, documents, alerts and reporting.

    299.00 €
  • Setup NC – New Caledonia localization

    Turns Dolibarr into a New-Caledonia-ready ERP in one click: TGC instead of VAT, XPF currency, local number format and TGC rates.

    FREE

SQL WIDGETS

mp12371d20260305193452

Create custom SQL-powered widgets on your dashboard: KPI numbers, data tables and charts, driven by your own SELECT queries.

99.99 €
Excl. tax

Previous Next
  • Author S2IRD
  • Module version 1.1.0
  • Release date 03/05/2026
  • Access to download and updates 1 year
  • How to contact support contact@s2ird.fr
  • Compatibility Dolibarr V20 - V24   -   PHP>= 7.2
  • Last update 08/07/2026 08:29 AM

More info...

SQL Widgets lets you build fully customized visual indicators on the Dolibarr home page in just a few clicks, with no coding required.

Create three types of widgets powered by your own SQL queries:

  • Numbers — KPI tiles with a main value, two optional sub-indicators, an icon (Dolibarr picto, FontAwesome or emoji) and free color choices. They integrate directly into Dolibarr's native statistics area.
  • Tables — Data lists with configurable columns, automatic type formatting (text, integer, price with currency, percentage), colored status badges and clickable links to Dolibarr records.
  • Charts — Bar, line or doughnut visualizations rendered via Chart.js, with a customizable color palette.

Access is secured by user group: each widget is visible only to the groups you authorize. Data formatting automatically respects the language and currency configured in Dolibarr.

 




If you think this module is a fork of another one (published after the first one) or violates some terms or conditions of use (for users or vendors), you can make a report at dolistore@dolibarr.org