Unique Project Names

Sachinsourav02
Sachinsourav02
in Modeling

I allow users to create a project which gets tagged to a numbered list (Projects), Users are expected to give a name, is there a way I can let the user know that the name already exists ? I have brought a logic to check that but its somehow not capturing Capital letters

For example, if project is named 'Jack' and if user enters a new project called 'jack' it doesn't get identified. Is there a way I can even capture the text irrespective of CAPS 


Tagged:

Answers

  • Misbah
    Misbah

    @Sachinsourav02 

    Not sure what you are trying to achieve - Nonetheless you can try UPPER or LOWER functions to check if both the names are matching.

     

    You may have to use either function on both sides of equation

     

    Misbah

Categories