Calculation Engines Overview

In NocoBase, calculation engines are integral to formula fields, linkage rules, and workflows, providing users with versatile computational tools.

Formula.js

Formula.js is a lightweight JavaScript library that replicates many of Microsoft Excel's formula functions. It enables users to perform complex calculations effortlessly. Key features include:

• Extensive Function Library: Offers a wide range of functions for various mathematical operations, including statistical and financial calculations.
• User-Friendly API: Designed for ease of use, allowing both developers and non-developers to create formulas without extensive coding.
• Real-Time Calculations: Optimized for real-time data processing, making it suitable for applications requiring immediate computational feedback.

Math.js

Math.js is a comprehensive mathematics library for JavaScript and Node.js. It supports a broad spectrum of mathematical operations, from basic arithmetic to advanced algebra, statistics, and linear algebra. Key features include:

• Comprehensive Functionality: Provides an extensive array of functions for all types of mathematical operations.
• Flexible Expression Parsing: Capable of parsing and evaluating mathematical expressions in string format.
• Advanced Calculations: Supports matrix operations, symbolic computation, and statistical analysis, among other advanced mathematical functions.
• Extensibility: Can be extended with custom functions and constants to meet specific needs.

Application in NocoBase

By integrating Formula.js and Math.js, NocoBase users can:

• Execute a Wide Range of Calculations: From simple arithmetic to complex mathematical operations, enhancing the computational capabilities of their applications.
• Develop Robust and Efficient Applications: Build applications that require precise and powerful mathematical computations, ensuring reliability and performance.
• Boost Productivity: Utilize pre-built functions to reduce the need for extensive custom code, thereby improving development efficiency.

These libraries are pivotal in NocoBase's no-code platform, enabling users to create flexible and customizable calculation logic without delving into complex coding. This approach simplifies the development process while enhancing the functionality and adaptability of applications.