troubleshooting Question

validating a field in lotusscript based on the value of another field

Avatar of bobrossi56
bobrossi56 asked on
Lotus IBM
24 Comments1 Solution930 ViewsLast Modified:
I need to validate on exit the field YS_1, but its validation
is based on the contents of another field UTS_1. If the UTS_1
field contains either the word BRIGHT or MATTE, field
YS_1 needs to be within a certain range, and if neither is
in the required range (based on field UTS_1), a messagebox warning
must pop up on the exit event.

The code would "read" something like this, only I can't write it
correctly. I'm not a Lotusscript'er, YET.


if field UTS_1 Contains "Matte" then
field YS_1 must be <= 0.000400
ELSE messagebox ("Must see MLP")
OR
if field UTS_1 Contains "Bright" then
field YS_1 must be <= 0.000300
ELSE messagebox ("Must see MLP")

thanks,
-Bob
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 24 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros