dynamic portal sorting hosted files filemaker pro

But those people don’t make it to the top without a lot of “Deliberate Practice”: It turns out that the top people in most fields have some genetic markers that make them able to shine in certain areas. The Myth and Magic of Deliberate Practice | James ClearĪ must read post from James Clear on magic and limits of deliberate practice. Source: FM/SQL Portal Filter + Dynamic Sort | FileMakerHacks He also links a free downloadable example file.

In the free example file it is easy and fast to find a list all people in Pasadena, CA with a name ending in “berg”.įor an alternative, easier, more FileMaker native way to sort a portal, check out Tom Fitch’s method here.

Allow your users to search whether or not a the search field Contains the search phrase.Īnd that’s pretty powerful stuff.

Allow your users to search from the beginning and the end of the search field.

This guest post by Joel Englander is long and complex, but is worth the read if you want the following for your users: I mean you have still to learn some SQL, which has a very different syntax than the regular FileMaker syntax, it has also a very different logic, moreover, as it is not FileMaker native language - you have to type it by yourself, and not make any mistake! Furthermore FileMaker provides you some dynamic parameters, which are inconvenient, because they need to be put in the function parameter in the correct order (like in FileMaker custom functions), but when you call them in your main SQL query you have to call them in the correct order (unlike in FileMaker custom functions) with always the same name: a question mark «?». In this article we are going to explain how to implement portal filtering in FileMaker portal using SQL techniques, because it is easy, powerful and extremely flexible! FileMakerHacks recently posted on FileMaker portal filtering and sorting using SQL queries, something a lot FileMaker developer avoid due to the complexity of using SQL queries inside the FileMaker framework:

Dynamic portal sorting hosted files filemaker pro