Studio_Creatio_enterprise_edition

Cascading Dropdown

Ensar

15:51 Jul 06, 2022

Hello,

I want to make a cascading dropdown. For example; user selects City, then County, then District, then Street... I want to fill the dropdowns from external web service whenever user selected previous dropdown.

How should i go about it?

3 comments

Dmytro Vovchenko

16:10 Jul 13, 2022

Hello Ensar,

Loos like you just need to add a filter to the column based on the other column value.

You can do it by adding attribute on the needed column.

For example:

"Transport": {
                "dataValueType": Terrasoft.DataValueType.LOOKUP,
                "lookupListConfig": {
                    "filters": [
                        function() {
                            var filterGroup = Ext.create("Terrasoft.FilterGroup");
                            filterGroup.add("WhatWeight",
                                Terrasoft.createColumnFilterWithParameter(
                                    Terrasoft.ComparisonType.GREATER,
                                    "[StTransport:Id].StMaxWeight",
                                    this.get("Weight")));
                            return filterGroup;
                        }
                    ]
                }

In this example we have column "Transport" and we wont to display values where their column "StMaxWeight" is greater that out column "Weight".

Ensar

08:30 Jul 14, 2022

Thanks for your reply Dmytro Vovchenko,

Filtering is ok. At the same time, i need to get data from external web service not database. Is there a way binding lookups to external web service dynamically?

Dmytro Vovchenko

10:48 Jul 14, 2022

Not quite understand what are you trying to do but I think you can store the value from your web service in the schemas attribute and then work with it. To make it work you just need to somehow get the needed value from the web server in the schema code.

Show all comments

lookup

searchvalue

lookup modal

How can I make these control buttons disabled, and only enabled when there is not result in search?

7.13

11:53 Jun 14, 2022

Hello guys!

How can I make these control buttons disabled, and enabled again when there is not result in search?

Please help me. Any ideas are valueable!

4 comments

Mira Dmitruk

16:55 Jun 15, 2022

Hello Muhammadjon,

Please note that it is only possible to implement such logic with the means of development, as such an option is not available using regular user tools. Please feel free to look for ideas here on community or on Creatio Academy.

Kind regards,

Mira

06:39 Jun 16, 2022

Mira Dmitruk,

Hello Mira,

There is no way to do that? Do you have any idea how to make this development tools?

Mira Dmitruk

14:48 Jun 16, 2022

Hello,

Unfortunately, we have no examples of such logic implemented and this is considered to be a development consultation, which technical support does not provide. You could contact your manager and specify with them if it is possible for you to receive such a consultation.

Kind regards,

Mira

15:30 Jun 21, 2022

Mira Dmitruk, Thanks You!

Show all comments

Mobile app

8.0

Mobile App customization

Eran Malik

19:48 Jun 11, 2022

HI all,

I need your help.

I'm Trying to customize the mobile app. But each time I follow the documentation

and need to modify the manifest module with:

e.g:

"CustomSchemas": ["mycustommudule"],

I get console error (on the debugging browser) saying:

Path for schema 'mycustommudule' not found.

* i get this error for every custom module I create and try to add it to "CustomSchemas".

Or adding "PagesExtensions": [mycustommudule,...] <-- doesn't work

Basically i'm trying to add a button to my custom section on the mobile app & handle it's "on click" event. but i just can't make it work..

* I followed the documentation on :

https:/academy.creatio.com/docs/developer/mobile_development/customization/manifest/add_a_button

with no luck...

Thank.

1 comments

Max

14:06 Jun 13, 2022

HI Eran!

Have you tried generating source code for all schemas and compiling the app?

Best regards,

Max.

Show all comments

dashboard

analytics

Dashboard advice

Harry

09:34 May 18, 2022

Hi all,

I am currently in the process of setting up dashboards for a client, but wondering if some functionality that I can't see is possible.

1. Line Graph

On the attached graph I have set 4 series all by their fiscal year (June-May). I have done this via custom start and end date, because I understand the fiscal year can't be done. However, this is still showing on the line graph grouped by calendar year. I.e it starts with January and not June - therefore, the first 5 months are actually of year 2024 and then follows on to 2023.

Is there anyway round this so that it actually shows sequentially by date I have selected?

2. Metric

Is it possible via custom function (or marketplace app) to add a "Same Period Last Year" to show against the metric number? So for example, if i choose total Revenue this month, it can show the same period last year? Example below.

Thanks everyone!

Mark

0 comments

Show all comments

Generate and use of Excel Export file from Business Process script

Pratik Sanghani

15:08 May 09, 2022

Hi Community,

I have to use Excel Export Creatio Functionality but instead of downloading the .xlsx file in the system, I have to attach that .xlsx file to the Attachments of a Custom Section.

This task should be performed by the business process after giving filtration criteria as input.

Please suggest me a solution to achieve the above task.

3 comments

Roman Brown

20:12 May 11, 2022

Dear Pratik,

Unfortunately requested functionality is not presented as OOB solution in Creatio at this moment.

We will register this as an idea for the responsible R&D team to extend the basic functionality in future Creatio releases.

Kind regards,

Roman

Pratik Sanghani

10:26 May 16, 2022

Hi Roman Brown,

Thanks for providing the information regarding to this.

But, for workaround is there any Creatio Service avaible that can be utilized In some custom script configuration with Script Task element of business process.?

And if yes, Is there any example available on how to make use of such Services in development.

Rishabh Baghel

08:13 Feb 01, 2023

Hi Roman,

Could you please provide steps or source code for a sample excel sheet creation and saving data, that supports creatio platform (ex. using openXml, IronXL or Interop etc.) and later that can be extended with creatio's future release?

Regards,

Rishabh

Show all comments

Auth Code request URL is mandatory to set up OAuth 2.0 Authentication in web service

Pratik Sanghani

10:06 May 04, 2022

Hi Community,

I want to make use of and set up OAuth 2.0 Authentication in web service authentication. For that I found below the academy article :

https://academy.creatio.com/docs/user/no_code_customization/web_service…

While setting up as per the article, there is one required field in the OAuth Setting fields which is "Auth code request URL".

But the API endpoints for which, I have to make use of Web Service OAuth Authentication, is not having settings for Auth code request URL required parameter.

Please guide and help me on this point that how I can set up OAuth Authentication in web service without Auth code request URL.

1 comments

Bogdan

20:16 May 04, 2022

Hello Pratic,

Unfortunately, the is no way to set up OAuth Authentication in web service without Auth code request URL.

This parameter is necessary to identify users.

Best regards,

Bogdan

Show all comments

lookup

MultiSelectLookup

multiselect

How can i create multiselect lookup?

08:16 Apr 18, 2022

define("ContactPageV2", [], function() {
	return {
		entitySchemaName: "Contact",
		attributes: {
 
		},
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		methods: {
		},
		dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "insert",
				"name": "hasForeignTrade",
				"values": {
					"click": "getLookupConfig",
					"layout": {
						"colSpan": 12,
						"rowSpan": 1,
						"column": 0,
						"row": 2,
						"layoutName": "ContactGeneralInfoBlock"
					},
					"bindTo": "UsrHasForeignTrade",
					"labelConfig": {
						"caption": {
							"bindTo": "Resources.Strings.hasForeignTrade"
						}
					},
					"enabled": true,
					"contentType": "Terrasoft.core.enums.ContentType.LOOKUP"
				},
				"parentName": "ContactGeneralInfoBlock",
				"propertyName": "items",
				"index": 4
			},
 
		]/**SCHEMA_DIFF*/
	};
});

Hello,

How can i make this lookup multiselect?

1 comments

Vladimir Sokolov

11:02 Apr 18, 2022

Probably, it is better to use this add-on from Marketplace https://marketplace.creatio.com/app/multiple-choice-field-setup-creatio

Show all comments

#excelreportbuilder

Receiving GUID Error

Patrick Ostrowski

23:15 Apr 15, 2022

I was finally able to build a report and get it into the correct section, but now I am receiving the following error message.

I am not sure how i can edit the GUI. Please advise. Thank you.

Patrick

3 comments

Gleb

17:00 Apr 16, 2022

Hello Patrick,

from this perspective it is really difficult to say where the issue may occur, So we would recommend you create a support case so our team can investigate the reasons for such an error and provide you with the solution.

Regards,

Gleb.

Patrick Ostrowski

19:50 Apr 25, 2022

Gleb,

A report was made previously, but since the Excel Add-in was made by a third party creatio was unable to asssist.

Essentially in the Excel Add-in, when i am trying to create a related schema to the main table, i am being forced to select "id" as the Master Column. Even though the "id" is unique to each record. If i do not select "id" i get the aforementioned error message when trying to generate the report. I would prefer a different identifier so i can link the data from the main table to the related schema table. Thanks.

Gleb

11:49 Apr 26, 2022

Patrick Ostrowski,

can you please detail a bit more on where exactly you are implementing such logic and where you are trying to add those columns?

Thanks in advance.

Regards,

Gleb.

Show all comments