Newbie Questions

Re: Data validation and blank cells

adamrharding — Fri, 12 Oct 2007 21:34:22 GMT

No problem glad to be of assistance

Re: Data validation and blank cells

jorobertson — Fri, 12 Oct 2007 17:18:35 GMT

Thanks Adam. I had actually tried this but thought it hadn't worked. I've tried it again now and realise it didn't work because of another field I'd forgotten I'd put validation on. So it seems to work fine now, thanks so much for your help.

Re: Data validation and blank cells

adamrharding — Fri, 12 Oct 2007 08:16:54 GMT

Hi Jo

The idea you are trying to implement is actually moderately simple. If I give you one example I am sure you will be able to apply it wholesale.

Field 1 and Field 2 are my only fields

I want to validate the entry on Field 1 but not stop people from submitting the form if left blank

My validation will read something like: Where @Field 1 is not blank AND where @Field 1 does not match pattern "custom pattern" \d\d\d\d\d\d\d represents a seven-digit number. This way if @Field 1 is blank no validation applies, if however it is completed it has to have 7 digits in it.

FYI the custom pattern screen details all manner of different characters to build your own special pattern for the field.

I hope this helps

Data validation and blank cells

jorobertson — Thu, 11 Oct 2007 14:04:02 GMT

Hi there,

I've done a search but can't find this question being asked before, although I'm sure it will have as it seems very basic.

Is there any way to perform data validation on fields when they are not blank, but allow them to be submitted if left blank? I have lots of optional sections in my form, but wish to check the data entered where appropriate, so I have lots of data validated cells, most of which will be blank on any one form submitted.

I hope this makes sense! I would be grateful if anyone can let me know how to do this.

Thanks in advance