OdooWiki OCA HUB

Web Widget - Formulas in Float Fields

web_widget_float_formula folder_open OCA/web open_in_new
Web License: AGPL-3

This module allows the use of simple math formulas in corresponding fields: =45 + 4/3 - 5 * (2 + 1)

Features:

  • + (addition)
  • - (subtraction)
  • * (multiplication)
  • / (division)
  • % (modulus)
  • ( and ) parentheses

auto_awesome What this module does

AI-generated from the code · Odoo 12.0

Lets users type simple math formulas (like =45 + 4/3 - 5 * (2 + 1)) directly into numeric and money fields in Odoo, and Odoo calculates and stores the result.

This module changes how numeric and monetary fields behave while you are editing them in Odoo. Instead of typing only a plain number, you can type a small math formula starting with the equals sign, for example =45 + 4/3 - 5 * (2 + 1). Odoo evaluates the formula and saves the calculated result in the field.

  • Supported operations: addition, subtraction, multiplication, division, modulus (remainder) and parentheses.
  • When you leave the field, the calculated number is shown; when you click back into the field, the original formula is shown again so you can check or change it.
  • If the formula cannot be calculated, the field simply keeps the text you typed and no result is stored.

There are no new menus or screens: the feature is added to the existing numeric and monetary fields already used throughout Odoo forms. It works in edit mode only, and it applies to the standard numeric field and the monetary field widgets.

The module only depends on the web module and adds its behaviour through the backend assets, so it is available wherever those field types appear. No new database models, reports, emails or scheduled actions are created.

Depends on

web

Text generated by AI (DeepSeek) from reading the Odoo 12.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

terminal Installation and usage

No verified information

Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.