Question

I'm creating a business process, and I want to compare two date fields, the result of this difference should provide me with the number of days that a particular item lasts in other integer field. Problem with formula or it should be faster with sql ?

 

RoundOff(([#data zakonczenia.First item of resulting collection.Data planowanego zamknięcie#]-[#data rozpoczecia.First item of resulting collection.Data rozpoczęcia#]).TotalDays)

error: 

Formula value error: Cannot convert type "Double" to "Boolean"

Like 1

Like

5 comments

Two thoughts, where do you get the RoundOff() function from, it doesn't look like a C# function (should it not be Math.Round()).

 

It may or may not be this, but if your code is OK (and the total days calculation looks fine), is the error in code elsewhere that is being published at the same time as your total days code?

it is just formula in business process. I have two dates field: begin date, end date. I must compare this and result should be in third field Integer only days but as an integer. This is what i must do. 

The error is likely because you're attempting to put the result of the formula in a boolean param or column and it's not a boolean, it's a double. If you're wanting to know if the number of days is greater than 5 days, for example, you could use the following, which would be a boolean:

RoundOff(([#data zakonczenia.First item of resulting collection.Data planowanego zamknięcie#]-[#data rozpoczecia.First item of resulting collection.Data rozpoczęcia#]).TotalDays) > 5

Ryan

I need to know the exact number of days because I will be using this information further, so the only way is to validate this?

 

Arkadiusz Polus,

if you need to know the number of days just make sure you putting the result of the formula in an integer param, not Boolean. 
Ryan

Show all comments

Hello Community!

 

I'm trying to fill a field with the result of a simple calculation (e.g. field A - field B).

 

However, when I create the business rule and select "set field" as action, I can only provide a constant value and not a formula...am I missing something?

 

Here is a screenshot of the 

 

I know that I can use a business process to achieve this, but this would be much more simpler and elegant I think.

 

BR,

Robert

Like 0

Like

4 comments
Best reply

It's not yet available in Freedom UI --> Creatio Roadmap indicates for Q4 2023 https://academy.creatio.com/docs/release/creatio-roadmap?check_logged_i…

I forgot to add that I use version 8.0.10.4735

It's not yet available in Freedom UI --> Creatio Roadmap indicates for Q4 2023 https://academy.creatio.com/docs/release/creatio-roadmap?check_logged_i…

Damien Collot,

Thanks Damien, at least I know that I did overlook something.

Hi Damien,

I do not have access to the link to the roadmap.

I get this message:

"

Access denied

You are not authorized to access this page.

"

Is it restricted?

It is very interesting information.

Thanks,

Luis

Show all comments

Hello,

In Classic UI we have used related object fields for business rules

How can we do the same in Freedom UI?

 

Thank you!

Like 0

Like

3 comments

@Damien, is this link now offline for you also? Can’t seem to access it! Anything in the roadmap with regards to improved analytics/excel reporting by any chance?!

Hello,

 

Linking a column filter of the current object with another unrelated object is currently not possible. We only operate on the object and its own columns (including columns through direct relationships). 

Show all comments
Hello. 
Hello.

I need to send an image through an API to convert it to base 64, I tried to do it using the Web service tool but it does not allow me to place an image or file field to use it from the bpm, I was looking for some information and I saw that it could be done using a script, I just haven't found a way to do it. Could you help me with some example or idea so I can do this please?

 

 

 

Like 0

Like

1 comments

Hello Laura, 

 

Please refer to this article for more detailed information about such functionality.  

Also, similar questions have already been discussed in the below posts, please review them for the detailed information:

https://community.creatio.com/questions/there-option-send-image-file-re…
https://community.creatio.com/questions/file-type-request-parameter-res…

Please inform us in case of any questions!
Best regards,
Anastasiia

Show all comments

Dear Community,

 

We are having an issue while connecting to our plateform's mobile application for all users. An error occurs when we try to test it after setting up workplaces, list of sections, pages and details in the mobile app wizard config and binding workplaces data.

 

below is the error displayed in the message log:

Model Name: SM-A525F
Platform: Android
Platform Version: 12
Resolution: 412x867
IsHybridMode: true
RootAppDirectory: creatio
ApplicationVersion: 8.1.0
ApplicationMajorVersion: 8.1
UseNativeSynchronization: true
UseNativeImport: true
UseNativeExport: true
UseNativeLogout: true
UseNativeMetadataSync: true
UseNativeFullSynchronization: true
UseDataService: true
IsDevMode: false
CurrentDateTime: 2023-09-22T16:53:52.064Z
ServerUrl: Url
ContactId: 96b911ed-39f0-4ca1-b828-d816b829d145
CultureName: en-US

ApplicationRevision: null
WorkplaceCode: Chartering
ProductInfo: {"ProductName":"Creatio","ProductEdition":"studio","CustomerId":"111","Version":{"Major":8,"Minor":0,"Build":6,"Revision":3439,"MajorRevision":0,"MinorRevision":3439}}

Type: Terrasoft.ServerException
Message: Server request returned error
AdditionalInfo: {
"statusCode": 500,
"url": "platformUrl/ServiceModel/MobileMetadataService.svc/Load/Chartering/en-US"
}
Stack trace:
Class.getServiceFailureException(terrasoft-all-combined.js:34788:29)
Class.getExceptionFromResponse(terrasoft-all-combined.js:5953:19)
Function.getExceptionByType(terrasoft-all-combined.js:53101:41)
Function.getException(terrasoft-all-combined.js:53156:21)
Function.processFailure(terrasoft-all-combined.js:36719:55)
terrasoft-all-combined.js:36791:20
Object.callbackFromNative(cordova.js:295:52)
processMessage(cordova.js:1081:17)
processMessages(cordova.js:1104:9)
pollOnce(cordova.js:973:9)
pollOnceFromOnlineEvent(cordova.js:960:5)

 

Any help would be appreciated.

 

Thank you in Advance,

Mouna.

Like 0

Like

1 comments

Hello,

 

To resolve your issue please go to advanced setting -> Action -> generate source code for all schemas. Then make the "compile all". In case, if this issue continues to reproduce please send us the letter or register request via the portal with a detailed description of the problem. Add the information about the instance on which you have this issue and provide external access to this website. Also, please send the credentials for the mobile application. 

Show all comments

Hi all,

How do we connect section wizard in "navigation and sections" of created Application?

 

Like 0

Like

1 comments

Hello,

 

Could you please describe what logic exactly you want to achieve?

Show all comments

Hi everyone, 

I have a question regarding filters within the Campaign feature. Here is the scenario.

We have an email that we want to send as part of a campaign, we will call it "Email A". Now, we only want to have "Email A" sent to our customers if:

A) They have not received "Email B" in the past 45 days.

AND

B) They have not received Email C this year.

 

How could this be setup as a filter within this campaign? Thanks in advance for any assistance. 

Best,

Lucas

Like 0

Like

2 comments

Hello,

 

To implement your filtering logic please set up the filter like in this screenshot to the "Add audience" element: 

Viktoriia Hrynchuk,

Thank you for this logic, it truly helps. In looking at this logic, regarding the "Bulk Email" recipient category, I assume there is also a "Trigger Email" recipient category, correct?

A few things to note here:
1) The emails involved in this scenario are trigger emails not bulk emails.

2) The selection "exists" in the criteria you noted does not exist in our platform. Is this something that needs to be added?

Show all comments

Hi all,

Does anyone have experience using batch updates via the API and atomicity function. 

 

I have followed the documenation similiar to the below, both with and without the prefer header. My understanding is that if one of the requests below fail, then any successful ones in the array will be rolled back. However, this doesn't seem to be happening. 

On use of the below, if the second POST fails, the first POST still appears in the database.

 

Any help greatly appreciated 

 

{
	"requests": [
	{
		"method": "POST",
		"atomicityGroup": "g1",
		"url": "City",
		"id": "t3",
		"body": {
			"Id": "62f9bc01-57cf-4cc7-90bf-8672acc922e3",
			"Name": "Spokane"
		},
		"headers": {
			"Content-Type": "application/json;odata=verbose",
			"Accept": "application/json;odata=verbose",
			"Prefer": "continue-on-error"
		}
	},
	{
		"method": "POST",
		"atomicityGroup": "g1",
		"url": "City",
		"id": "t2",
		"body": {
			"Name": "Texas"
		},
		"headers": {
			"Content-Type": "application/json;odata=verbose",
			"Accept": "application/json;odata=verbose",
			"Prefer": "continue-on-error"
		}
	}
	]
}

 

Like 0

Like

2 comments

Hello Harry,

Batch request is simply a set of separate requests for optimization of a call process. If the first transaction succeeds but the second fails, the database updates made in the first transaction aren’t rolled back. Here you can find useful information how to use batch in the right way:

http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-…

Best regards, Anhelina

Anhelina,

Thanks Anhelina, I'm not sure that's quite right though... Here is an extract from the link you provided:

 

The value of atomicityGroup is a string whose content MUST NOT be identical to any value of id within the batch request, and which MUST satisfy the rule request-id in [OData-ABNF]. All request objects with the same value for atomicityGroup MUST be adjacent in the requests array. These requests are processed as an atomic operation and MUST either all succeed or all fail. Requests within an atomicity group that may have otherwise succeeded but are rolled back due to failure of another request in the same atomicity group MUST return a status code of 424 Failed Dependency.

Show all comments

How to add new icon in the icon list for Freedom Ui

Like 1

Like

2 comments

Not possible to add.
It would be great to be able to use any mat-icon. For now, I would love to at least get a complete list of the icons available. I’ve noticed that the list changes depending on the context of what the icon is for, although you can change the icon name in the viewConfigDiff to any available and it works (as long as you know the available icon names)

Ryan

Hello,

Unfortunately, there is currently no way to add a new icon in the icon list for Freedom UI.

However, a task has already been registered in our R&D team to consider and implement such a feature in future releases. In case you would like to check what stage this task is at, I am sending you the task number: PR-28339. Feel free to share this number with us at any time and ask your questions.

Show all comments

Hi,

 

I have read all documentation on lead channel vs lead source but am still unsure how I should use them.

 

Can someone that is gathering leads from a trade show tell me how they use these categories? Would the channel be 'Trade Show' and the Source be the name of the trade show? Or do you use other fields, such as 'Event' for the name of the trade show?

 

We want to track our leads for every specific trade show and conference we attend.

 

Thanks in advance

Like 0

Like

1 comments

Hello,

 

There are several ways to transfer leads to Creatio. 

1)create lead manually

2)from bulk emails

3) create a lead from the landing page

The way you describe it is for working with a landing page. 

The [ Landing pages and web forms ] section is used to set up integration between Creatio and web forms on your websites. As a result, each time an integrated web form is submitted, a new record is automatically created in Creatio using data from the submitted form. Landing page integration can be used for generating leads, adding customers to event participants, automatic order registration, and more. 

The main idea of Lead channel and source is tracking from which website leads come to our system.

The channel field contains information about the type of web resource from which this lead came (for example social network). The source contains information about the name of the web resource from which the lead came. Creatio uses UTM marks to track lead generation channels. They help to analyze which resource leads come from. More information about in this article: https://academy.creatio.com/docs/8-0/user/marketing_tools/website_track…

More information about how to work with Lead channel and source can be found at the link:https://academy.creatio.com/docs/8-0/user/marketing_tools/website_track…

Show all comments