Hi,
Yes, that’s possible. You simply should use dependencies. Please, click in the link “Show dependencies” in the choices section of the DropDown field, and select the fields in the form that are dependent to the last choice.
So, if the last choice in the DropDown field is selected, the form will display the fields defined as dependents.
Best regards.
Hi
What about when there is more than one dropdown selection?
I belive then we have to use calculation results. It is then
not possible to enter the manual entry ?
I have the following calculated field and want to use “???” for manual entry
Any suggestion? Thanks
(function(){
if(fieldname103 == 1 && fieldname104 == 1) return 625;
if(fieldname103 == 1 && fieldname104 == 2) return 625;
if(fieldname103 == 1 && fieldname104 == 3) return 1200;
if(fieldname103 == 2 && fieldname104 == 1) return 225;
if(fieldname103 == 2 && fieldname104 == 2) return 225;
if(fieldname103 == 2 && fieldname104 == 3) return 225;
if(fieldname103 == 3 && fieldname104 == 1) return 250;
if(fieldname103 == 3 && fieldname104 == 2) return ;
if(fieldname103 == 3 && fieldname104 == 3) return 100;
if(fieldname103 == 4 && fieldname104 == 1) return 400;
if(fieldname103 == 5 && fieldname104 == 1) return ???;
})()
Hi,
As in the rest of the equations, if the the dependent field is the fieldname105, and you want return its value if the value of fieldname103 is 5, and the value of fieldname104 is 1, you simply should edit the validation rule as follows:
if(fieldname103 == 5 && fieldname104 == 1) return fieldname105;
Best regards.
Hi
Is that possible to return 625 to the field 105 as well?
if(fieldname103 == 1 && fieldname104 == 1) return 625 ??;
Thanks
Hi,
I really do not understand your question. If the fieldname105 field is a calculated field whose value would be 625 if the value of the fieldname103 field is 1 and fieldname104 field is 1, you can use any of following equations:
IF(AND(fieldname103==1, fieldname104==1), 625, '')
or
(fieldname103==1 && fieldname104==1)?625:''
or
(function(){
if(fieldname103==1 && fieldname104==1) return 625;
return '';
})()
or a combination of previous equations.
Best regads.
Hi
What I am trying todo as in the link in the first part of the two column fieldset
When dropdowns selected
-Occupancy
-Sprinkler
A) It would give related HRR (kW/m2), Fire Perimeter, Fire Area
B) When “other occupancy” selected from the drop down
customer to insert manually, HRR (Kw/m2), Fire Perimeter, Fire Area (m2)
As two dropdown combination required, this makes it more complicated
Thanks
Hi,
You should to understand how the dependent fields work. If a dependent field is disabled, its value is zero, so, you can use it in the equation without worrying about whether the dependent field is active or not.
For example, if the fields: fieldname1, and fieldname2 are dependent to the choices 1 and 2 of a DropDown field, and you want return as the result of the equation associated to the calculated field, the value of this fields in function to the choice selected, the equation would be as simple as: fieldname1+fieldname2
If you want to create dependencies in function to more than one field in the form, you should use a calculated field as auxiliary to define the dependencies. Please, visit the following link:
http://blog.net-factor.com/how-to-use-dependencies-between-fields-in-the-form/
However, if you need additional help in your project, I can offer you a custom coding service, through my private support page:
http://wordpress.dwbooster.com/support
Best regards.
