Hi guys,

Need some ideas, or if it's even possible to do what I need.

I have a field where I am expecting specific values. Currently, I am using a formula to validate the entry, but the message is general for all conditions.

The conditions are: "Only Number Only", "Entry Must be 6 or 5 Characters", "No Duplicate Records Allowed.", and "Entry MUST start with 8, 6, 2 or 1"

Is there a way that I can have individual custom messages for each error?

Thanks

Rudy

28 minutes ago, rudym88 said:

Is there a way that I can have individual custom messages for each error?

Not through the validation mechanism, but you could use a script trigger to precede validation and do your own thing.

Thanks,

I am experimenting with a script using the "IF" and triggered on exit, but haven't been able to get it to do what I need. Any ideas would be much appreciated.

Thanks

Rudy

Edited 2 hours ago2 hr by rudym88

You should trigger the script OnObjectValidate otherwise validation will occur before the script runs (at least those elements of validation that do not wait until record commit), defeating the very purpose of this exercise.

The script itself could be something like:

Set Variable [ $errors ; ... ]
If [ not IsEmpty ( $errors ) ]
  Show Custom Dialog [ $errors]
  Exit Script [ Result: False ]
End If

with the $error variable calculated along the lines of:

List (
If ( some test ; "some error message") ; 
If ( another test ; "another error message") ;
...
)

(Untested)

Edited 49 minutes ago49 min by comment