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

Hi,

How can i set up limited value of 100% on this. I'd like to Share % was max 100% and if it is 100% you can't add more. What is the formula. I started BP and i really don't know what formula could be used

Like 2

Like

1 comments

Hello,



You can use conditional flows for your process.



In one of the conditional flows, you can use the formula:

 

[#Read Competitor...

MoreLess

Show all comments

Formula does not allow me to input current datetime.

Like 0

Like

1 comments
Best reply

Hello Joseph, 

This function is not available for the Pivot tables as mentioned in this academy article.

This function is available...MoreLess

Hello Joseph, 

This function is not available for the Pivot tables as mentioned in this academy article.

This function is available...MoreLess

Show all comments