2 Replies Latest reply on Sep 8, 2012 12:17 PM by schamblee

    IF script issue



      IF script issue


           Good morning all:

           This is such a basic script I am sure, but I have hit a wall and can't see the forest for the trees.

           I have a text field from a related table on the form, and is limited to 4 characters.  The first 3 characters are all variable letters, however the last letter is always either a U or Z.  I am trying to write a script to run showing a Custom Dialog Box IF this field ends with the letter U and open a Dialog box with input fields.   If the text field ends with the letter Z, script ends and move to next field.

           I have tried every combination of wildcard operators, with no luck.

           Any help with this fix, is greatly appreciated.