Why:
Occasionally a user will type their last name as " Smith" instead of "Smith".
It is not noticable in the text box.
So when user does search using "StartsWith", their "Smith" is not found,
resulting in a call to help desk.
Suggestion:
Allow Auto-Trim with these configurations:
1. What gets trimmed in a string
a. Nothing, as is.
b. Trim leading blanks only
c. Trim trailing blanks only
d. Trim leading and trailing blanks only
e. Trim leading blanks, trailing blanks, and replace consecutive blanks with one blank.
2. Which fields
a. Short strings, but not memo fields.
b. All strings, including memo fields.
3. Which tables
a. All tables
b. Specific tables
Benefits:
1. We protect ourselves from users who inadvertently type a space before a key field.
2. We don't have to write repetitive code to make this happen. We declare what we want, and Lightspeed implements it.
|
Status: New
|