Lesson #6: Fields & Calculations - Learning Functions - Scriptology Mastery Course FileMaker

Looking for the full list of videos in this series? See the link in the description.

In order to truly make anything happen within your FileMaker solution, you have to become familiar with the available functions. However, like learning any new language, even a spoken language, it's only after time, practice and use that the collection of functions become more useful. Until that point, it requires you to take the time necessary to learn them individually. In this video we're looking at how you can speed up the process of learning some of FileMaker's available functions.

Here's the link to the full series with the videos listed in order.

[philiprand]

That "evaluate" as a practice function is a brilliant idea. Just an anecdote: since I work with an Italian FM program, I had to find (and it was easy) "Valutazione". There are times when FM will accept the English function command, and when it won't, but that is a long story.

[neptunian]

Nice video Matt!

A quick note about PatternCount and Position (around 45:00) for starters watching the video. In this example Position returns '1' just like PatternCount does.
Just to make sure that you get it right: the purpose of Position is 'Returns the starting position of the specified occurrence of searchString in text'.
In the video example the result happens to be '1' so just be aware that it could have been any number depending on the search string, start and occurence.

Example:
Position( "This is the best text in the world"; "s"; 1; 1) would return 4

[horizons]

How can I prevent a layout from being printed? Not objects within the layout but the layout as a whole.

[anonomas]

great video. I would literally watch every second of you going through every single function if you did it.  HAHA  Can anyone link the devcon video that discusses optimizing your code mentioned at 43:08 in this video?

[MrDiertje]

great Matt, just learn just a little bit more of FM.