HomeModulesAnalytics & DashboardsWeb Widgets Pack - Data
Web Widgets Pack - Data
Analytics & DashboardsAuraOdoo Verified

Web Widgets Pack - Data

Five data widgets: data_grid, kpi_tile, radar, waterfall and csv_preview.

Technical Specifications & Compatibility

Technical Module Name
Supported Odoo Versions
v19.0
License
LGPL-3.
Deployment Support
Odoo OnlineOdoo.shOn Premise
Lines of Code
2477 lines (Python / XML / JS)

Overview & Description

Aura Odoo Tech Supports:CommunityEnterprise Data Widgets Version 19.0.1.0.0: numbers on a record, made readable A table, a KPI, two charts and a CSV preview, right on the form. Five field widgets for numbers that belong to one record. Paste a table in from a spreadsheet, see a KPI with its trend, read a scorecard, follow a bridge from opening to closing, and check a CSV before you trust it. ✓Paste a block from a spreadsheet straight into a grid ✓A KPI tile shows the change, the trend and the target ✓Preview an uploaded CSV, with sorting, search and totals Built on Spreadsheet-style grid KPI, radar, waterfall Depends on Web only 5 field widgets in one module 44 options to fit your forms 3 table shapes read: matrix, named columns, records 1 dependency: Odoo Web why you will like it Numbers you can read at a glance Each widget replaces a one2many, a pivot or a separate file viewer with one control on the field itself. Paste from a spreadsheet A block copied from a spreadsheet lands in the grid whole and grows it to fit. A single value still pastes as ordinary text. Numbers stay numbers Cells are stored as numbers and totalled per column. A reference such as 0012 stays text, so its zeros are not lost. Spreadsheet keys Enter and the up and down arrows move between cells. The right arrow only jumps at the end of the text, so you can still edit it. Escape puts the value back. A KPI that shows where it is going One big number with the change against the previous period, a trend line and progress to the target. All three come from ordinary fields on the same record. Down can be good news For costs and churn, the invert option turns a fall green. The trend line takes the same colour. A scorecard in one field A handful of scores is drawn as a radar chart. Two series overlay, so you can see what changed since last time. A bridge that adds up The steps between an opening and a closing total are drawn as a waterfall. The last bar is always the running total, so the chart cannot disagree with itself. Check a CSV before you use it The delimiter is found for you, the header row is recognised, quoted fields are read properly, and every column is typed. Number columns can be totalled. Sort, search and page Sort by any column, search across all of them, and load more rows on demand. Reading stops at max_bytes and the widget says so. one attribute each Add it to a field Set the widget on a field of the matching type and name the fields it should use. Every option has a default. data_grid textjson A table in one field, edited like a spreadsheet. It reads a bare matrix, a matrix with column names or a list of records, and writes back the shape it found. <field name="price_matrix" widget="data_grid" options="{'totals': true, 'height': 280}"/> Options: columns (names for a new, empty grid, comma separated), totals, max_rows (200), max_columns (30), height (pixels), structure (false fixes the shape; the cells stay editable). kpi_tile floatintegermonetary One number with its change, a trend line and a target bar. The comparison, the trend and the target are other fields on the same record. <field name="revenue" widget="kpi_tile" options="{'compare_field': 'revenue_previous', 'spark_field': 'revenue_trend', 'target_field': 'revenue_target'}"/> Options: label, compare_field, compare_label, spark_field (a list of numbers), target_field, target, currency_field, prefix, suffix, digits, compact (above 10 000), invert (a fall is good), size (sm, md or lg). radar chartextjson A handful of scores drawn as a radar chart. It takes a bare list, an object of name to value, pairs, or named axes with one or more named series. With fewer than three axes it shows a dash. <field name="skills" widget="radar" options="{'max': 10, 'levels': 5}"/> Options: size (pixels), max (by default rounded up from the data), levels (rings), labels, legend, colors (one per series), digits. waterfall chartextjson The steps between an opening and a closing total. A step with no value, or one flagged as a total, is a subtotal drawn from zero. <field name="margin_bridge" widget="waterfall" options="{'unit': '€'}"/> Options: width, height, show_values, connectors, digits, unit, up_color, down_color, total_color. csv_preview binarytext The contents of an uploaded CSV as a table, with sorting, search and optional column totals. The file is chosen and removed from the widget itself. <field name="import_file" widget="csv_preview" options="{'filename_field': 'import_filename', 'stats': true}"/> Options: max_rows (rows per page, 200), max_bytes (1 000 000), delimiter, header (auto, yes or no), search, stats, height, filename_field, download. see it in action Real screens, real demo data Every picture below is a capture of the widgets running in Odoo 19. The CSV is a small sample file chosen through the widget, the list shows the two demo records, and the sample data behind the KPI, the radar and the bridge is the demo data. The demo record One record uses all five widgets. The KPI and the radar are at the top. The waterfall, the price matrix and the CSV preview are in tabs. One number, three answers The number, the change against last quarter, the trend line and the progress to target. The previous value, the trend and the target are other fields on the record. Options change what a tile says The same field four ways. A fall is red by default, and invert makes it green for costs. Prefix, suffix and compact off give $48,200/mo. A fixed target gives 96% of 50.0k. A scorecard in one field Five scores out of ten for this year and last year, overlaid. The rings run to the max option, and every point carries its value as a tooltip. Several shapes, several options Pairs of name and value work too. Colours, max, rings and size are options, and labels false gives a bare chart. The chart that explains a difference Rises are green, falls are red and the closing bar is the running total. Dashed connectors carry the total from one bar to the next. Subtotals and colours A step flagged as a total is drawn from zero as the running total, so Subtotal reads 140. Colours for rise, fall and total are options, and connectors and value labels can be switched off. A table in one field Column names are editable. Numbers are right-aligned and summed in the footer. The value is stored as JSON in a text field. Paste a block and the grid grows A block copied from a spreadsheet was pasted at Medium. It landed whole, added two rows, and the totals followed. Check the file before you use it Name, size, rows, columns and delimiter sit at the top. A quoted comma, doubled quotes and a line break inside a value each stay in one cell. Number columns get a sum and an average, and the others a count of distinct values. Sort and search Click a column to sort, click again to reverse, and a third time to restore the file order. The search box looks in every column, and the totals follow the rows that match. The same widgets in a list A small size, no labels and no legend make the tile and the radar fit a row. The second record shows a fall in red. how it works Three steps to a data form 1 Add the widget Put widget="data_grid", "kpi_tile", "radar", "waterfall" or "csv_preview" on a field of the matching type. 2 Name the fields it uses A KPI takes compare_field, spark_field and target_field. A CSV takes a filename_field. The rest need nothing. 3 Fill in and save Paste, type or upload, then save. The value goes into the field like any other. setup Configure in two minutes Use it on your own model ✓Add a Text field for a grid, a radar or a waterfall. The value is JSON text ✓For a KPI add a Float field, and optionally fields for the previous value, the target, and a Char holding the trend as a comma separated list ✓For a CSV add a Binary field and a Char for the file name ✓Edit the form view and set the widget on each field ✓Upgrade your module and open a record Try the demo first ✓Turn on developer mode ✓Open Settings → Technical → Widgets Demo (Data) ✓Open the Data widgets demo record ✓Paste a block into Price Matrix, or choose a CSV in Import File good to know Questions Which Odoo versions and editions? Odoo 19.0, Community and Enterprise. It depends only on the Web module. What can the grid read? A bare matrix such as [[1, 2], [3, 4]], a matrix with column names, or a list of records. It writes the value back in the shape it found. Numbers are stored as numbers, and something like 0012 stays text. How does the KPI treat a change? A rise is good and a fall is bad, unless you set invert. Above ten thousand the value is shortened to 184.5k. Against a zero or across a sign change there is no meaningful percentage, so the plain difference is shown. Which CSV files can it read? Comma, semicolon, tab and pipe separated files, with or without a header row. Quoted fields, doubled quotes and line breaks inside a value are read properly, and numbers written as 1.234,56 count as numbers. How large a CSV is fine? The preview reads up to max_bytes, about 1 MB by default, and says when it stopped. A 1.3 MB test file opened and showed that message. The file itself is stored whole. Where is the CSV kept? In the binary field, like any uploaded file. After you save, the preview reads the file back from the server. Can the KPI use a monetary field? The widget lists monetary as a supported type. The demo model has no monetary field, so we have not captured that case. Does it load anything from the internet? No. It has no CDN and no external script. During our test session the browser made no request to any address other than the Odoo server. License LGPL-3. Developed by Aura Odoo Tech, https://www.auraodoo.tech. support We are here to help Written and maintained by Aura Odoo Tech. Email Questions, problems or a setting you need — write to us directly. odooaura@gmail.com Website More Odoo modules, documentation and customisation services. www.auraodoo.tech

Key Capabilities & Features

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.

Screenshots & Previews

13 images available
Web Widgets Pack - Data screenshot 1
Expand Preview
Web Widgets Pack - Data screenshot 2
Expand Preview
Web Widgets Pack - Data screenshot 3
Expand Preview
Web Widgets Pack - Data screenshot 4
Expand Preview
Web Widgets Pack - Data screenshot 5
Expand Preview
Web Widgets Pack - Data screenshot 6
Expand Preview
Web Widgets Pack - Data screenshot 7
Expand Preview
Web Widgets Pack - Data screenshot 8
Expand Preview
Web Widgets Pack - Data screenshot 9
Expand Preview
Web Widgets Pack - Data screenshot 10
Expand Preview
Web Widgets Pack - Data screenshot 11
Expand Preview
Web Widgets Pack - Data screenshot 12
Expand Preview
Web Widgets Pack - Data screenshot 13
Expand Preview
The AuraOdoo Quality Guarantee
100% Tested

Verified with Odoo 17, 18, and 19 test pipelines for stability and no conflicts.

Clean Architecture

Built according to official Odoo guidelines and PEP 8 standards with zero bloat.

Dedicated Support

Free installation assistance and quick bug turnaround from our team.