Input box Looker Studio to enable both upper and lower case

Looker Q&A Looker Studio
1

Hi.

Anyone knows if i can have an input box that will accept both upper and lowercase. My data have first letter of every word as uppercase and others are in lowercase. It’s to hindersome for users to have to follow that format. I tried creating calculated field (using Upper() and Lower()), but then my user would have to stick to one format.

Example input:

  1. Apple

  2. apple

  3. APPLE

Data:

Apple

Appreciate anyone who have can help.

Thanks in advance.