Is there a way to have Filemaker (9 Adv) actually convert the data to
Title Case? So that the raw data are changed! - not only Field format...
Thx in advance!
:-) Esben
Mail: nameasofabove_h@get2net.dk
On Sep 25, 1:37 am, e...@nospamget2net.dk (Esben) wrote:
> Is there a way to have Filemaker (9 Adv) actually convert the data to
> Title Case? So that the raw data are changed! - not only Field format...
>
> Thx in advance!
>
> :-) Esben
>
> Mail: nameasofabov...@get2net.dk
Set the field to autoenter TitleCase(self) [i forget the exact
function name] and check the box that lets it overwrite if data is
there.
This results in anything being typed into the field triggering the
autoenter, which overwrites its contents with the calculation.
This technique is also used to format phone numbers, and other
formatted data, while letting users type whatever they want into the
field. (note the autoenter doesn't get triggered until you exit the
field; it doesn't update as you type.)
-Dave
d-42 wrote:
> Set the field to autoenter TitleCase(self) [i forget the exact
> function name] and check the box that lets it overwrite if data is
> there.
The function is Proper()
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles
FileMaker 8 Certified Developer
Member, FileMaker Business Alliance
Howard Schlossberg
> d-42 wrote:
>
> > Set the field to autoenter TitleCase(self) [i forget the exact
> > function name] and check the box that lets it overwrite if data is
> > there.
>
> The function is Proper()
Thanks a lot!
I was having a break from the project and forgot coming back to c.d.f.
to check this - having users already wrecking that part of the typing...
I ended up with this calculation as a (for me) best practice for names:
Proper (TextFormatRemove (Trim ( First Name )))
And the Proper function actually IS better that Title Case as names with
hyphens actually end up looking correct
Anyone has other functions they would always use on Name fields?
:-) Esben
d-42
> On Sep 25, 1:37 am, e...@nospamget2net.dk (Esben) wrote:
> > Is there a way to have Filemaker (9 Adv) actually convert the data to
> > Title Case? So that the raw data are changed! - not only Field format...
> >
> > Thx in advance!
> >
> > :-) Esben
> >
> > Mail: nameasofabov...@get2net.dk
>
> Set the field to autoenter TitleCase(self) [i forget the exact
> function name] and check the box that lets it overwrite if data is
> there.
>
> This results in anything being typed into the field triggering the
> autoenter, which overwrites its contents with the calculation.
>
> This technique is also used to format phone numbers, and other
> formatted data, while letting users type whatever they want into the
> field. (note the autoenter doesn't get triggered until you exit the
> field; it doesn't update as you type.)
>
> -Dave
Thanks a lot!
I was having a break from the project and forgot coming back to c.d.f.
to check this - having users already wrecking that part of the typing...
:-) Esben