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

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

Avatar

Avatar
Validate 1
Level 1
pauly225
Level 1

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
pauly225
Level 1

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
pauly225
Level 1

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
Validate 1
Level 4
jasotastic81
Level 4

Likes

35 likes

Total Posts

329 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
jasotastic81
Level 4

Likes

35 likes

Total Posts

329 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
jasotastic81
Level 4

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
Validate 1
Level 1
pauly225
Level 1

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
pauly225
Level 1

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
pauly225
Level 1

02-06-2015

That worked great thank you!