Unique Project Names


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 


  • @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