Want to be a better FileMaker developer? Learn how with the Internet's first school for FileMaker Pro! Head To Grasp Learning


FileMaker How-To: The Proper Function

Today in this FileMaker how-to, I am going to teach you how to use the Proper function.

Proper is a text function that capitalizes the first letter of every word that you pass to it and makes every other letter lowercase.

How would a function like this be useful in a FileMaker application? There are a lot of ways!

I've used this function in the past to normalize names and addresses.

One great use of the Proper function is to normalize the capitalization of names when printing name tags.
Name Tag

Another great use of this function is to normalize the capitalization of address labels.
Address Label

Because the Proper function is a part of FileMaker's calculation engine, in order to use it, you will have to write a calculation. But don't' fret, it's quite easy!

The simplest way to use the Proper function is to set a field using the Set Field script step as pictured below.
Screenshot of FileMaker Script Step

Try it for yourself!

I've created an example file for the Proper function, which in the future will only be available to Grasp students. For a limited time only, however, we are offering these files free to our newsletter subscribers. So sign up today using the form to the left.

Please let me know if you found this FileMaker how-to useful. Feel free to send me an email with any thoughts or suggestions that you may have.

What other uses for the Proper function can you think of?

Let me know in the comments below!

comments powered by Disqus