#FILEMAKER PRO 10 ADVANCED TUTORIAL HOW TO#
#FILEMAKER PRO 10 ADVANCED TUTORIAL SERIES#

The days of always using a portal may have come to an end. In many ways, this has become a prime opportunity to choose either a portal or web viewer. Essentially, replicating a portal - except for the constant data connection.

#FILEMAKER PRO 10 ADVANCED TUTORIAL SERIES#

In this two part video series I show you exactly how easy it is to simply retrieve some data, then present that data within a web viewer. Well, has the time come to simply abandon your portals? What?!?!! Abandon portals? Is that even possible in FileMaker?ДЄctually, it is, with what FileMaker now offers with bi-directional support within Web Viewers, it may be more viable than you've ever considered. You can certainly hack in some method of controlling the sort and the old standby of simply adding new copies of the same portal, just sorted in different directions, has always been a go-to workaround. Using a portal it's an all or nothing approach to sorting by default and you can't really search the portal contents. We don't really have the same feature set presented within a portal. You can view the data in a myriad of ways and FileMaker provides the tools to modify the views quite easily.ДЇileMaker's list view happens to be the most powerful when compared to portals. Portals and list views represent one of the biggest reasons for using a database for managing data. If you've ever been confused about making your portals show exactly what the user needs, especially when using multiple filtering vectors, then enjoy the understanding you'll receive from watching this video.

#FILEMAKER PRO 10 ADVANCED TUTORIAL HOW TO#

In this video we take a detailed look at how to break down a complex multi-filter approach and make it seem really easy to achieve some super advanced portal filtering. If you don't know how to use your AND and OR operators, then it can really seem daunting. You have to become super comfortable with creating complex calculations with a lot of Boolean logic.

However, when start adding more and more filters things start to get complicated really fast. A simple search filter using a global field will let you extra exactly the records you want. You start adding a single filter and the result feels like magic. When first using FileMaker's Filter Portal Records feature it's easy to get excited about how you can limit the set of records to exactly what the user needs to see. The fundamentals and powerful custom functions which should provide you with a ton of date/time confidence for handlings most any date/time based task within FileMaker.

This week's video and technique file will provide you with all kinds of understanding. Understanding UTC, how it impacts my solution, and running scripts on the server in a different time zone vs running them within the local client and how this might impact things based on times or dates. Later down the road, I learned about all the other things I needed to know when considering time around the globe. More importantly, how this impacted what I wanted to do with date/time calculations and integrating with external systems. One of the things I didn't know about was how dates, times and timestamps were treated internally. The documentation for FileMaker is great and the example calculations often lead you in the right direction. When first starting with FileMaker, I remember learning all the default Date/Time/Timestamp functions.

Filemaker pro 10 advanced tutorial