Hi Gareth,
It looks like this thread has been quiet for a little while, but I will ask anyway 🙂
I have a similar question to the initial question posted, except I am hoping for an 'AND' statment. I am a very new novice to programming so I may not explain this quite right.
I will try to explain with a little context. I work for a utility company and I am creating an inspection form for pole inspections. I would like to create a conditional statement that will reduce the work load of the pole inspector.
For example:
I have 3 catagories "Pole Maintenance", "Hardware Maintenance", "Conductor Maintenance". Under each catagory I have several questions about 5-7. However, if everything looks fine for a catagory I do not wish them to answer to the negative multiple times.
My idea is have one main catagory question "Does this require maintenance?" YES OR NO (1 or 0 coded values). In the event that No or 0 is selected then the X many fields are NOT REQUIRED. However, if the answer is YES or 1 then the X many fields are REQUIRED to give detail on why they selected Yes. So in 80% of the cases poles will have nothing wrong, so in this case the inspector has only to answer 3 catagory questions instead of 15-20 questions.
I hope I explained this well enough and thank you in advance for your help.
Tim