did you found a solution?, we need to maintain spanish, but replace comma with  point

Hi,

There is an easier way to achieve a custom precision for the column: in the grid detail schema you need to override the getGridRowViewModelConfig method. For example I've created a replacing view model for the OrderProductDetailV2 and specified the following code there:

define("OrderProductDetailV2", ["MoneyModule", "css!OrderPageV2Styles", "css!SummaryModuleV2"], function(MoneyModule) {
	return {
		entitySchemaName: "OrderProduct",
		messages: {},
		attributes: {},
		methods: {
			getGridRowViewModelConfig: function(config) {
				var gridRowViewModelConfig = this.callParent(arguments);
				gridRowViewModelConfig.rowConfig.UsrDecForTests.precision=6;
				return gridRowViewModelConfig;
			}
		},
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
	};
});

In this case all the values in the precision for the "UsrDecForTests" decimal column (that is Decimal (0.00000001) data type) in the "Products" detail on the order page will be set to 6:

and

and

So you can try the following approach on your end.

Best regards,

Oscar

That's exactly what I needed. Thank you, Oscar!

In freedom, is you update the datatype with multiple decimal places you need to re-add it again to the listview for the columns of that listview to update to new decimals places too.

Hello Mai,

Hope you're doing well.

To perform your task you can follow the instruction which is provided in the next Community post:

https://community.creatio.com/questions/decimal-fields-79-decimal-posit…

Best regards,

Roman

Roman Rak,

I knew how to change number of decimal digits of schema, but I don't know how to change in pre-config page.

Thanks 

Hello Mai,

Thank you for your reply. 

The required kind of functionality is available starting from version 7.17 (for Section Wizard and pre-configured page):

Specifying the value precision when setting up numeric fields. You can select an integer or a fractional number with precision up to eight decimal digits.

Unfortunately, for older versions of the application, there is no functionality that allows you to set a decimal digit mask for pre-configured pages. Our R&D team had been informed about this functional request earlier and as for now, you can use it in the latest version of the Creatio application.

As a workaround, in the case when you're trying to use a basic column you need to perform the next steps:

1) Create a dummy object and add a decimal field in it, set the needed decimal digit mask. 

2) Add edit page to existing section and change field type there.

Also, you can try to add the following code to the needed field on the page to set the number of characters after the decimal point:

                     "controlConfig": {
                        decimalPrecision: 4
                    },

Here is an example of implementation:

We suggest to save the original schemas as a backup before applying any changes.

Best regards,

Roman

Hello, 

You can create an attribute and make it dependant on the value of the column you need using Dependencies property. After that you can bind your decimal field to this attribute. Please see the academy articles below: 

https://academy.creatio.com/documents/technic-sdk/7-15/attributes-attributes-property

https://academy.creatio.com/documents/technic-sdk/7-15/adding-calculated-fields

Hi Dennis,

Here is my case (Order section): when I change the currency to AUD. The decimal of Total and Payment fields are 0 (it means that the number is 1,140 only)



How can I do that. Thanks

Screenshot link: https://ibb.co/MZtLYFB

Dennis Hudson writes:

Hi Dennis,

Here is my case (Order section): when I change the currency to AUD. The decimal of Total and Payment fields are 0 (it means that the number is 1,140 only)

How can I do that. Thanks

Screenshot link: https://ibb.co/MZtLYFB

Hello! 

Unfortunately, there is no way of conditionally changing the decimal precision for the field, it can only be set to a constant. As a workaround, you can create several fields, bind each one to the Amount column value, set the needed precision for each field, and change the visibility of these fields depending on the currency value. 

To do this you can create an attribute for each of the fields and bind fields' visibility to those attributes. To change attributes value when the currency is changed you can use dependency property: 

https://academy.creatio.com/documents/technic-sdk/7-15/attributes-attributes-property

To set the decimal precision of the field you can use decimalPrecision property: 

            {

                "operation": "merge",

                "name": "Amount",

                "values":{ 

                    "controlConfig": { 

                        decimalPrecision: 5 

                    }

                }

            }

Dear Ignacio,

In order to set prices with 4 decimal places in the Product detail "Price", please go to the "Advanced settings" --> "Configuration". 

Create a replacing object for the parent object "Product price".

Click on the "Price" column in the "Inherited Columns" folder. In the settings panel on the right you will see the options for this particular column. 

Please click onto properties button and set the tick to show all. (step 1 and 2).

Set the "data type" from currency to decimal(0.0001). (step 3)

Afterwards publish the object. The prices in the detail will be displayed with 4 decimal places.

Thanks very much Anastasia, it works.