Copy the string data into currency field

Jyoti Tripathi · ‎12-06-2023

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

please kindly help

Anil Lande · ‎12-06-2023

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);

        }
    }
}

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

Prashant Ahire · ‎12-07-2023

@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:

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