Want to select the value if the two fields have some value eaqual to dropdown

Hi,

I’m sorry, but I don’t understand exactly your question, I’ll assume you want select the third choice in a DropDown field:

First, assign a class name to the DropDown field, through the its attribute: “Add Css Layout Keywords”. I’ll use the class name: myclass, this class name is only to identify the field from the equations.

Second, as part of the equation, uses the snippet of code:

jQuery(‘.myclass select’)[0].selectedIndex = 2;

Tip: The indexes in the DropDown fields begin in zero, so, the third choice has the index 2.

Best regards.

Hello,

Thanks for giving help.You have given a close answer to my question.

Details of my requirements:

1:I have two fields and the sum of these two.

2: on the base of the sum of these fields I want to select a value in the dropdown list.

3:In the list I have value from 5000 to 10000.
4:if the sum of two field is equal to any dropdown value then it select that value.for example if total is 15000 it will select option with the value of 15000 in dropdown.
Thanks

Hi,

Assuming that the fields that are being added are the fieldname1 and fieldname2 (of course you must use the corresponding fields names in your form), the snippet of code to use in your equation would be:

jQuery(‘.myclass option[value=”‘+(fieldname1+fieldname2)+'”]’).prop( ‘selected’, true );

Best regards.

Hi,

Thanks again.

What could this code do that it will add the value of fieldname1 and fieldname2 and make them the value of dropdown.

What I want:

if the sum of two fields is equal to 1 to 5000 then it will select the first value i.e 9800.if the sum is greater then 5000 then it will select second value of dropdown i.e 12000.I have already given the values of dropdown.I do not want to add the sum in value.I want to generate value on the base of the sum of two fields.So this will only select the dropdown having the value equal to sum.
Thanks

Hi,

Please, follow the logic of the previous ticket:

(function(){
var v = fieldname1+fieldname2;

if(v < 5000 )
{
  jQuery('.myclass option[value="9800"]').prop( 'selected', true );
}
else
{
  jQuery('.myclass option[value="12000"]').prop( 'selected', true );
}
})()

If you need additional support with your equation, don’t hesitate in request a custom coding service from my private support page:

https://wordpress.dwbooster.com/support

Best regards.

Yes this is the thing that I need.
I am happy to see your best response.I wish you best for future.

Thanks

Hello,

Where I have to include the code so that its work.I have try to put in my own js file.

Thanks

Regards

Muhammad Sikander

Hi,

The code I sent you in the previous ticket should be used as the equation associated to a calculated field. Select the calculated field in your form, and enter the equation in the corresponding attribute.

Best regards.

Hi,

Thanks for such a nice help.I am thinking that I have to put in javascript.Now my problem is 100% solved.I am happy that you are giving all type of help.

Thanks

Kind Regards

Muhammad sikander

Hi,

I am doing the if condition by removing dropdown and assigning the value to the input field.this is my code.but this does’t work.What is wrong in it.

[ Moderator note: code fixed. Please wrap code in the backtick character or use the code button. ]

(function(){
var v = fieldname1+fieldname2;
if(v < 15000 )
{
   jQuery('input[name="fieldname23_2"]').val('9800');
}
else
{
    jQuery('input[name="fieldname23_2"]').val('500');
}
})()

I have also try by giving the class to the calculated field.

(function(){
var v = fieldname1+fieldname2;
if(v < 15000 )
{
   jQuery('.testClass').val('9800');
}
else
{
   jQuery('.testClass').val('500');
}
})()

please give a look on this and suggest me.Thanks

Hi,

The issue is simple. You should not use the name of fields (fieldname####), because they are replaced by its values, you should use class names, like in your second equation, but the class names are assigned to the fields containers, so the correct would be:

(function(){
var v = fieldname1+fieldname2;
if(v < 15000 )
{
jQuery(‘.testClass input’).val(‘9800’);
}
else
{
jQuery(‘.testClass input’).val(‘500’);
}
})()

Best regards.

Hi,

Thanks for your response.Now I understand the point.I have also check the equation help and that works for me.

This is my code:

(function(){
var v= fieldname1+fieldname2;
if(v<= 7500){
return fieldname1+fieldname2+7700;
}
if(v >7500 && v<=15000){
return fieldname1+fieldname2+8500;
}
if(v >15000 && v<=20000){
return fieldname1+fieldname2+9060;
}
if(v >20000 && v<=30000){
return fieldname1+fieldname2+10985;
}
if(v >30000 && v<= 50000){
return fieldname1+fieldname2+12860;
}
if(v>50000 && v<=75000){
return fieldname1+fieldname2+21882;
}
if(v >75000 && v <= 100000){
return fieldname1+fieldname2+24787;
}
})();

Regards
Muhammad Sikander Nasar

Hi,

Your equation is correct, but can be optimized, the sum: fieldname1+fieldname2, was execute to calculate v, so, you don’t need to repeat and repeat the sum again. The equation can be modified as follow:

(function(){
var v = fieldname1+fieldname2,
c = 0;

if(v<= 7500) c = 7700;
if(v >7500 && v<=15000) c = 8500;
if(v >15000 && v<=20000) c = 9060;
if(v >20000 && v<=30000) c = 10985;
if(v >30000 && v<= 50000) c = 12860;
if(v>50000 && v<=75000) c = 21882;
if(v >75000 && v <= 100000) c = 24787;

return v + c;
}
})();

Best regards.

Hi,

Yes this work for me.Thanks