Auto Formating Text Fields
Is there a way to auto format text that is entered on a form? Example... Say I have a form with fields First Name and Last Name The user then fills in First Name with "JOhN" and Last Name with...
Forum Discussion
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.
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.