General

Re: Drop Down List Data Validation and Refresh

wilkies0106aw — Thu, 19 Sep 2013 11:29:06 GMT

Thanks Hilary, that's working a treat.

Re: Drop Down List Data Validation and Refresh

Hilary Stoupa — Wed, 18 Sep 2013 14:58:40 GMT

Does field X have to be Yes | No? Can it be true | false?

Here's a sample that uses a default value for this - just checks field1 through field3 and makes sure they are all the value of the option button labeled Yes.

Drop Down List Data Validation and Refresh

wilkies0106aw — Wed, 18 Sep 2013 13:33:21 GMT

All,

I've a form with many simple drop down lists i.e Yes/No. There are split into "sections".

How can I validate against these sections and have the validation refreshed if an answer is changed?

i.e

questions 1-20 = section 1

questions 21-30 = section 2

If any of the questions in section 1 = No set field X to No.

Yet typically uses will answer question 1. Yes, 2.No, then review their answers and change question 2 to Yes. Therefore I can't just do a simple set field X to No as it field X doesn't update itself on a drop down change.

Thanks