Hi supporters,
I have a problem with conditional function, please review and help me out.
I have 8 fields: Country, Province, pro1, pro2, pro3, pro4, pro5, pro6
Field “Country” is a single drop down field, has six values: Vietnam, America, England, Japan, France and Spain.
Field “Province” (is an attribute of field “Country” when value is Vietnam) is also a single drop down field, has six values: 1, 2, 3, 4, 5 and 6.
Field “Pro1” (is an attribute of field “Province” when value is 1) is a single drop down field too, with 7 values.
Field “Pro2” (is an attribute of field “Province” when value is 2) is a single drop down field too, with 7 values.
Field “Pro1” (is an attribute of field “Province” when value is 3) is a single drop down field too, with 7 values.
Field “Pro4” (is an attribute of field “Province” when value is 4) is a single drop down field too, with 7 values.
Field “Pro5” (is an attribute of field “Province” when value is 5) is a single drop down field too, with 7 values.
Field “Pro6” (is an attribute of field “Province” when value is 6) is a single drop down field too, with 7 values.
I set conditional-others to field Country:
- When its value is “Vietnam”, field “Province” will show.
I set conditional-others to field “Province”:
- When the value is 1, field “Pro1” will show.
- When the value is 2, field “Pro2” will show.
- When the value is 3, field “Pro3” will show.
- When the value is 4, field “Pro4” will show.
- When the value is 5, field “Pro5” will show.
- When the value is 6, field “Pro6” will show.
I tried in frontpage and the result is as follows:
First, I choose field “Country” value is “Vietnam”, field “Province” is showed.
Then, I choose field “Province” value is 3, field “Pro3” is showed, and I can choose one of its 7 values.
After that, I changed value of field “Country” from “Vietnam” to “Spain”, field “Province” is hiden, but field “Pro3” is still showed.
My question is that: How I can hide field “Pro3” this case, because it is not an attribute of field “Spain”, “Pro3” should only be showed when field “Province” is showed.
Please note that:
1. If I choose Spain from the beginning, field “Pro3” is not showed.
2. I tried to set conditional-self to fields “Pro1”, “Pro2”, “Pro3”, “Pro4”, “Pro5” and “Pro6” that when value of field “County” is not equal to Vietnam, they will hide. But after that, when I choose value “Vietnam” to field “Country”, all these fields (Pro1, Pro2, Pro3, Pro4, Pro5, Pro6) shows while I only need one field showed at each time according to value of “Provine” field.
Thank you and looking forwards to your reply.
Hai Dinh