Copy Value from a string field into an integer field and add Zeros

[Nico12]

Hi,

I am trying to copy value from a string field to an integer field (both are on the same table).

Script (calculated field)

(function calculatedFieldValue(current) {

// Add your code here current.u_poste_commande_achat_classement
var number = current.u_poste_commande_achat;
gs.log("Avant : " + number);
	
if(number < 100){
	//number = number.toString().padStart(3, '0');
	number = ("0" + number).slice(-3);
}

gs.log("Après : " + number);
return number;  // return the calculated value

})(current);

In the log it appears correctly with the 0 add to 30

But in the field, it does not work.

Any advices ?

Regards,

[Saurabh Gupta]

Hi,
Your custom field is string type.
Sorting in string works in a different way.

[Nico12]

Well that's all my problem here.

I have a custom field that is string type and another custom field that is integer type.

I need to copy the value from the string field to the integer field and transform it in integer so i can sort the values correctly.

Regards,

[Saurabh Gupta]

Hi,
You can copy the string field to integer field and apply the sorting on integer one.
Also use the radix as well parseInt(0090,10)==90.

[Nico12]

Well my problem is that it does not working. The integer field does not behave like it should.

The sorting is wrong :

[Saurabh Gupta]

Hi,
Can you please share the screenshot of string field as well.