Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

pauly225
Level 2
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
jasotastic81
Correct answer by
Level 7
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
jasotastic81
Correct answer by
Level 7
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