Cell Validation

[damo]

I have a form in which users must enter data into a series of fields. I want to make sure that users have to enter information into all relevant fields. It should work as follows;

If a user enters data into "field 2" they must also complete "field 1".

At the moment many users are not doing this. Can anyone suggest a solution?

[damo]

I have a form in which users must enter data into a series of fields. I want to make sure that users have to enter information into all relevant fields. It should work as follows;

If a user enters data into "field 2" they must also complete "field 1".

At the moment many users are not doing this. Can anyone suggest a solution?

[dkemme]

In define fields for field 2 validation try something like:

Case ( Count (Field 1) ;

Case ( Count (Field 2) ; 1 ; 0 ) ;

1

)

The first case looks for anything in field 1, if so then looks for something in field 2, if so returns a 1, if not a 0. If nothing in Field 1 a zero is returned, unless both fields are empty nothing is returned, which works also. I'm sure a real programmer could present a much more elegant method.

[Ugo DI LUCA]

Hi,

What about validating field2 with a calculation

not IsEmpty(field1)

strict + message inviting the users to enter a value in field1

[damo]

Edit: Spoke too soon.

Validation does not fail if the conditions are not met, therefore the user can still get away with not entering data in field 1, when they have entered data into field 2.

Maybe I've missed something........

[dkemme]

Oops, I had it backwards, switch field1 for field2, I like Ugo's much better though.

[damo]

Oops, I had it backwards, switch field1 for field2, I like Ugo's much better though.

Thats great now, thanks for that!!