Copy the string data into currency field

Jyoti Tripathi
Giga Guru

Hi All, I have a requirement to copy the pay rate(string field) from caller field to wage field(currency field) and it should be truncated to two decimal places.

 

Example- if user's pay rate is 56.8867 then wage field should populate as $56.88

JyotiTripathi_0-1701869337999.pngJyotiTripathi_1-1701869410599.png

 

please kindly help

 

1 ACCEPTED SOLUTION

Hi,

Try below:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading) {
        return;
    }
    if (newValue === '') {
        g_form.setValue('dollar_amount', 'USD;0.00');
        return;
    }
    var grievant = g_form.getReference('employee_id', callBack);

    function callback(grievant) {
        var payRate = parseFloat(grievant.u_pay_rate_amount);
		g_form.setValue('dollar_amount', 'USD;'+currValue);
        var currArr = payRate.split('.');
        var decPart = currArr[1];
        if (decPart.length > 2) {
            var x = Number(grievant.u_pay_rate_amount);
            var currValue = "USD;" + Math.round(x * 100) / 100;
            g_form.setValue('dollar_amount', currValue);

        }
    }
}

View solution in original post

15 REPLIES 15

@Jyoti Tripathi 

This is the updated script which will give you 2 decimal values without round off
I have Tested this 

 

 

(function executeRule(current, previous /*null when async*/ ) {

    var payRate = current.u_pay_rate_amount;

    var numberArray = payRate.split('.');
    var integerPart = parseInt(numberArray[1]);
    var decimalarr = integerPart.toString().split('');
    var decimalTwo = decimalarr[0] + decimalarr[1];
    var finalRes = numberArray[0] + '.' + decimalTwo;

    payRate = parseFloat(finalRes);
    current.u_wage_rate = "USD;" + payRate;
    current.update();

})(current, previous);

Output:
PrashantAhire_1-1701945189974.png

 

Please check and Mark Correct and Helpful if it really helps you.
Regards,
Prashant Ahire