How to check if the != null fields in coumn 2 have a certain value

Avatar

Avatar

pauly225

Avatar

pauly225

pauly225

27-05-2015

I have a form with a table that is 15x9.

 

In column 2 if any of the != null fields == 300 && any one of the != null fields does not == 300, I need an error message saying all to be = 300.

If all of the != null fields are == 300 then no message

If none of the != null fields = 300 the no message

It does not need to change the values, just display a message.

thank you in advance

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

jasotastic81

Avatar

jasotastic81

jasotastic81

28-05-2015

I'm not sure how you labeled your rows. Here is my solution if there is just one repeated row, all named Row1.

768967_pastedImage_0.png

If the rows are already created and named Row1, Row2, etc., then it would look like this:

768971_pastedImage_1.png

Answers (1)

Answers (1)

Avatar

Avatar

pauly225

Avatar

pauly225

pauly225

02-06-2015

That worked great thank you!