Let’s admit it…
sometimes users don’t enter things exactly the way we’d like.
To help clean up some of the text users enter, it would be helpful to have a way to Title Case text they enter.
-
The Name field automatically does this (by nature of holding name information, and names are always Title Cased)
So from a field that’s holding text for a title:
[Somethings_Title] = "My title here"
To this:
TitleCase([Somethings_Title]) = "My Title Here"
More info about Title Case
My Specific Use Case
I’m building a PDF template, and using items entered into the database as section headers, groupings, etc.; when people don’t entering things in Title Case, using that data for labels can make the whole document look a little… cheap.
- Things look especially bad when you mix Title Case with NON-Title Case (like the Codling moth average at the bottom)
Why not just use the Name column type? (Since it Title Cases things already…)
- Because the app will try to auto-suggest previous names you’ve entered into forms.
- Your device, your phone, will see a field marked for name collection and say, “Oh hey, I can be helpful here and suggest stuff for you!”
- But I don’t want a person’s name inside the field that stores the name of an Insect… or a Field, or a Building, or a city, tower, picture, cup, product, order, etc. - any field OTHER than a person’s name I wouldn’t use the Name type.
- Even for a customer’s name, I don’t use the Name column because the data it’s going to suggest will be MY name - data pulled from my Google account from when I’ve previously entered my name into fields.
Being able to take any data and convert it into a Title would help round out some of the hard edges.
As always, thanks for considering