Hi community,

In the oob version Product in order modal page when opening the business rules,

we see the Formula expression BusinessRuleFormulaExpression 

However when trying to create a rule of our own we cant apply formulas, its always the Constant Value

Is there any feature that needs to be active?

Sasor

Like 0

Like

1 comments
Best reply

Yes, you need to activate the new beta feature in 8.2.1 : https://academy.creatio.com/docs/8.x/resources/release-notes/8-2-1-ener…

Yes, you need to activate the new beta feature in 8.2.1 : https://academy.creatio.com/docs/8.x/resources/release-notes/8-2-1-ener…

Show all comments

I need to convert a decimal field into words for a report template. Can this be done with a formula or does it have to be a script?

Like 0

Like

2 comments

Hi all, 

I'm trying to calculate 60 days before a date captured by the user to create a reminder. I'm using the Formula in the Business Process but I cannot make it work, I see the following error: Formula value error: Cannot convert type "Int32" to "Entity"

Any suggestion?

Thank you

Like 0

Like

2 comments

It looks like it's an issue with trying to set the parameter you've selected to the value of the formula - what is the type of the paramete...MoreLess

Show all comments (1)

Today I saw in Creatio 8.2 something long awaited to be available in Freedom, the rule that allows you to designate a formula to a field.

But :-( when trying to designate a formula to a field, it doesn't allow me to do so and apparently what I saw is ‘on hard’ and it is not possible to add this element...MoreLess

Like 3

Like

3 comments

Hello, some feedback regarding this question?

Thanks

Show all comments (2)

I have a string field that is being populated in this format, "myfielddata-data". I need to parse the data after the "-" to use in a business process.

Like 0

Like

1 comments

Hello Justin,

string myString="myfielddata-data";

int indexRetrieved=myString.LastIndexOf("-");

string result= myString.SubString(indexRetrieved)...MoreLess

Show all comments

Hi,

I want to set a field value so that it is 1 hour BEFORE the start time field. Trying to do this via business rule but it's not letting me write a negative number (-1).

Any ideas how to do this?

Thanks,

Chani

Like 0

Like

6 comments

I did this with days but should work with hours and a date/time field.

[#System variable.Current Date#].AddDays(-7)

Updated via business process

Show all comments (5)

Dear colleagues

To implement a process who automatically cancel activities not started from more than "XX" hours from the hour they are created, I filter all activities which meet some another conditions and Created on < Previous hours XX.

I want to use a System setting if customer want to change...MoreLess

Like 0

Like

3 comments
Best reply

What I did is to create a Date/Time parameter called FechaSLA with this value 

[#System variable.Current Time and Date#].AddHours( -[#System...

MoreLess

Show all comments (2)

Does anyone know a way of using an exponential value in a formula in a business process? The C# forums say to use Math.Pow(base number, exponent number) but I get an error that "No applicable method "Pow" exists in type "Math" when using that in a business process formula. 

The use case is that there's a a 2% annual escalator based on the warranty years of a certain product. So the formula would be (base price)*1.02^(years of warranty)

Like 0

Like

1 comments

Hello Andriana,

In order to use the static “Math” class in C# code you should add the “System” namespace to the file:

using System;

I...MoreLess

Show all comments

Which I select process element and double click to generate macro, after saving the formula value is empty.

In the console getting following error--

41  Error while sending request 

    response status: 500 (ValidateException)

    request url: ../DataService/json/SyncReply/ValidateProcessFormula

    method: POST

    request data: {"formulaValue":"[#[IsOwnerSchema:false].[IsSchema:false].[Element:{f5f1d34c-ee78-41d5-8364-7d1c12b93b36}].[Parameter:{ec7648e8-b1f3-4292-b5ef-5d0cc52...

log @ all-combined.js:41

Like 0

Like

1 comments

Hi!

You have specified "RealtyTypeId". Maybe you meant "ReadTypeId"?

Looking forward to hearing from you!

Show all comments

I try to set up a business process with a formula comparing if a specific field value in a selection list is set.

It seems that there is a problem with the translation I applied to the field values, they are available in German and English.

The formula goes like this:

[#PROCESSELEMENT.First item of...MoreLess

Like 0

Like

0 comments
Show all comments