Good day, Colleagues!

Does anyone possibly have a code example on the new Freedom page showing how to calculate the difference of values ​​of two page fields and write it into a third field? For example: payment balance = Amount-PaymentAmount Maybe there's also a code example on how to get the exchange rate on the date specified in the Date field according to the Currency field or an example of how to refer to another object to get a value from it.

Like 2

Like

3 comments

You can see how to wire up a code to respond to a field change here:

https://customerfx.com/article/responding-to-an-event-when-a-field-is-c…

As far as getting and setting the values, this article will show you how to do that: 

https://customerfx.com/article/reading-and-setting-field-values-via-cod…

Ryan

Ryan Farley,



Thank you, I will give it a try.

Ryan Farley,

 

How can I achieve the same requiremet, but for the fields that are inside a detail with editable list?

 

Thank you in advance.

 

Best Regards,

Pedro Pinheiro

 

 

Show all comments

how to filter list page according to current user contact type in freedom ui

Like 0

Like

5 comments

Hello,

 

Could you please describe an example of what logic you need to achieve?

Mira Dmitruk,

 

hello iam trying to get list according to current contact department 

saad mohamed,

 

If I understand you question correctly, you can apply filter with the following condition:

sorry you can not understand me i will explain again

imagine that i have employer in markting department and another employer in hr department

and i need to get records according to employer contact 

if we type it in sql will be like this select * from courses where department = CURRENT_USER_CONTACT_DEPARTMENT

any updates

Show all comments

Hello community,

We are also facing the issue. We have created an approval task via the business process. While the approval task is seen in the notification center, the counter does not get increased or visible.

Please advise.

The test process creates an approval task for the current user.

 

After the process is triggered, the task appears for the current user, but no badge or counter is seen as highlighted in yellow.

Thanks in advance!

Like 0

Like

1 comments

Hi, Yasaswini!

 

Unfortunately, we are not able to understand what exactly you meant by "badge or counter is seen as highlighted in yellow."

 

Please get acquainted with this documentation and clarify the current and expected behavior.

Show all comments

I am working on a use case to use angular component inside creatio. I have followed this link .It seems like it is old documentation most of the js files mentioned in that link is not there in the angular package. Can anyone helo me on this 

TIA

Like 1

Like

1 comments

Hello Pavan,

 

Can you please describe this question a little bit in details? At which particular step do you face issues?

Show all comments

Hello,

 

We are looking for Creatio Source IP Addresses/IP CIDR Ranges to whitelist in our CloudFlare WAF. Currently, we are attempting to integrate our CRM with Creatio, but we are receiving a Managed Challenge from the Cloudflare Bot fight mode. However, we have not yet found information on your website regarding the source IP addresses/ranges from which Creatio will be making requests. We could just whitelist the whole path, but then that would allow anyone to make requests unchallenged. Currently all traffic to our CRM is coming from one IP address, so we could just whitelist that but before doing so we would like to officially confirm this is a static address.

Would someone be able to provide either a reference to Creatio source IP addresses/CIDR ranges, or at the very least confirm or deny whether the current IP (13.xx.xx.148) is static? I appreciate any assistance you may be able to provide.

Like 1

Like

1 comments
Best reply

Hello,

 

We see that you sent us a request in the system number: SR-01214406. 

In this request we will answer your question.

 

Regards,

Orkhan

Hello,

 

We see that you sent us a request in the system number: SR-01214406. 

In this request we will answer your question.

 

Regards,

Orkhan

Show all comments

Hi community,

in my local environment the "Indexing for full-text search" is missing, the section settings page show me "System object".

In my local env I don't have global search configured.

How can I set this field in my package ?

Like 0

Like

3 comments

Hello Stefano,

 

The checkbox will only appear if the global search service is set up for the local environment. Please refer to this article.

 

Best regards,

Anastasiia

Hi Anastasiia,

How can configure the package that contains this custom entity to index it?

If I don't have gs configured locally

Stefano Bassoli,

Hi,

 

If there is a need to add this parameter to the package, you can enable the checkbox via UI and the change will be added to the current package. As mentioned, the checkbox will only appear if the global search service is set up for the local environment.

 

Best regards,

Anastasiia

Show all comments

Hi all,



Where can we change signature date alignining automatically on closed won status change date in opportunities ? We deactivate OOTB opportunity process, and it's still changing when choosing ootb closed won step in DCM.





Cheers,



Damien

Like 0

Like

1 comments

Hi Damien,



you can find this logic in 'Opportunity' object processes

 

 

But I am afraid, you will have to override all this logics in the script to avoid setting closed on date



Kind regards,

Vladimir

Show all comments

We have to build forecast hierarchy based on columns from multiple objects, is there a way to build it.

 

When I tried creating a Forecast on a View object, I got the below error,

 

Error "42809: referenced relation "UsrSalesPersonForecast" is not a table" occurred when updating schema structure. SQL script text: "ALTER TABLE "public"."UsrUsrSalesPersonForecastForecast" ADD CONSTRAINT "FK1BLqxq3nLaQIhH52szd47Se7eNI" FOREIGN KEY("UsrUsrSalesPersonForecastUsrPrimaryKey") REFERENCES "public"."UsrSalesPersonForecast"("UsrPrimaryKey") ON DELETE CASCADE"

 

Any suggestions are welcome...

Like 0

Like

1 comments

Currently the only possibility to build hierarchy in forecasts is by using connected objects from the columns of the original object in the forecast (by selecting them in the level of hierarchy directly):

As for the error message itself: a foreign key must reference a (base) table* in the same database (a base table: not a view, not a foreign data wrapper table) as stated here. In your case one of the columns is referencing a view so that's why the error message popups when updating the database structure.

Show all comments

Hello. 

I am doing a process where I want to create a new record  but I want that the field account fills automatic using a business process, but when I add the record it doesn't pass this information to the section, it shows a blank field, additionally i want to set the name of the record with a formula so it show the name of the account to complete the name but it doesn't pass this data. 

 

I first  tried to add the record and establish the fields that i want to be fill. Then I tried to first add the record and then modifty it to add the fields that i want to be show. And lately i tried using a subprocess to add the fields, but anything of the things that I tried haven't work. 

Can someone help me please? 

 

 

 

 

Like 0

Like

1 comments

Hi Laura, 

 

We'd need to perform a deeper analysis in order to understand and resolve your issue. 

Please forward this question to our support team. Don't forget to provide the external access to your system. 



Best regards,

Yurii

Show all comments

We have a project where I need to filter a certain lookup by a few booleans, where another lookup has the same booleans and only the true values need to be taken into consideration when filtering, unfortunatley with business rules, it will compare the false ones as well which causes only records whos booleans 100% match the ones in the other lookup to show, I have the following code to filter it, but it doesn't seem to work properly, I tried to debug it, but can't seem to find the issue.

 

		attributes: {
			"UniChargeType": {
				"dataValueType": Terrasoft.DataValueType.LOOKUP,
				"lookupListConfig": {
					"filter": function() {
 
						var priceTemplate = this.get("UniUniPriceTemplate");
 
						var esqCharge = Ext.create("Terrasoft.EntitySchemaQuery", {
							rootSchemaName:"UniChargeType"
						});
						esqCharge.addColumn("UniAir");
						esqCharge.addColumn("UniOcean");
						esqCharge.addColumn("UniInland");
 
						var esqChargeFirstFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
								"UniAir", true);
						var esqChargeSecondFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
								"UniOcean", true);
						var esqChargeThirdFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
								"UniInland", true);
 
						esqCharge.filters.logicalOperation = Terrasoft.LogicalOperatorType.OR;
 
						esqCharge.filters.add("esqChargeFirstFilter", esqChargeFirstFilter);
						esqCharge.filters.add("esqChargeSecondFilter", esqChargeSecondFilter);
						esqCharge.filters.add("esqChargeThirdFilter", esqChargeThirdFilter);
 
 
 
						var esqTemplate = Ext.create("Terrasoft.EntitySchemaQuery", {
							rootSchemaName:"UniPriceTemplates"
						});
						esqTemplate.addColumn("UniSubService.UniService.UniAir", "Air");
						esqTemplate.addColumn("UniSubService.UniService.UniOcean", "Ocean");
						esqTemplate.addColumn("UniSubService.UniService.UniInland", "Inland");
						esqTemplate.addColumn("Id");
 
						var templateFilter = esqTemplate.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, 
								"Id", priceTemplate);
 
						esqTemplate.filters.add("templateFilter", templateFilter);
 
						esqTemplate.getEntityCollection(function (result) {debugger;
							if (result.success){
 
								if(result.collection.getByIndex(0).$Air == true){
										var esqChargeFirstFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
										"UniAir", true);
										esqCharge.filters.add("esqChargeFirstFilter", esqChargeFirstFilter);
									esqTemplate.getEntityCollection();
									return this;
 
									}else if (result.collection.getByIndex(0).$Ocean == true){
										var esqChargeSecondFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
										"UniOcean", true);
										esqCharge.filters.add("esqChargeSecondFilter", esqChargeSecondFilter);
										esqTemplate.getEntityCollection();
										return this;
 
									}else if (result.collection.getByIndex(0).$Inland == true){
										var esqChargeThirdFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
										"UniInland", true);
										esqCharge.filters.add("esqChargeThirdFilter", esqChargeThirdFilter);
										esqTemplate.getEntityCollection();
										return this;
 
 
									}
 
 
								result.collection.each(function(item) {
																result.collection.getByIndex(0).$Air
									if(item.entity.get("Air") == true){
										var esqChargeFirstFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
										"UniAir", true);
										esqCharge.filters.add("esqChargeFirstFilter", esqChargeFirstFilter);
 
									}else if (item.entity.get("Ocean") == true){
										var esqChargeSecondFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
										"UniOcean", true);
										esqCharge.filters.add("esqChargeSecondFilter", esqChargeSecondFilter);
 
									}else if (item.entity.get("Inland") == true){
										var esqChargeThirdFilter = esqCharge.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
										"UniInland", true);
										esqCharge.filters.add("esqChargeThirdFilter", esqChargeThirdFilter);
 
									}
 
 
								}); 
							}
						}, esqTemplate.getEntityCollection(), this);
 
 
 
 
					}
					}
					}

 

Like 0

Like

1 comments

The problem is that inside the lookupListConfig.filter you're doing an ESQ, and ESQs are asynchronous. So the filter is returned (which would be undefined or nothing) before the ESQ inside your code ever returns. You'll either need to rethink your filter and how to get the data you want, or prefetch the ESQ to UniChargeType earlier in the page lifecycle, like in the init and then store the results in an attribute, so they'll available to use when needed in the filter function.

Ryan

Show all comments