Working with formulas in Rukovoditel Set the order of actions with numbers, values in a field or a group of fields. Rukovoditel - Free Project Management Software
Open Source ERP and CRM Software
Rukovoditel
Web Application Designer for Business.

Formulas

Set the order of actions with numbers, values in a field or a group of fields.

To work with mathematical calculations in program Rukovoditel there are two types of fields: "MySql Formula" and "JS Formula". By analogy with the Excel table cell, this field displays the result of the specified arithmetic operations. When you create such a field, you specify the fields whose values you want to use and the calculations that you want to perform.

MySql Formula - Rukovoditel - Open Source Project Management Software

MySql Formula

Mathematical calculations occur after entering data into the database. This formula is built into the MySql query, which gives you the ability to use any mathematical MySql functions for calculations, as well as other MySql functions and operators. Also, you can apply functions from the Extension to perform calculations from other database tables. Read more in the article "How to use formulas and functions?".

JS Formula - Rukovoditel - Open Source Project Management Software

JS Formula

Mathematical calculations occur directly in the form of adding/editing a record when entering data. The calculations take place using JavaScript, which allows you to use any mathematical functions and operators of JavaScript language.

get_value() - Rukovoditel - Open Source Project Management Software

get_value()

For fields of type List, you can set the values of each option, and with internal function get_value () you can use these values in the formula fields.