The Original Filemaker Community - Forum
FileMaker News | FileMaker Tutorials | FileMaker Videos

Password protection and security…

Must Have FileMaker Custom Functions: Text Cleanup

This FileMaker training video covers a few of our favorite Custom Functions with regards to cleaning up text. This is the second video in a series that will highlight several of our ‘must have’ Custom Functions.

Watch the first video in the series here: https://youtu.be/LhYZp360ChA

Whether you are familiar with Custom Functions or not, these should save you some time and frustration when developing a solution that could potentially have text formatting issues.

Generally speaking, Custom Functions are a way to take something complex, repetitive, or confusing, and replace it with one simple function call.

While we would love text to always be entered properly, the reality is that there will be times where some cleanup is necessary. Using a Custom Function to harness the power of FileMaker built-in functions can make the entire process appear to be automatic which takes less time and decreases frustration at troubleshooting strange outcomes.

Sometimes the simplest things can make a major difference when creating or debugging your solution.

Even if you don’t have an immediate need for these specific Custom Functions, this tutorial video may give you ideas of other places in your solution that can be simplified.

FileMaker Functions utilized in these conversions:
Trim ()
Left ()
Right ()
Middle ()
Length ()
Filter ()
Let ()
If ()
PatternCount ( )
Case ( )
GetValue ()

► PCI WEBSITE: https://www.productivecomputing.com/
► ONLINE UNIVERSITY: https://www.productivecomputinguniversity.com/
► TWITTER: https://twitter.com/prodcomp
► FACEBOOK: https://www.facebook.com/productivecomputing/
► LINKEDIN: https://www.linkedin.com/company/productive-computing-inc.            

Please subscribe if you like this content or want to stay informed on more Productive Computing and FileMaker training videos.

► Auto Subscribe: https://youtube.com/c/ProductiveComputing?sub_confirmation=1

Thanks for watching!

1 Comment
  1. Productive Computing says

    I don’t want to know how many hours I have spent retyping code when it could have been easily translated into a very simple Custom Function. It doesn't have to be complex or recursive to be extremely helpful. One line of code saved over and over during an entire developer career can really add up.

    ✅ Online training for your future– FileMaker Certification Preparation: http://www.ProductiveComputingUniversity.com
    ✅ See FileMaker 18 Features playlist: https://www.youtube.com/playlist?list=PLLFSxz1yusVq4Zn2DO_hwgB4fvtd6gqet
    ✅ See FileMaker 17 Features playlist: https://www.youtube.com/playlist?list=PLLFSxz1yusVoKVrqoi6VwfmUYpQUjFem9

Comments are closed.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Privacy & Cookies Policy