Use JS in formula??

[saschavalentin]

Is it possible to use Javascript in formula?

I ask, because I have an multi-enum field and the count of the selected values must by multiplied with another field value. Could this be solved with the formula function??

[tanya]

Hello,
formula works only on backend side, where javascript is unavailable. It triggers before record saved. But if I understand you well, you can do what you want with formula-language

https://github.com/espocrm/documentation/blob/master/docs/administration/formula.md#arraylength

[saschavalentin]

Hi Tanya,

so would the syntax be "array\length(fieldname)"?

Where fieldname is the name of the multi-enum field? But I only want to count the selected values.

[tanya]

It is a count of selected values

For example a field name is test
description=string\concatenate(array\length(test)* 3, '')

[saschavalentin]

Tried it and it works. I would be lost without you :-)
Thanks!