How do I use the same fields with different conditions?

  • Profile Image
    Asked on December 23, 2012 at 07:57 AM

    Okay, my problem is that I've a number of fields that I need to use in 3 different situations.

    Let's say the fields are AA, BB, CC, DD, and EE and the situations are A, B and C.

    The situations are depicted by a drop down box and the first condition is that if the drop down box is empty then hide all the fields.

    The second condition is that if the dropdown box is equal to A, then show AA, BB and DD and the third condition is that if the the dropdown box is equal to B, then show BB and DD. 

    Everything goes smoothly with the 1st and 2nd condition but when I introduce the 3rd condition, what happens is that the 3rd condition works fine and shows BB and DD but now when i go and play the 2nd condition, it doesn't show me BB and DD, it just shows me AA. 

    The reason I want to use the same fields for two different conditions is that otherwise in the spreadsheet I get two many columns with the same headers. 

    Please help.

  • Profile Image
    Answered on December 23, 2012 at 09:48 AM

    Hello awiqar.  I checked your form and it seems you're able to figure out how to work on this.  If you still need assistance, can you please provide us the specifics on the fields you're working on?  This way, we can probably try to make a test on how to achieve this.