3 Replies Latest reply on Sep 27, 2018 11:14 AM by Joe Oppelt

    How to Identify Invalid Entries

    Megan Peterson

      I need to ensure all managers are filling out certain fields.

      To do this I have checks set up and working, to identify when a required field is null.
      However for one field, it is manually entered and I need it to not only not be null but also match the following format: PRJ123456 (PRJ + 6 numbers).

       

      Example of what some people type in that is incorrect: #PRJ123456 or PRJ123m56

       

      Summary:

      I would like to find a way to figure out if the value in the field has PRJ at the beggining and 6 numbers at the end.

       

       

      Thanks for your help in advance.