Where can I get all details on allowed formula systax and possible functions allowed to use
For example I was working to extract month & year from date and it was not so easy to understand best function allowed in business process formulas windows.

Looking for more details in addition to what we can see here:
https://academy.creatio.com/docs/8.x/no-code-customization/bpm-tools/bu…

Like 0

Like

1 comments

Formulas are C#. Creatio does have a few built in functions that can be used in formulas, but for the most part, it's a better approach to just think of it as C#. For extracting the month and year from a date, you'd just use C# syntax for Year and Month. For example:

[#SomeDate#].Year

Ryan

Show all comments

i am using 8.2.2

i am trying to set the value of a number field called Lama Bekerja based on the months inputted in Mulai Bekerja accounting the year aswell, i know that using business rules where you can use set value = formula like so...

now when i open it, it doesn't let me do the calculations

can someone explain a method on how to implement this in creatio 8.2.2?

Like 1

Like

2 comments
Best reply

Hello,

As far as we understand,  you are referring to the fact that the "Mulai Bekerja" field is not available for selection in the formula setup.

This is most likely because Creatio currently supports only numeric fields in business rule calculations. Date fields, such as "Mulai Bekerja," are not supported in this context.

Please let us know if you'd like assistance implementing this logic using a business process instead.

Hello,

As far as we understand,  you are referring to the fact that the "Mulai Bekerja" field is not available for selection in the formula setup.

This is most likely because Creatio currently supports only numeric fields in business rule calculations. Date fields, such as "Mulai Bekerja," are not supported in this context.

Please let us know if you'd like assistance implementing this logic using a business process instead.

Valeriia Hromova,

i have already tried using the business process however am unable to find the year function, so i would like some support here

Show all comments

Hi

I have created a Column(Days) which is an integer value and trying to store it in an Integar I get a formula error. What coud be the issue

Like 0

Like

2 comments

Create a new Date parameter in the business process. Put the result of the formula into it and then change your Column(Days)

 

This likely has more to do with the type of the parameter you're putting the result of the formula into. Make sure the param is an int data type. 

Ryan

Show all comments