Go to your Kommo account > «Settings» > «Integrations».

Find this widget in the list or enter «Fields Calculator via Komanda F5» in the search bar.
Check the checkbox to accept Kommo's privacy policy and grant access to the account > «Install».
Now there is an additional item «Fields Calculator» in Kommo settings.

2. Create formulas using catalogs

No different from a regular formula except for the type of a field. The word «.data» is added to the field .

1. Go to Kommo «Settings» > «Fields Calculator».
2. Click the «Add new formula» button, and a formula editor window will appear.
3. Enter a name for your formula, e.g. «5% discount».
4. Enter a formula, for example: «(lead.sale - lead.cf585310) * 0.95» . You can use all mathematical operators, brackets, fields from leads, companies, or contacts.
5. To insert a field catalog into a formula, click on the blue icon to the right of the field. The icon shows that the numeric fields for the values to be used in the formula have been set for that field. This will insert «lead.cf585310.data» instead of «lead.cf585310». The formula will now use the numbers from that field's directory for the calculation, and the number itself will change depending on what is selected in the field.
6. Save the formula and check the calculation results.

1. Save the sales value of all products in the lead field

Function used:
products = GETLEADCATALOG(lead.id, 7949);
array = MAP(products, function(product) {
return product['fields'][1014880]['value'] * product['quantity'];
});
ROUND(SUMARRAY(array),2)

Change the list ID - 7949 and the list field ID - 1014880 to your custom values.

2. Save the list of products in the lead field

Function used:
function JOIN (array) {
return array.join('; ')
}
products = GETLEADCATALOG(lead.id, 7949);
array = MAP(товары, function(product) {
return product['title'] + ' ' + product['quantity'] + ' pcs.';
});
JOIN(array)

Change catalog ID - 7949 to your custom value.

3. Change the color of the lead field in Kommo

Change the color of a particular field:
cssParamsGreen = {'background':'rgb(229, 255, 243)', 'padding-left': '5px','border-radius':'4px','border': '1px solid rgb(178, 225, 198)'};
ARRAYFORMULA(
CSS(SELECTOR(false, '.linked-form__field[data-id="43921"] .linked-form__field__value',true),cssParamsGreen)
)
false;

You can change the following: background, border, padding to your custom values and colors. data-id=«43921» - can be changed to your field ID.


Change the color of a particular field according to its value:

cssParamsGreen = {'background':'rgb(229, 255, 243)', 'padding-left': '5px','border-radius':'4px','border': '1px solid rgb(178, 225, 198)'};
cssParamsRed = {'background':'rgb(255, 244, 244)', 'padding-left': '5px','border-radius':'4px','border': '1px solid rgb(255, 192, 192)'};
ARRAYFORMULA(
IF(lead.cf43923>=1000,CSS(SELECTOR(false, '.linked-form__field[data-id="43923"] .linked-form__field__value',true),cssParamsGreen),CSS(SELECTOR(false, '.linked-form__field[data-id="43923"] .linked-form__field__value',true),cssParamsRed))
)
false;

Here you can also change the field background and borders settings. If lead.cf43923 >= 1000, change its color to cssParamsRed, otherwise cssParamsGreen. Change to your custom values.


Change the color of the lead field depending on the values of other field:

cssParamsGreen = {'background':'rgb(229, 255, 243)', 'padding-left': '5px','border-radius':'4px','border': '1px solid rgb(178, 225, 198)'};
cssParamsRed = {'background':'rgb(255, 244, 244)', 'padding-left': '5px','border-radius':'4px','border': '1px solid rgb(255, 192, 192)'};
cssParamsYellow = {'background':'rgb(240, 247, 154)', 'padding-left': '5px','border-radius':'4px','border': '1px solid rgb(255, 192, 192)'};
ARRAYFORMULA(
IF((lead.cf43929.value-10800)==DATEUNIX(DATEFORMAT(NOW(),'M.D.YYYY')),CSS(SELECTOR(false, '.linked-form__field[data-id="43931"] .linked-form__field__value',true),cssParamsYellow),IF(lead.cf43929.value>DATEUNIX(DATEFORMAT(NOW(),'M.D.YYYY')),CSS(SELECTOR(false, '.linked-form__field[data-id="43931"] .linked-form__field__value',true),cssParamsGreen),CSS(SELECTOR(false, '.linked-form__field[data-id="43931"] .linked-form__field__value',true),cssParamsRed)))
)
false;

If the field 43929 value is equal to the current date, the background color of the field 43931 changes into «yellow». If the value is bigger - the color will be green, if less - red. Change to your custom values or conditions.