Dear community,

 

Has anyone been able to use the Excel Reports app in V8?

We installed https://marketplace.creatio.com/app/excel-reports-builder-creatio but the option is only visible in the old UI.

 

Kind regards,

Yosef

Like 6

Like

3 comments
Best reply

Hi Yosef!

The app does not support report download in Freedom UI sections.

As a workaround, you can set up reports that have "Custom report" report type. That way you can generate a report in the Excel reports section.

+1 Also really hoping this gets updated, or even better some enterprise level reporting functionality. 

Yes, I'd rather it become an OOTB functionality in Creatio 8.1 ... an enterprise grade tools requires enterprise grade reporting

Hi Yosef!

The app does not support report download in Freedom UI sections.

As a workaround, you can set up reports that have "Custom report" report type. That way you can generate a report in the Excel reports section.

Show all comments

Hello, community,

 

How to move a user from one role to another by using a business process?

For example, we have 2 branches: branch A and branch B.

The users for Branch A are Alex and Bobby

The users for Branch B are Charlie and Drake

Every month there is a rotation, so Alex will be in Branch B, and Charlie will go to Branch A.

How to do it in the business process?

 

Thank you.

Like 0

Like

1 comments

Hello,

 

 

We have previously discussed a similar task in this post: https://community.creatio.com/questions/create-role-programatically

 

You can simply start by adding a 'delete data' element from the 'user in roles' object and then add an 'add data' element to the same object, filling only the role and user columns.

 

Show all comments

Hello,



Is there a way or documentation on how to implement/display like the Advance Filter  on a custom tab?









I want to display the filtering function in a custom tab, then save the filtering result to Database and use it in some logic.

Like 0

Like

3 comments

Hello, Solem!

If I've understood you right and you want to add custom options to the advanced filter on custom page - please, read the following article 

https://community.creatio.com/questions/example-createexistsfiltercolumnpath

In another case - please, specify the question and give more details with screenshots if possible.

Best regards, Anhelina!

Anhelina,

 



I appreciate you answering my question.

What I want is to display a filtering in a custom tab, then save the filtering result to Database.

 

Solem Khan Abdusalam,

 

Hello,

 

Unfortunately there is no example of adding such a filter to a custom tab (along with the action handler that will save the selected result in the database). We already have a task for our R&D team to add such a possibility to add advanced filters to details on the page. We will also inform them about this question to prioritize the task.

 

Thank you for helping us in making the app better!

Show all comments

Hi all, 



In the latest updates to Creatio, you can set a datasource for the timeline component, other than the record page. 



However, if you do this, the feed component is still set to the record, which means if someone posts on this, it does not appear on the timeline. I'm not sure if this has been overlooked at development. 



I'm hoping it's possible to do this in the code but have come stuck. 



I have changed the entitySchemaName to "UsrBookings" which has correctly changed the schema. However, I can't seem to change the column which needs to be PDS.UsrBooking 

 

			{
				"operation": "insert",
				"name": "FeedComposer_aweotp0",
				"values": {
					"type": "crt.FeedComposer",
					"classes": [
						"view-element"
					],
					"sortedByColumn": "CreatedOn",
					"data": {
						"uId": "fad7ff3c-73da-a7aa-b7be-48fa49cd0d0d",
						"schemaType": "Feed",
						"sortedByColumn": "CreatedOn",
						"typeName": "crt.FeedComposer",
						"caption": "Feed"
					},
					"primaryColumnValue": "$Id",
					"cardState": "$CardState",
					"feedType": "Record",
					"dataSourceName": "PDS",
					"entitySchemaName": "UsrBookings"
				},
				"parentName": "MessageComposerSelector_uxr8sil",
				"propertyName": "items",
				"index": 1
			},



Any help greatly appreciated!

Like 0

Like

1 comments

Hello,

 

This will be changed in the Freedom UI designer. Thank you for reporting this issue!

 

As for the workaround: the code of the composer should be changed in the following manner (PDS_UsrAccount_x75v5wo should be replaced with the attribute of the column for which the feed should be displayed and new messages saved, "entitySchemaName": "Account" - entity of the section where feed messages should be saved)

"feedType": "Record",
					"primaryColumnValue": "$PDS_UsrAccount_x75v5wo | crt.ToObjectProp : 'value'",
					"cardState": "$CardState",
					"entitySchemaName": "Account",
					"dataSourceName": "PDS"
Show all comments

Hi Community,

 

I have this business requirement, where I need to calculate my "Monthly Total" field right after I finish loading my form page.

 

These are the formula and fields I want to calculate:

 

var total = (monthlySubTotal - discountAmount) + ((monthlySubTotal - discountAmount) * (taxRate / 100));

 

 

I tried to use "crt.HandleViewModelInitRequest" handler, but it didn't work. Because, the data is not fully loaded.

 

Is there any other handler that I can use, that waits for all the data to be loaded and then calculate my formula?

 

Thanks in advance.

 

Best Regards,

Pedro Pinheiro

 

 

 

 

 

Like 1

Like

4 comments
Best reply

 Hello. Try this.

{
	request: "crt.HandleViewModelAttributeChangeRequest",
	handler: async (request, next) => {
		if (request.attributeName === "UsrFirstField" || request.attributeName === "UsrSecondField") {
			//recalc
		}
		return next?.handle(request);
	}
}

 

 Hello. Try this.

{
	request: "crt.HandleViewModelAttributeChangeRequest",
	handler: async (request, next) => {
		if (request.attributeName === "UsrFirstField" || request.attributeName === "UsrSecondField") {
			//recalc
		}
		return next?.handle(request);
	}
}

 

Alex Zaslavsky,

 

Thank you for  the reply.

 

I'm using the "crt.HandleViewModelAttributeChangeRequest" handler when a field is being changed.



However, in this situation, the field does not receive any change. For example, the "Tax Rate, %" field has 15.00 as its default value. This does not trigger the "crt.HandleViewModelAttributeChangeRequest" handler. But I need it to calculate the "Monthly Total" field.



After some research, I found the "crt.LoadDataRequest" handler. This handler is executed after all the data has been loaded. So, for the moment, it's working for our requirement.

 

Best Regards,

Pedro Pinheiro

I think your "Tax Rate" field triggers this request, but it's silent.

request.silent

 

Alex Zaslavsky,

 

I've changed the solution and now it's working with the "crt.HandleViewModelAttributeChangeRequest" handler.

 

Thank you.

 

Best Regards,

Pedro Pinheiro

Show all comments

Hello,

 

 

Please let us know if there is any documentation that can help us create a radio button on Freedom UI

 

Thank you,

-Georges

 

Like 1

Like

2 comments
Best reply

Hello!



As a workaround, you can use the Checkbox fields:https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

Hello!



As a workaround, you can use the Checkbox fields:https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

Hello,

 

Thank you for your support.

 

Thank you,

-Georges

Show all comments

Dear colleagues,

 

I need to bind my section folder, but at this time it appears no available in Freedom, I saw in documentation https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor… and Folders are not available to bind

 

I'm using Creatio 8.1.1

 

Somebody knows some workaround to this?

 

Thanks in advance

Best regards

Julio Falcón

Like 1

Like

1 comments
Best reply

Hello!



Folders are stored in a separated table for each section, [object name]+Folder.

For example, for the contact section, it's ContactFolder.

For sections that were created exclusively in the Freedom UI, folders are stored in FolderTree.

 

Hello!



Folders are stored in a separated table for each section, [object name]+Folder.

For example, for the contact section, it's ContactFolder.

For sections that were created exclusively in the Freedom UI, folders are stored in FolderTree.

 

Show all comments

Hello,

 

Please we need the method of how we can create a custom handler on button click to create a loader after some actions are completed for example:

we have a button to trigger a business process, save the record, and show a message but the message takes a lot of time to show so we need to create a loader until the message shows, please let us know how we can do this.

 

Thank you,

-Georges

Like 0

Like

1 comments

I'm not sure that I understood your needs. 

I haven't tested it, but I believe that something like this would work.

define("UsrYour_FormPage", /**SCHEMA_DEPS*/[]/**SCHEMA_DEPS*/,
	function/**SCHEMA_ARGS*/()/**SCHEMA_ARGS*/ {
	return {
		viewConfigDiff: /**SCHEMA_VIEW_CONFIG_DIFF*/[
			{
				"operation": "insert",
				"name": "YourButton",
				"values": {
					"type": "crt.Button",
					"caption": "Your button caption",
					"color": "accent",
					"size": "large",
					"iconPosition": "only-text",
					"visible": true,
					"clicked": {
						"request": "usr.YourCustomRequest"
					},
					"clickMode": "default"
				},
				"parentName": "ActionButtonsContainer",
				"propertyName": "items",
				"index": 0
			}
		]/**SCHEMA_VIEW_CONFIG_DIFF*/,
		viewModelConfig: /**SCHEMA_VIEW_MODEL_CONFIG*/{}/**SCHEMA_VIEW_MODEL_CONFIG*/,
		modelConfig: /**SCHEMA_MODEL_CONFIG*/{}/**SCHEMA_MODEL_CONFIG*/,
		handlers: /**SCHEMA_HANDLERS*/[
			{
				request: "usr.YourCustomRequest",
				handler: async (request, next) => {
					request.$context.maskService.showBodyMask();
					await //your logic
					request.$context.maskService.hideBodyMask();
					return next?.handle(request);
				}
			}
		]/**SCHEMA_HANDLERS*/,
		converters: /**SCHEMA_CONVERTERS*/{}/**SCHEMA_CONVERTERS*/,
		validators: /**SCHEMA_VALIDATORS*/{}/**SCHEMA_VALIDATORS*/
	};
});

 

Show all comments

I'm using the StartNewWithUserConnection function to start a large process in multiple threads. In fact, it turns out that only 5 threads can be launched at the same time, the rest wait for the previous ones to complete and only then are executed. I couldn't find it in the settings or documentation.

Is there a way to increase the number of concurrent threads?

Like 0

Like

2 comments

Hello!



This is configured in \Terrasoft.WebApp\ActorSystem.hocon. In the section /TaskExecutorActor, there is a parameter nr-of-instances = 5.

 

However, these changes can lead to a heavy load on the database or consume the CPU of the web server and result in poor overall system performance.

For example, if you have a dedicated server with, let's say, 32 cores on the web server, it's probably conditionally safe (assuming the database server is also powerful enough) to set it to 32 or even up to %number of cores% * 2.

Thank you, Alona, it helps!

Show all comments

Hello, How to automatically run a process as soon as a page is opened

 

Like 2

Like

1 comments

Hello,

To achieve your goal, you will need to apply the development.

You can find basic examples for launching the process from the page from our partners CustomerFX:

1) Starting a Process from Client-Side Code on a Creatio Freedom UI Page

2) Programmatically Starting a Process from Client Code in Creatio

Thank you.

Show all comments