How to calculate two choice field values and populate in another field.

[venkat Y]

 Each of the field values need to have the following points assigned to each value for the calculation

a. Capability
1. Low = 1 point
2. Medium = 2 points
3. High = 3 points
b. Associates
1. < =100 = 1 Point
2. 101 to 1,000 = 2 Points
3. 1,001 to 10,000 = 3 Points
4. 10,001 to 50,000 = 4 Points

calculation should sum up the associated points for each value selected in capability, Associates fields

The "Effort " field needs to be a calculated field based on two other fields which are mentioned, and populate these choice depend on calculation

1. a.  Not Prioritized - 0 points
2. b.  Low - less than or equal to 5 points
3. c.  Medium - greater than 5 points but less than or equal to 9 points
4. d.  High - 10 or higher points

[AnubhavRitolia · Accepted solution]

Hi @venkat Y 

You can create Choices of field as below:

Then you can write below code in your 2 onChange Client Script for Capabilities and Associates field:

var cap = parseInt(g_form.getValue("u_capability");
var ass = parseInt(g_form.getValue("u_associates");
var eff = cap+ass;

if(eff==0)
{
g_form.setValue('u_effort','Not Prioritized');  // value of choice 'Not Prioritized'
} else if (eff<=5) {
g_form.setValue('u_effort','Low');  // value of choice 'Low'
} else if (eff>5 && eff<=9) {
g_form.setValue('u_effort','Medium');  // value of choice 'Medium'
} else if (eff>10) {
g_form.setValue('u_effort','High');  // value of choice 'High'
}

[venkat Y]

@AnubhavRitolia  woww nice Anubhav, Thanks for the code

[AnubhavRitolia]

@venkat Y 

Most welcome.