Our sales and production processes use multiple funnels. Huge advantage of Creatio is the ability to create multiple funnels with different settings. That is why we chose Creatio when fucked off russian amoCRM.

But the trouble is, we have an opportunity to build several funnels, but we have not the ability to manage several funnels together.

We found the Calculated metric add-on, which allows you to operate with formulas and get, for example, the conversion rate for the sum of two funnels, LTV or the number of sales per client for two funnels.

But it is not clear why you stopped half way and did not create the Lists and Charts in the same way.

THIS IS MEGA USEFUL. It is almost the functionality of Power BI.

Serious competitive advantage

Please clarify if there are any plans to improve it and when?

Thank you!

Like 1

Like

2 comments

Hi Artem,

 

Thank you for the detailed and thorough feedback. We appreciate it.

The developer of the Calculated metrics application is yet to improve it. However, the Creatio R&D department has already devised plans to redesign and enhance the charts interfaces in the out-of-the-box Creatio functionality. While I cannot provide you with an approximate release date, we scheduled the first steps in this direction after the 8.1 Creatio release.

Thank you for your answer.  We will be wait the update. We hope than in charts interfaces appear Filters "like Power BI" which help to use universal reports for different directions of analizes: levels (employee/dep/company) , offices, products ect

Show all comments

Hello Community,

I'm trying to implement the opportunity Client in creatio Latest version. How can we add diff and attributes in latest version?

I tried in this way, but it didn't work. Is there any way to do the multilookup column or can we do multilookup column in latest version.

{

                "operation": "insert",

                "name": "Customer",

                "values": {

                    "type": "crt.ComboBox",

                    "label": "Customer",

                    "control": "",

                    "listActions": [],

                    "showValueAsLink": true,

                    "controlActions": [],

                    "multiLookupColumns": [

                        "Account",

                        "Contact"

                    ],

                    "layoutConfig": {

                        "column": 1,

                        "row": 1,

                        "colSpan": 1,

                        "rowSpan": 1

                    },

                    "controlConfig": {

                        "enableLeftIcon": true,

                        "leftIconConfig": {

                            "bindTo": "getMultiLookupIconConfig"

                        }

                    }

                },

                "parentName": "SideAreaProfileContainer",

                "propertyName": "items",

                "index": 0

            },

 

Thanks in advance! 

Regards,

I Yasaswini

Like 1

Like

1 comments

Hi,

Unfortunately, for now, you cannot create a multi-lookup column on the Freedom UI page. 

We already created a request for our R&D team to add this feature in the future version.

Show all comments

Hello Team,

I am trying to insert a null guid directly to the DB. I use the following snippet

	QueryColumnExpression nullParameter =
					Column.Parameter(DBNull.Value, new GuidDataValueType(UserConnection.DataValueTypeManager));
				update.Set("ResponseDetailsId", nullParameter);

I get the following exception

 

System.NotSupportedException: The CLR type Terrasoft.Core.DB.QueryColumnExpression isn't supported by Npgsql or your PostgreSQL. If you wish to map it to a PostgreSQL composite type you need to register it before usage, please refer to the documentation.

 

If this is not a suitable way, which is the proper way to insert a null guid directly in a PostgreSQL db from C# code ?

Like 1

Like

1 comments

Solved 

Example

new Update(_userConnection, "SysAdminUnit")
					.Set("LDAPElementId", Column.Parameter(null, "Guid"))
				.Where("SynchronizeWithLDAP").IsEqual(Column.Parameter(true));
			int operationsCount = update.Execute();

 

Show all comments

Hi Team,

 

A new DCM is created/OOTB DCM is used in a stage and few records are created. Post that there is a change made in the life cycle and new stages are added and saved and made it actual version.

 

Records created post the new stages has been defined will have the new DCM stage shown but the old records will have the old DCM and option to “change case” available and on click of the “change case” the stage will show with the new DCM flow.

 

Question : instead of going to each and every old record to change the DCM to the new DCM created, is there an option to update all the old records DCM to the newly created DCM?

 

 

Thanks in advance!

 

Regards,

Mayan

Like 2

Like

4 comments

Hello,

 

We have already registered it in the backlog of our R&D team to fix this logic in future releases.

 

Currently, you can only change the version of a case manually in each record separately.

+1 here, it would be great to update all or select opps in batch to switch to new dcm version.

Hello,



Would like to ask if this is possible now?



Thank you

Kalymbet Anastasia,

Any update on this.

Show all comments

Hi,

Is there a way to add advanced filter mode to lookup record in lookup section?

Right now there is only "Add filter" option on Filters/folders. I need to add "Switch to advanced mode" to lookup record to add more modes to filter. 

 

Like 1

Like

1 comments

At the moment, it is not possible to configure advanced filters in Lookups records.

We have recorded your request and this issue will be considered in as much detail as possible with the prospect of implementation in future versions of the application.

As a workaround, the advanced filter can be configured by the "list" dashboard by selecting the directory object, and in the display parameters select the advanced filter.

Thank you for your appeal and for helping to make our product better!

Show all comments

Hello!

 

We need to add Pivot to the Account page.



As there is no widget with pivot available in page wizard, is there another option to do that?

Like 0

Like

4 comments

I do wish we could add dashboard list elements on pages. It would make things easy to display unrelated data on a page and things like pivot tables. However, I don't believe there is anyway to add it to the page that I know of. We usually just create a view, then display the results in a detail on the page instead. For creating a pivot table, Postgresql does have the crosstab function which does this easily - However, that is part of the tablefunc extension, which isn't installed in Creatio postgresql databases - I've never tried to see if it allows you to install extensions like that. See https://stackoverflow.com/questions/3002499/postgresql-crosstab-query/1…

Ryan

Ryan Farley,

We have added widget with list to the page, but it is still displayed like flat list, not pivot... 

That's why I would like to find out if it is possible to make this last step :)



Hello Vladimir,

Did you find a solution ?

Vladimir Sokolov,

Could you please add the steps for adding the list element to a page?

Thanks!

Jacek

Show all comments

Hello all,

 

Is there any way to change the color of the big blue confidence level widget on opportunities? It looks good when the instance is configured in standard Creatio blue but we have several clients using different section colors and when you make the section list something like red, it clashes.

Is there any way to change the color of the widget?

Like 0

Like

1 comments
Best reply

You can add this CSS to the opportunity page:

#ConfidenceLevelWidgetContainer .background-container {
    background-color: #9f5989;
}

Result

 

If you need help with how to add the CSS to the page, see https://customerfx.com/article/adding-custom-css-style-sheets-in-bpmonl…

Ryan

You can add this CSS to the opportunity page:

#ConfidenceLevelWidgetContainer .background-container {
    background-color: #9f5989;
}

Result

 

If you need help with how to add the CSS to the page, see https://customerfx.com/article/adding-custom-css-style-sheets-in-bpmonl…

Ryan

Show all comments

7.18.5 in-site

Set up integration with ZAPIER - 1.03.

Periodically, ZAPIER gives an error when transferring data:

Could not parse JSON from /0/DataService/json/SyncReply/RuntimeEntitySchemaRequest

hide details

http://joxi.ru/Vm6B4jWt04GMkm

This is all the information that displays by mistake ZAPIER

the error occurs when transferring not all but only some records

 

Can someone explain what this error is?

Like 0

Like

4 comments

Hi Alexey!



Please tell us more about the issue.

Which steps did you take to transfer data?

Did any common errors occur?

Did the issue occur on a particular step?

Hi Oleksander,

Here is all the information by mistake http://joxi.ru/L21EGgYFV0GbK2

Here is the action itself - create a contact and fill in three fields "Email", "Name", "Account"

http://joxi.ru/DmBBZKktP4d3Bm

http://joxi.ru/8Ankb1yT0y16pr

http://joxi.ru/12M95y0cXkqRv2

http://joxi.ru/n2Y9Xp4cVeGE42

the error is not permanent. When that day or two appears, contacts are not created, and then they are created again, and even when you restart those that have not been completed, they are successfully completed

 

Вот вся информация по ошибке http://joxi.ru/L21EGgYFV0GbK2

Вот само действие - создать контакт и заполнить три поля "Емейл", "ФИО", "Аккаунт" 

http://joxi.ru/DmBBZKktP4d3Bm

http://joxi.ru/8Ankb1yT0y16pr

http://joxi.ru/12M95y0cXkqRv2

http://joxi.ru/n2Y9Xp4cVeGE42

ошибка не постоянная. Когда появляется то день или два не создаеются контакти, а потом снова создаются и даже когда повторно запускаеш те что не віполнились они успешно выполняются

?

Hi Alexey,

I have forwarded your feedback to the developers in charge. They're working on the further steps now.

We recommend using the "Run business process" event. In that case, Creatio's internal logic will handle creating a record rather than DataService.

Show all comments

How do I delete a column from an Edit Page? We have sections with unused or accidentally added columns that we want to clean up and not have visible in Edit Page

Like 0

Like

1 comments

Hello Jeremy, 

 

The column can be deleted directly from the Section Wizard. 



If you have different data on UI and in Section Wizard, for example the column is visible on UI on the page but not available in Section Wizard (or vice versa), you'd need to check the value of the "Current package" system setting and set it to Custom, such issue may occur due to incorrect dependencies of your packages.

The "Custom" package is the very last package in the hierarchy, it "contains the functionality" of all other packages, so the mentioned issue should not occur once it's set as current package.



If the issue persists despite the provided recommendations, please contact the support team at support@creatio.com so we could proceed with investigation.



Best regards,

Anastasiia

Show all comments

Hi,

 

I would like to add a hyperlink (titled "Details" below) in edit page of a record. When clicking the hyperlink it should redirect to another page in a new tab.

Right now clicking "Details" the page opens in new tab. My issue is that along with the required page, a new tab opens at https://{sitename}/0/Nui/ViewModule.aspx as well. Thus 2 new tabs are opened when I click on the link now.

Below is what I have (Today's agenda is not a detail; it's a control group):

Below is my code:

methods:{

onDashboardDetailsButtonClick:function(){

                let url = ;

                window.open(url, '_blank');

            }

},

diff: /**SCHEMA_DIFF*/[

            {

                "operation": "insert",

                "name": "DashboardDetails",

                "values": {

                    "layout": {

                        "colSpan": 7,

                        "rowSpan": 1,

                        "column": 7,

                        "row": 2,

                    },

                    "itemType":Terrasoft.ViewItemType.HYPERLINK,

                    "enabled": true,

                    "caption":"Details",

                    "click": {"bindTo": "onDashboardDetailsButtonClick"},

                },

                "propertyName": "items",

                "index": 2

            }

]

Can you please tell me what I'm doing wrong and how to resolve this?

Like 0

Like

4 comments
Best reply

Hello Nirupama,

 

Terrasoft.ViewItemType.HYPERLINK item type also has an addtional property "href" and if it's not filled in by default it's automatically filled in with the base application url (https://somesite.creatio.com). You can also see it when hovering the mouse to the link or copy the link adddress from this element. As a result when you click on the item your custom URL is opened and additionally the default URL of the website.

 

If it's possible you should try setting your custom URL to the "href" property like:

getCustomURL: function() {
				return "https://www.wikipedia.org/";
			}
...
{
                "operation": "insert",
                "name": "DashboardDetails",
                "values": {
                    "layout": {
                        "colSpan": 7,
                        "rowSpan": 1,
                        "column": 7,
                        "row": 2,
                    },
                    "itemType":Terrasoft.ViewItemType.HYPERLINK,
                    "enabled": true,
                    "caption":"Details",
					"href": {"bindTo": "getCustomURL"}
                },
                "propertyName": "items",
 
                "index": 2
            },

 

Hello Nirupama,

 

Terrasoft.ViewItemType.HYPERLINK item type also has an addtional property "href" and if it's not filled in by default it's automatically filled in with the base application url (https://somesite.creatio.com). You can also see it when hovering the mouse to the link or copy the link adddress from this element. As a result when you click on the item your custom URL is opened and additionally the default URL of the website.

 

If it's possible you should try setting your custom URL to the "href" property like:

getCustomURL: function() {
				return "https://www.wikipedia.org/";
			}
...
{
                "operation": "insert",
                "name": "DashboardDetails",
                "values": {
                    "layout": {
                        "colSpan": 7,
                        "rowSpan": 1,
                        "column": 7,
                        "row": 2,
                    },
                    "itemType":Terrasoft.ViewItemType.HYPERLINK,
                    "enabled": true,
                    "caption":"Details",
					"href": {"bindTo": "getCustomURL"}
                },
                "propertyName": "items",
 
                "index": 2
            },

 

Thanks, Oscar! That works!

 

As a follow up, is there a way to make the integer value in the above screenshot a hyperlink, so that instead of providing a separate link like "Details", they can on the value and that redirects them to the details page?

Nirupama Mohan Latha,

 

As for the integer field - I am not sure, but you can try converting it into a string column and add the logic as was described here.

Thank you!

Show all comments