Unique Project Names

Sachinsourav02
Contributor

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 


1 REPLY 1
Misbah
Moderator

Re: Unique Project Names

@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