A number of different script triggers onObjectValidate, OnObjecteSave, OnObjectExit come to mind as ways to perform a script:
If [ YourTable::Field = "Alert Value Here" ]
Show Custom Dialog [ "put alert message here" ]
You can use several if blocks for different values or you might possibly use an expression such as:
If [ Patterncount ( "AlertValue1|AlertValue2|AlertValue3" ; YourTable::field ) ]
and only use one If block. (the difference here is in what kind of alert message you want to display.)
I spoke too soon, Phil. It works, but the alert pops up regardless of whether or not the condition is met. The script text is as follows:
If[Table::Field = "Value 1" or "Value 2" or "Value 3" ]
Show Custom Dialog [ "Alert" ]
As I tested it further, the alert pops up no matter what value I put in the field. What am I missing?
My apologies for the frequent posts. I changed my script to use the Patterncount expression and it worked as desired. Thanks for your patience and guidance.
Have a great day!
To use Or, you'd do it this way:
If[Table::Field = "Value 1" or Table::Field = "Value 2" or Table::Field = "Value 3" ]