Just chiming into Matthew's thread here :)
You can have a formula field for every field to be cleaned up which i know you don't want to do) and have a form rule:
when the record is saved,
Change the name field to the value in the field [name formatted formula]
You would need to have those formula fields on the form even if they are in a hidden section.
But yes, you need to make those formula fields. This could also be supported by a Webhook, but once again,, QuickBase cannot read your mind as to the format.
The president of one of my client companies is Ed duDomain. You may need to have a checkbox to not change the data entry for unusually capitalized names.