Filemaker Pro 13 Advanced

Pro 13 Advanced Education & Non-Profit Edition, Mac, ENG, ESD <b>FileMaker Pro Overview</b>
FileMaker Pro makes it easy to create custom solutions for managing business information on iPad, iPhone, Windows, Mac and the web.

Millions of people around the world use FileMaker Pro to streamline the way their teams manage contacts, track inventory, organize projects and so much more.

<b>Get started quickly</b>
The FileMaker Platform has several easy ways to help you start creating solutions right away. Begin with your existing Excel data and drag and drop it into your FileMaker solution. Or view the Getting Started tours in FileMaker Pro and FileMaker Go to get an overview of how the products work. Then use helpful tools like the Resource Center and the built-in Starter Solutions to quickly create your own custom solutions to best meet your business needs.

<b>Start with your Excel data</b>
Drag and drop an Excel spreadsheet to instantly import your data into FileMaker Pro or open a spreadsheet in FileMaker Pro from the Quick Start Screen. Even save your data back to an Excel spreadsheet and email it to others in a couple of clicks.

Plus, you can also import other familiar data types such as .CSV, Tab, or XML into your database.

<b>Starter Solutions</b>
- Choose from one of 16 ready-to-use Starter Solutions that come with FileMaker Pro to instantly give your solution a professional look.
- The Contacts, Assets, Content Management and Invoices Starter Solutions have a fresh, new look that take advantage of new features in FileMaker 13, including bar code scanning, popovers and slide controls.

<b>Getting Started Tours</b>
FileMaker Pro 13 and FileMaker Go 13 now include built-in Getting Started tours that take you through the key features so can start being productive immediately.

<b>FileMaker Resource Center</b>
Found under the Help Menu in FileMaker Pro, the FileMaker Resource Center has video tutorials for both new and existing users and other resources to help you get the most out of your FileMaker software.

<b>Flexible design tools</b>
FileMaker Pro includes powerful design tools that make it easy to create gorgeous databases that run on iPad, iPhone, Windows, Mac and the web. Use built-in themes and styles to give your solutions a polished and professional look. Or choose from several tools such as rulers, grids and guides as well as the Inspector design palette to create a solution that’s right for you and your team.

<b>FileMaker Pro includes all these design tools and more:</b>
<b>Themes</b>
- FileMaker Pro comes with 51 built-in themes - coordinated sets of fonts, colors, and object styling that you can apply to your entire layout to give your solution a polished look.
- Customize existing themes then save and reuse them across multiple layouts so it’s easy to give all your databases a consistent look and feel.

<b>Styles</b>
- Styles are sets of attributes like colors, fonts and text sizes that you can apply to individual objects, such as buttons, fields, and backgrounds.
- Create your own styles or customize existing styles, then save and reuse them across multiple layouts and objects.
- Modify a style once, and it changes everywhere.

<b>Inspector</b>
- The Inspector, a master design palette, provides one convenient place to access all of the FileMaker Pro design tools.
- Control object alignment, fills, lines, gradients, corner treatments, special effects, text formatting, resizing, grouping, shading, data formatting and much more.
- Choose interactive states such as hover, pressed, or in focus for objects like buttons and fields.

<b>Rulers, Grids and Guides</b>
- Rulers track the position of the pointer as you move the pointer on the layout. When you move an object, such as a field or button, the rulers also display the area of the object.
- Grids ensure everything is well-organized and optimally placed on your layout by displaying a series of nonprinting intersecting horizontal and vertical lines on a layout, which you can use for creating, resizing, positioning, and aligning objects.
- Guides can be shared with all layouts, which can be useful for placing elements in the same arrangement on multiple layouts.

<b>FileMaker Go Overview</b>
Now you can unleash the power of FileMaker Pro to your iPad and iPhone users with FileMaker Go. FileMaker Go will help your mobile users do all this and more:

- Close sales deals faster by uploading signed contracts from the road.
- Update project status and task lists from the job site to keep everyone on track and up to date.
- Log research results in the field and send
- real-time updates to the lab.
- Scan bar codes in the warehouse to instantly update inventory levels on the sales floor.
- Collect patient data in the examination room for immediate access by doctors and nurses.

<b>Create in Pro. Run in Go.</b>
Get the powerful features of FileMaker Pro running on iPad and iPhone.
- Use FileMaker Pro to create iPad and iPhone solutions that run in FileMaker Go.
- Choose from a variety customizable Starter Solutions specifically designed for use on iPad and iPhone for popular tasks, like managing contacts, tracking assets and creating invoices.
- Apply Touch themes specifically designed to make your forms look great on iPad and iPhone.
- Upload solutions created with FileMaker Pro to FileMaker Server or email to your iPad and iPhone for use in FileMaker Go.

<b>Be more productive on the go</b>
Add, edit, search, sort and report on data using FileMaker Go to instantly boost productivity.

- Scan bar codes to instantly see associated data appear in the appropriate fields.
- Capture signatures while on the go.
- Add photos, videos and audio from your device directly to your database with a few taps.
- Create executive dashboard summaries so key indicators and business metrics are always at hand.
- Print report and forms over the air directly from your iPad or iPhone using AirPrint.

<b>Reports and charts in minutes</b>
Reporting is fast and easy with the FileMaker Platform, and it’s built right in - no additional software is required. Track business performance, distribute sales leads, create membership lists, publish key metrics, create ad-hoc reports and more - in just a few clicks. In no time, you can share reports on iPad, iPhone, desktop and the web.

<b>Quickly create spreadsheet-like reports</b>
- Create reports in a familiar spreadsheet-like format.
- Group and summarize your information on the fly directly in Table View to create professional looking reports.
- Easily modify your reports by adding, sorting, or hiding fields and records.
- It's easy to create reports in FileMaker Pro even if you've never used a database before.

<b>Visualize your data with FileMaker Charts</b>
Create eye-catching reports and presentations with FileMaker Charts. You'll be able to more easily visualize, interpret and share your data. FileMaker Charts makes it easy to track sales performance, financial portfolios, progress reports and more. FileMaker Pro comes with a variety of built-in charts including:
- Scatter
- Stacked
- Stacked bar/column
- Positive/Negative
- Bubble
- Bar
- Line
- Area
- Pie
Plus with the Quick Charts feature, you can make your data come alive in just a few clicks. Simply sort your data and then use an integrated set-up window to instantly create and preview your chart. Make a few tweaks, then save your chart. It's as easy as that!

<b>Create executive dashboard summaries</b>
Use FileMaker Charts to create executive dashboards with maximum visual impact. With a few easy clicks, you can produce a visual summaries of key indicators to keep everyone informed and up-to-date.

<b>Create custom reports</b>
- Use the built-in Layout/Report Assistant to guide you in building a new report with grouped data.
- Simply select a layout, choose the fields you want included and pick from 51 stunning themes. Even add headers, footers, subtotals, or scripts.
- To ensure your data is accurate, FileMaker Pro offers validations such as pull-down menus, date range selectors and spell checking.

<b>Sharing your reports</b>
Publish your reports in popular formats such as Microsoft Excel or Adobe® Acrobat®. Just choose the Save/Send Records as Excel or PDF, and your FileMaker information is saved in the selected format. Secure your information by password-protecting your PDFs. You can even distribute your reports via email in a couple of clicks.

<b>Report on data from other applications</b>
FileMaker Pro has tools to help you create database reports with information from back-end systems such as Microsoft SQL Server, Oracle, or MySQL, or from custom applications such as inventory solutions, accounting programs or student information systems.

You can use the built-in data import feature to pull .CSV, Tab, Excel, XML into your database. Or utilize the open ODBC/JDBC standards in FileMaker Pro to exchange data with other applications.

<b>Here are some examples of what you can do with no programming skills:</b>
- Create reports from your corporate data warehouse or SQL-based ecommerce system.
- Import customer order information from Oracle into FileMaker Pro to generate weekly sales reports.
- Bring student data from your student information system to create and distribute bus transportation schedules for all the schools in your district.

<b>Multi-platform sharing</b>
Safely share FileMaker information with iPad, iPhone, Windows, Mac and web users. Whether your team is large or small, it’s easy to share your important business information over a network or on the web. Plus, use popular formats like Excel and PDF to send reports and other essential data to your colleagues.

<b>Sharing with FileMaker Pro and FileMaker Pro Advanced</b>
Once you create a database in FileMaker Pro 13 or FileMaker Pro 13 Advanced, it's so easy to share it with others. If your computers are connected to a network, you and up to five other FileMaker Pro users can access the same database file simultaneously (one license of FileMaker Pro is required for every user). It doesn't matter if you're using an iPad, iPhone or a Windows machine or a Mac, you can securely share FileMaker databases among your team or group.

You can also share your information in popular formats such as Microsoft Excel or Adobe® Acrobat®. Just choose the Save/Send Records as Excel or PDF, and your FileMaker data is saved in the selected format. You can then send your Excel file or PDF via email in just a couple of clicks.

<b>Sharing with FileMaker Server 13</b>
FileMaker Server software supports secure database sharing with large groups of people. If you choose to share databases with more than five people at the same time or you need reliable, high-performance access to your data, FileMaker Server 13 does not limit the number of simultaneous FileMaker Pro or FileMaker Go users.

<b>Share your data in a web browser</b>
Run custom business solutions directly in a web browser on a desktop or laptop with FileMaker WebDirect. Go from creating a solution to making it accessible in a web browser with just a few clicks – no web development skills required.

Available FileMaker Server 13, FileMaker WebDirect is great for working with teams located in remote offices to easily share information. Use it to securely collect information—like status updates, surveys, feedback forms, and more—from geographically dispersed colleagues and associates.

<b>Integrating with FileMaker data</b>

Connect to popular data sources. Set up a Recurring Import and automatically import your Excel data every time you open your database. Or save your information in PDF and Excel formats. Even create secure two-way connections to Microsoft SQL Server, Oracle and MySQL data sources – no SQL programming skills needed.

<b>Connect to your Excel data</b>
Establish a Recurring Import from Excel data that you use regularly. Set it up once, and every time you open your database, the data from your Excel spreadsheet will update automatically in FileMaker Pro.

Imported data is read-only. Use this data to easily create sales reports, track workflow, and collaborate with others.

<b>Combine the web with your database solution</b>
Bring the browsing functionality of the web together with the power of your database. The Web Viewer lets you to point to any web page and display it’s contents in a FileMaker solution. You can even customize the web page based on data in your database. Pass a customer address to a mapping website, or send a shipping number to a delivery company. Do this by creating a custom URL based on data in your database and use a script to receive data from the web page.

You can also embed a complete web application in your FileMaker solution. For example, display invoices from your web-based accounting system within your inventory database.

<b>Use HTTP Post for external data processing</b>
Use the new custom URL protocol type HTTPPOST in FileMaker Pro 13 with the “Insert from URL” or “Import Records: XML Data Source” commands. No plug-ins are required to transfer data to a web server or submit data to complete a web form. HTTP Post does not limit the amount of data that you can send in the request.

<b>Connect to external SQL data sources (ESS)</b>
FileMaker Pro creates secure two-way connections to External SQL Data Sources (ESS) such as Microsoft SQL Server, Oracle and MySQL. You don't have to know how to write SQL queries or have any SQL programming skills to use ESS. Simply add a SQL table or view to the FileMaker Relationships Graph and get a live connection to the external SQL data source. Treat SQL data just like you would FileMaker data. Create custom reports, add calculations and other fields, or create relationships with existing FileMaker data.

<b>Use open ODBC/JDBC standards to exchange data</b>

Use ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) to read from and write to FileMaker databases hosted by FileMaker Server with many external programs and development tools. FileMaker Pro supports up to 5 local connections. FileMaker Server supports up to 50 simultaneous ODBC/JDBC local and remote connections.


<b>FileMaker Pro 13 Advanced Overview</b>
FileMaker Pro 13 Advanced includes all of the features of FileMaker Pro 13 plus a suite of advanced development and customization tools.

Customize menus with just the items you want. Plus, get robust analysis capabilities, powerful debugging tools and much more - all designed to help you build more powerful, more flexible and more customized databases faster.


<b>Additional tools included in FileMaker Pro 13 Advanced</b>
<b>NEW! Enable Database Encryption</b>
Enable AES 256-bit encryption with FileMaker Pro Advanced to protect data on a FileMaker client or on FileMaker Server.

<b>Script Debugger</b>
Pinpoint problem areas in scripts and Script Triggers. Turn off Script Triggers when debugging to fine tune the troubleshooting process.

<b>Custom Menus</b>
Create, change, or delete specific menu items or entire menu sets. Specify certain menus to only display when accessed on an iPad or iPhone.

<b>Data Viewer</b>
Monitor fields, variables and calculations while troubleshooting.

<b>Custom Functions</b>
Build your own functions and copy, paste, and import them into any FileMaker database.
<b>External Function</b>
<b>Plug-in API</b>
Build more robust calculations and extend database capabilities.

<b>Multiple Table Import</b>
Build or modify databases faster by importing multiple tables at once.

<b>Runtime Maker</b>
Create standalone runtime solutions that don't require FileMaker Pro.

<b>Field & Table Replication</b>
Copy field definitions into different tables or copy table definitions into other files for faster solution development.

<b>Kiosk Maker</b>
Build applications where all menus are hidden. Great for self-serve check-ins and mailing list sign ups.

<b>Database Design Report</b>
Run comprehensive reports on all elements of the database schema.