we have a customer search form, on which a staff member will type in the name (or the first part of a name) of a customer and click on a ‘Search’ button, to initiate a search for the customer.in our database, all names are stored in total uppercase. so, if the staff types the name in lower case, is there a way that the entry field can convert the letters to uppercase automatically, as they’re being typed??, or, do i have to wait until they click ‘Search’ and then take the value in the field and convert to uppercase within the agent that’s performing the search??
Subject: forcing upper case
If you are using full text search, one of the default searchoptions is ‘ignore case’.
So it shouldn’t matter how they put the data in.
If it does matter, you can always change the case in your agent (ucase in LS or @uppercase in @formulas). You could also write a javascript function in the onchange event of the field to convert all characters to uppercase …
cheers,
Tom
Subject: Try an Input translation formula: @UpperCase(@ThisValue)
Subject: forcing upper case
If you are doing this from a web browser you can use CSS to force the input as uppercase by putting the following code in the style section of the field:
“text-transform:uppercase”