Hi community,

 

what is the right way to start customizing the new version of the account entity in freedom UI?

I have tried creating a new app and using the account object, the new app shows me the new list but still uses the standard form defined in the "360 customer" app.

Like 0

Like

1 comments

Hello Stefano,



In order to access Freedom UI, you will need to go to System Settings,

Please follow the instructions in this Guide:

https://academy.creatio.com/docs/user/platform_basics/freedomUI/turn_on…

 

Show all comments

Hi community!

We have moved our package from one environment with lowest creatio version (7.16) to environment with highest version (creatio atlas).

Some objects were not installed properly and we received error:

Error "Object is invalid. Extended properties are not permitted on 'dbo.UsrGeneralViewFile.FKcCbW9f8n8IYIlNxWjlw0Vi1Gqc', or the object does not exist." occurred when updating schema structure. SQL script text: "EXEC [dbo].[sp_addextendedproperty] N'TS.ActionType', N'ForeignKey', N'SCHEMA', N'dbo', N'TABLE', N'UsrGeneralViewFile', N'CONSTRAINT', N'FKcCbW9f8n8IYIlNxWjlw0Vi1Gqc'"

 

Any suggestions how to resolve it? 

 

 

Like 0

Like

2 comments

Hello Yana, 

 

We strongly recommend to transfer packages between sites with the same build (products) and versions to avoid any errors. 

It's hard to identify the root cause of the issue with no access to the system. But based on the shared information, I may assume that the issue is related to the lookup column that has no "Do not control integrity" option enabled in its settings and the issue occurs as the database structure for the object cannot be successfully updated while installing the package. I'd suggest to check it and as well fully generate and compile the system, and also resolve possible generation / compilation errors. 

If the issue persists despite the provided recommendations, please contact support team via support@creatio.com to proceed with investigation. 



Best regards,

Anastasiia

hi.

You do need to look at server logs.

SQL.json + Packages.log

You'll see there not only most recent error but first error, for example

"ErrorMessage":"The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKcCbW9f8n8IYIlNxWjlw0Vi1Gqc"

The conflict occurred in database \"...........\", table \"<lookup_table_name>\", column 'Id'."

and only next - 'dbo.UsrGeneralViewFile.FKcCbW9f8n8IYIlNxWjlw0Vi1Gqc', or the object does not exist."

most probably, you have records in the lookup column of the table UsrGeneralViewFile that do not exists in your lookup table

Show all comments

Hello Community,

 

Our client has a case where he needs to upload a file secured with a password to the attachment details. He tried to upload that file file but with no success. Is there a way to keep that file in its encrypted format and be able to upload it?

 

Thank you,

Like 0

Like

2 comments

...

Hello Mariam,



You can make a password file in the archive and put the archive in the detail. At the moment there is no possibility to enter the password exactly inside Creatio. Perhaps this can be implemented by custom development.



Regards,

Anton

Show all comments

I use apps for Creation https://marketplace.creatio.com/app/data-binding-tool-creation

An error appears in the console after trying to link the column settings for a part. What could this be related to?

Like 0

Like

1 comments

Hello Vlad!

I have successfully bound list settings on CRM Creatio 8.0.8 using this add-on on my side. Please, provide more details so that we can reproduce your issue:

1. Which Creatio product and version do you use?

2. Did you save the list settings for all users before binding these settings? 3. List settings for which section or detail did you try to bind?

Show all comments

Hi,

 

I am trying to open a new webpage from a button onclick action. I saw this feed:

https://community.creatio.com/questions/how-open-new-webpage-button-onc…

 

I'm very new in Creation so I tried to replicate it on a page definition. What's wrong with the following code:

 

define("UsrPage_bwxynuo", /**SCHEMA_DEPS*/[]/**SCHEMA_DEPS*/, function/**SCHEMA_ARGS*/()/**SCHEMA_ARGS*/ {

    return {

        methods: {

            openWindow: function() {

                 var path = this.get("https://fr.wikipedia.org");

                 window.open(path, '_blank');

             }

        },

        viewConfigDiff: /**SCHEMA_VIEW_CONFIG_DIFF*/[

            {

                "operation": "insert",

                "name": "Button_w36eyol",

                "values": {

                    "itemType": Terrasoft.ViewItemType.BUTTON,

                    "click": {"bindTo": "openWindow"},

                },

                "parentName": "MainContainer",

                "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*/[]/**SCHEMA_HANDLERS*/,

        converters: /**SCHEMA_CONVERTERS*/{}/**SCHEMA_CONVERTERS*/,

        validators: /**SCHEMA_VALIDATORS*/{}/**SCHEMA_VALIDATORS*/

    };

});

Like 0

Like

2 comments
Best reply

Hello,

From the code you posted, you're using the newer type of page (Freedom UI), but how you wired up the click of the button to call your method is how you do this on the older classic pages. To wire up the click of your button execute your own code, see this article: https://customerfx.com/article/adding-a-button-to-execute-custom-code-o…

Ryan

Hello,

From the code you posted, you're using the newer type of page (Freedom UI), but how you wired up the click of the button to call your method is how you do this on the older classic pages. To wire up the click of your button execute your own code, see this article: https://customerfx.com/article/adding-a-button-to-execute-custom-code-o…

Ryan

Thank you very much Ryan

Show all comments

It is possible to remove 2 decimal after comma?

Like 0

Like

2 comments

Hello, 

 

It's not possible to remove zeros after the decimal point without changing the type of the column in the DB. 

If there is some data stored in the column - we strongly don't recommend changing the data type of this column since data can be lost.

But if it is absolutely new column - you can change the data type.

 

Best regards,

Anastasiia

Anastasiia Zhuravel,

Okay thank you 

Show all comments

Show a button if the selected entry has certain conditions ("Test.Lookup == Test 1")

 

Example

Card: Lead

Lookup: Stage Lead

value: one of the stages

 

 

diff: /**SCHEMA_DIFF*/[           

               {

                  "operation": "insert",

                "name": "NewButton",

                "values": {

                    "itemType": 5,

                    "style": "red",

                    "caption": {"bindTo": "Resources.Strings.NewButtonCaption"},

                    "click": {"bindTo": "onProcess1"},

                    "enabled": true,

                    "visible": true,

/**How to Show/Hide the custom button

                    

                        "classes": {

                        "textClass": [

                            "actions-button-margin-right"

                        ]

                    }

                },

                "parentName": "ActionButtonsContainer",

                "propertyName": "items",

File attachments
Like 0

Like

1 comments

Hello,

To do this, you'll do the following: 

  1. Add a boolean attribute
  2. Bind the boolean attribute to the visible property of the button
  3. Set the attribute to true/false to show/hide the button as necessary

You can see an example of this here: https://customerfx.com/article/how-to-enable-or-disable-a-field-on-a-pa…

Ryan

Show all comments

Hi! 

I want to create a process witch sends emails when the owner of a lead is changed. I have to send the email to the current and the last owner and I have an issue about getting the previous owner. 

Do you know how I can get to the previous owner of the led into the process? 

I want to mention that the pervious owner can be changed multiple times.

 

Thank you, 

Rares Ivan

Like 0

Like

2 comments
Best reply

Hello Ivan,

 

In a business process, you cannot know the previous value because a new version has already been saved. So as a workaround you can add a new column and save there an old value when saving an object. After that, you can deal with both new and old values in a business process. 

Hello Ivan,

 

In a business process, you cannot know the previous value because a new version has already been saved. So as a workaround you can add a new column and save there an old value when saving an object. After that, you can deal with both new and old values in a business process. 

Bogdan,

Thank you, Bogdan! 

Show all comments

Hi community!

I need to make a report where time(days) between lead stages is displayed.

For example:

Registration -> Qualification 5 days

Qualification -> Sale in Progress 8 days

Sale in Progress -> Opportunity in Progress 21 days

Opportunity in Progress -> Won/Lost/etc  54 days

Is it possible to calculate number of days between lead stages and display in the section list view or in any other way (dashboards, report etc)?

 

Like 0

Like

1 comments

Hello,

 

As for now, such dashboards cannot be build using OOB tools because Creatio doesn't store duration of the each Lead stage.

However, it stored start and end date of the stage so you can use this add-on to create more complicated dashboards:

https://marketplace.creatio.com/app/calculated-metrics-creatio

Show all comments

Hello,

I want to auto-number in a Custom module in Studio, the numbering I will do will be handled with different values and must be sequential. I need an answer on how to do it.

Like 0

Like

1 comments