 Imagine being able to create a solution customized to your business that runs on iPad, iPhone, Windows, Mac, and the web. And what if you could create that solution in a matter of hours instead of months? With the FileMaker platform, you can create solutions quickly with one of the 16 starter solutions built into FileMaker Pro for your common business tasks. Or, for more specialized needs, you can start from a blank slate and import data you already have. We'll show you how easily this can be done. Let's create a solution starting with spreadsheet data. For this example, the solution will be used on iPad by commercial landscapers to access customer information on site. Any changes made on iPad will instantly update the main office. Currently, the company uses one spreadsheet to track customers and another for work order information. One way to create a new FileMaker solution is to simply drag and drop an Excel file onto the FileMaker icon. FileMaker allows you to use the spreadsheet column headers to name your fields. We will simply name the file Customers. Now, all of the customer details are in the FileMaker solution. FileMaker Pro automatically creates two layouts which are different ways to view the information. Layout 2 is a spreadsheet-like table view and Layout 1 is a form to show one record at a time. To create custom views of your information, use Layout mode. You can add as many layouts as you like. We'll create a layout called Customers that is specifically designed to run on iPad. It's easy to build great-looking solutions for any device using FileMaker's easy design tools. FileMaker uses fields to store information. To add fields to your layout, just select, then drag and drop them wherever you want. Fields allow you to manage most types of information, including text, numbers, and dates. You can also create new fields to hold items like images, documents, videos, and more. Here, we will add a photo field and place it on the layout. When you want to give your layout a consistent look and feel, insert objects like your company logo and headers. We'll add a header noting that this layout includes information on the customers. You can also use over 50 pre-designed themes. There are touch themes made specifically for iPad and iPhone layouts. We'll choose Enlightened for this layout. Creating tabs is a great way to display different types of information in the same place. Choose the tab control to draw the area for your tabs. Our tabs will hold contract information and work order details for each customer. FileMaker is great for managing documents. We'll create a field to store the contract documents for each customer. We'll also create a signature area to capture customer approval. Now that we've built the key elements of our solution, we can view the customer data that we imported earlier in the attractive new form. We can also add a photo and a copy of the customer contract into our new fields. Let's share the solution so that our team can visit customers and have all the details they need at their fingertips. You can choose to share the solution from the desktop or upload it to a server. FileMaker Server gives your team instant and secure access to accurate company information, whether they are using iPad, iPhone, Windows, Mac, or a web browser. Now, let's run the new solution on iPad. We'll use FileMaker Go, which is free from the App Store. Select the location where the file is hosted, then tap on the file. We can now interact with the solution on iPad. We'll perform a quick find. Let's say we are visiting the Pine Station customer. We can take a picture of the customer location using the iPad camera or choose a photo from the image library. While at the site, we'll get the manager's signature approving the contract. You can see here that the Mac does not yet show the photo and signature, but when we tap to save changes on iPad, all new images and information entered on iPad are instantly shared with anyone else accessing the same solution, whether they are in the office on a computer or at a customer site using iPad. As company needs grow and change, FileMaker solutions can quickly evolve. Let's take the solution a step deeper and add more details. Remember the separate spreadsheet with work order information? Let's import it into the FileMaker solution so we can view specific work order details together with customer information right on the same screen. Now all 1400 items from our work order spreadsheet are in our FileMaker solution. We'll go back to the customer layout so we can create a way to see the specific work for each customer. We previously created a work order tab. Let's define the area on that tab where we will view the work orders by adding a portal. Portals allow you to view related data. Selecting Manage Database lets us set up the relationship between customers and work orders. Each group of data is represented by a box. To create the relationship between the two, draw a line between common information. For this example, it is customer number. Now let's select the information we want to see on the work order tab. We'd like to see the date, description, and hours for each work order. The iPad does not yet have the work order information, but after setting up the relationship between customers and work orders, we can click to save the changes on Mac, and the solution on iPad instantly shows the same information. Everyone on the team can now see the work orders for each customer wherever they are. Within minutes, we created an iPad solution that provides remote employees with essential customer details, including contracts and work orders. They can capture photos and customer signatures that are shared with others. With additional time, you can create a more comprehensive solution with labels for the work order details, a calculation with total hours worked, and popovers that allow you to add new work information with a few taps, including a date and hours worked, add interactive maps, and get driving directions right within the file maker solution. And create charts and reports that can be converted into PDFs and emailed to customers right from the iPad. Use these powerful file maker tools and many more to quickly build a solution that is customized to the way you and your team work. Let FileMaker help you create, share, and run custom solutions to streamline your business.