Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 7

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 7

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