Join Cris Ippolite for an in-depth discussion in this video Introducing the FileMaker 14 platform, part of FileMaker Pro 14 Essential Training.
- Before we get started with our exercises, I think it's gonna be helpful to take a minute here to introduce you to the four different products that make up the FileMaker 14 platform. The FileMaker 14 platform is a set of tools and technologies that enable you to create, deploy, and manage custom business solutions, as well as modify them as your needs change. You can create solutions that run on iPads, iPhones, iPod Touches or on Mac and Windows desktops or even in the browser. Of the products that make up the platform, first we'll start with FileMaker Pro for 14.
FileMaker Pro is the standard user version of FileMaker that is the desktop software that can either be used for Windows and Mac and it allows you to design and build custom solutions and then also use those solutions that are either built by yourself or by others. And this is the version of FileMaker that I'm gonna be using in this solution, and it'll allow us to do everything that we're talking about in this title. Similar to FileMaker Pro is FileMaker Pro 14 Advanced. This has all the functionality of FileMaker Pro, but it also has some additional tools that developers might find useful.
Things like Script debuggers, or the ability to Create customized menus. You can also create runtime versions of FileMaker Pro applications and different developer type features and functions like that. Now just a note, FileMaker Pro Advanced costs a little bit more than FileMaker Pro does. The additional tools that come with FileMaker Pro Advanced are really an essential part of a developer's toolkit, making it a must-have product for those who'll be creating or maintaining solutions. If you're just gonna be using FileMaker, then FileMaker Pro is fine. Now next, FileMaker Server 14, which is an application that gets installed on a dedicated server machine or frankly, up to three different machines, and it's used to be able to share all of the different files that you create in FileMaker to many different users at the same time.
Its whole lot in life is really to host solutions for sharing and also protect them with data shared securely between the server and the users. Now FileMaker Pro has tested a limit of 250 concurrent users, but its theoretical limit is unrestricted, and what that means is that connections are limited really only to the limitations of your hardware, possibly the database design, and even the operating systems that you're running on. You can also use FileMaker Server to Publish your databases to the web, using either FileMaker WebDirect, or custom web publishing using php.
The FileMaker platform also has a really exciting option which is the FileMaker Go app. The app can be downloaded for free on the iTunes store and will allow users to access FileMaker solutions on iOS devices, including iPads, iPad minis, iPad Airs, iPhones, iPod Touches, anything that runs the iOS operating system. The app provides access to hosted or online databases, or even locally stored databases right on the device. Now FileMaker WebDirect isn't so much a product as it is a deployment option that is available on the FileMaker platform.
Now with all of these different products together, there's a concept that you might wanna be familiar with which is called Connections. If you want to connect to a database that's hosted on FileMaker Server but you want to use FileMaker Go or FileMaker WebDirect, you will need what's called a Connection. Knowing how many Connections you might need really just boils down to which tier of the server license you're going to purchase. So the key to knowing how many Connections are necessary is to determine whether or not you even need to buy them.
So users with a paid license of FileMaker Pro, FileMaker Pro Advanced on either Windows or Mac can connect to FileMaker Server without any Connections needed. So basically if you paid for the client, or if you pay for Pro, then you don't have to pay for a Connection, but users with web browsers who are accessing via FileMaker WebDirect or users using the free FileMaker app, called FileMaker Go, require paid Connections from FileMaker Server. Now if you've determined that you're gonna have FileMaker Go or FileMaker WebDirect users accessing your solution on Server, then all you need to do is figure out how many concurrent Connections you need.
So for example, a team with several members connects to FileMaker Server using an iPad, iPhone, or web browser throughout the course of the day. At various times, there are different numbers of users connected. The maximum number of people connected at any one time using an iPad, iPhone, or web browser, specifically web browser with FileMaker WebDirect, will determine the number of concurrent connections needed. The key here is concurrent. So if you look at our graph right here, if we determine that at, let's say 4:45, the most amount of people that can possibly be accessing our solution via FileMaker WebDirect or FileMaker Go would be 8, then we need at least 8 connections on our server license.
Now FileMaker sells Connections in packs of five, so in this case you would need to have a ten user Connection license in order to facilitate 8 current connections. Keep in mind, however, that if you paid for a license of FileMaker Pro or FileMaker Pro Advanced, that does not use up a Connection when connecting to the server. Understanding the entire platform can help you plan for your current and future database needs, so you wanna make sure that you're using the right products to work together across iPads, iPhones, Windows or Mac desktops, and even web browsers in order to streamline your business solution.
- Comparing flat vs. relational databases
- Creating databases from starter solutions
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating and working with fields, including container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Working with layout themes
- Using layout parts and tools
- Formatting layout objects
- Finding and sorting data
- Creating value lists
- Printing and saving
- Building reports, including subsummary reports and quick charts
- Using the Calculation dialog
- Creating and triggering scripts in the Script workspace
- Working with script triggers