Business Rule to take string or integer and * and populate total in another field

deneech · ‎08-29-2017

Hello Everyone.

I am trying to create a business Rule to take the number from u_number_of_standard_server_software (right now I have this field as a string, I can change to integer if that will help).

Multiply it by 6,439

Get the answer and populate it in u_standard_server_software_annual (read-only Currency field)

Here is my code

Thanks for all your help. I will make sure i mark your advice as helpful or correct if you can help me solve this problem.

Denee

Shishir Srivast · ‎08-29-2017

In your business rule, you can try like this,

var value = parseInt(current.u_number_of_standard_server_software)* 6349;

current.u_standard_server_software_annual_amount = current.u_standard_server_software_annual_amount + ';' + value;

But i believe this can easily be done through onChange() client script on u_number_of_standard_server_software field to get the calculation done, like

var val = (parseInt(newValue) * 6349);

g_form.setValue('u_standard_server_software_annual_amount', val);

Let's see if this helps.

View solution in original post

AJugovic · ‎04-14-2021

Try changing your getDisplayValue() to getValue().

I've done this with onChange Client Script using g_form.getIntValue(). But you need a onChange script for each field.