Hi, Vladimir,

Sorry, but we don't know if it can even be achieved using additional front-end development. The only solution we can think of is adding a column to the view you already use where the calculation will be performed automatically and displayed in the pivot table.

Sergii Zhmurko,

Thank you. A column with % will be summarized in totals, so it will show incorrect value.

Hope to see calculated fields in Creatio pivot tables (similar to Excel functionality) in future versions

Kind regards,

Vladimir

Hello!
 

In the basic configuration, there is no option to display all rows as collapsed by default in the pivot table functionality. 
We have noted this idea to our R&D team.
You might consider implementing a fixed style for lists using development tools.

Alona Dolya,

Thank you for the reply. Could you please give a hint, what should be changed using development tools? Where is style of pivot table defined?

Hello!

I recommend using a business process, because business rules work only on the case page, so if a field is changed by a user in the UI, a business rule will be triggered.
Since the feedback is filled in through internal services without interaction with the case page, the business rule will not work because there will be no trigger for its execution.
Therefore, set up a process that will change the required fields in the case and fill in the required fields.

It worked thank you very much

Hello,

As of now, it's not possible to correctly display the field with HTML formatting in the printable.  

Our R&D team has already been informed and is currently working on the mentioned issue.

As a workaround suggestion, you can replace the rich text field with a simple text field. We understand that it’s missing the format settings and cannot be applied to tables, but it should work for a sentence or two simple comments.  

Thank you for being an active part of the community and helping to make Creatio better!

Hello Hanna,

Thank you very much for your response

Regards

Stefano

Here is a sucessfull report launch result:

As this shows, the field COmment and Expenses amount is showing a "Null" result.

Have to start over again, any modifications to the original report makes the latest version STOP. It will not RUN.

Are you referring to pushing to navigation history (as far as going to the record/page itself)?

If so, this shows how to open a page (section or other page) https://customerfx.com/article/navigating-to-a-page-via-code-in-a-creatio-freedom-ui-page/

This shows how to open a record page in add or edit mode https://customerfx.com/article/opening-an-edit-page-to-add-or-edit-a-record-via-code-in-a-creatio-freedom-ui-page/

If I've misunderstood what you're after let me know. Hope this helps. 

Ryan

Hi Ryan, thank you for your answer.

No that's not what I'l looking for. What I want to do is what history.replaceState(state, unused, url) does in JS. change the shown url and the browser history, but not navigate. 

Javier Collazo,

Ah I see now. I've not noticed any equivalent of that in the devkit. I've seen a navigationservice and router classes as possibilities in the internal code, but they aren't exposed in devkit.

One possibility is to use the "crt.7XRequest" request. I've been able to use that for what would have been a sandbox.publish previously, a least for what I've tried with it so far. See https://customerfx.com/article/navigating-a-user-back-from-a-creatio-freedom-ui-page/

Might take a little playing with to figure out how to get the other params passed for stateObj, pageTitle, etc. Searching the source for "crt.7XRequest" would likely find some examples of similar requests.

Ryan

Javier Collazo,

I did find an example: 

await handlerChain.process({
    type: "crt.7XRequest",
    $context: null,
    action: "ReplaceHistoryState",
    hash: someHash,
    stateObj: obj,
    silent: isSilent
});

Ryan

You can include values from the page as default values for the detail by modifying the detail definition on the page. 

details: {
    MyDetailSchema: {
        schemaName: "MyDetailSchema",
        entitySchemaName: "MyObject",
        filter: {
            masterColumn: "Id",
            detailColumn: "MyObject"
        },
        defaultValues: {
            UsrSomeName: {masterColumn: "UsrName"},
            UsrSomeDate: {masterColumn: "CreatedOn"}
        }
    }
}

The above will populate the UsrSomeName column on the detail with the value of the UsrName column on the current page and also populate UsrSomeDate on the detail using the value of the CreatedOn of the page. 

You can also use values that don't exist on the page, for example: 

"defaultValues": {
   "UsrSomeDate": { "value": new Date() }
}

Ryan

thank  you, Ryan.

But something wrong.

my page's default:

When I boot page, my parametr "CtsTuOpport" is undefined:

Hi,
The code Ryan provided worked for me, what it does, is automatically fill the detail column when you create a new page:

details: /**SCHEMA_DETAILS*/{
            "Schema685740a4Detail9ea5ec10": {
                "schemaName": "Schema685740a4Detail",
                "entitySchemaName": "TestDet",
                "filter": {
                    "detailColumn": "Order",
                    "masterColumn": "Id"
                },
                "defaultValues": {
                   "UsrSomeDate": {masterColumn: "CreatedOn"}
               }
            }

Perhaps the issue in your case is that you didn't use the "" brackets.

Thanks for reply

Dmytro Vovchenko, tell me, where is the sintaxis trouble, please:

        details: /**SCHEMA_DETAILS*/{
            "GenFinanceOperations_Detail2cec2e66": {
                "schemaName": "GenFinanceOperations_Detail",
                "entitySchemaName": "GenFinanceOperations",
                "filter": {
                    "detailColumn": "GenTuInspector",
                    "masterColumn": "GenCheckFinOper",
                },
               "defaultValues": {
                  "GenTuInspected":  {masterColumn: true}
              }
            }
        }/**SCHEMA_DETAILS*/,
 

I need set parametr "true" for the calling detail

There was a discussion about this - https://community.creatio.com/questions/change-dcm-record-automaticly

No, diff cannot be loaded based on conditions (only properties like visible or enabled can be changed using conditions, but not blocks of code).

The best approach is to add a boolean attribute on the LinkPageV2

attributes: {
	"IsForAccount": {
		dataValueType: Terrasoft.DataValueType.BOOLEAN,
		columnType: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
		value: false
	}
}

Then bind it to the visible property of the element in the diff

{ //...
    "visible": { "bindTo": "IsForAccount" }
}

On the page init check what the entity type is for the page and set the boolean: 

init: function() {
	this.callParent(arguments);
	this.set("IsForAccount", this.get("entitySchemaName") === "AccountFile");
}

Using this approach will work since the value will never get submitted when saved.

Ryan

Hello!

What is the version of the app you are currently using?

Hanna Skalko,

Hi Hanna

We are using Version 8.1.2 (.3914)

Regards

Stefano

STEFANO FERRARI,

Thank you for your reply!

This tab has already been translated in the newest version of Creatio - 8.1.3.6734 

Thank you for being an active part of the Creatio Community! 

Hanna Skalko,

Thank you very much for your update.

We will wait for Creatio - 8.1.3.6734 to be installed on our environments.

Regards

Stefano

Hi Hanna

We confirm that in Creatio - 8.1.3.6734 the localization is addressed.

Regards

Stefano