New features in FileMaker Pro 10
FileMaker Pro 10 includes the following new features and improvements.
|
•
|
Status toolbar — Use the redesigned status area, which now appears as a toolbar at the top of the FileMaker Pro window, to perform most tasks. For example, use the status toolbar to quickly perform Find requests in Find or Browse mode. Drag your mouse pointer over the status toolbar to display tooltips. See Using the status toolbar.
|
|
•
|
Saved finds — Save complex find requests for use in future FileMaker Pro sessions and access recent finds using buttons in the status toolbar. See Saving a find request and Managing saved find requests.
|
|
•
|
Improved Find mode — A small icon
 now indicates the fields you can use to search your database. See Making a find request. |
|
•
|
Layout object tooltips — You can now use FileMaker Pro to add descriptive text that appears when users move the pointer over layout objects in Browse or Find modes. See Adding tooltips on layouts.
|
|
•
|
FileMaker Quick Start Screen — Create a FileMaker Pro database from a Microsoft Excel file or a Bento 2 (or a later supported version) file. See Using FileMaker Quick Start to open files. Access instructional materials, such as videos and the FileMaker Tutorial, from the Learn More panel. See Using FileMaker Quick Start to learn more about FileMaker Pro.
|
|
•
|
Improved Starter Solutions — Create a database from an updated Starter Solution template to take advantage of the best new FileMaker Pro features. See Creating a FileMaker Pro file.
|
|
•
|
Advanced recovery options — Perform a consistency check on files you suspect might be damaged, select specific file components to be recovered, and view information about the file’s status. View a detailed file recovery log both during and after the file recovery process. See About recovering FileMaker Pro files.
|
|
•
|
Dynamic subsummary reports — See recalculated summary values in real time in Browse mode when data changes. See Viewing records as a form, list, or table.
|
|
•
|
More layout themes — Choose new layout themes in the New Layout/Report assistant to enhance your reports. See Creating a layout.
|
|
•
|
Sort order — See new records appear in sorted order when you add records to a found set. See Sorting records.
|
|
•
|
Additional support for ODBC data sources (also known as external SQL sources or ESS) — Display, access, and use data from SQL tables in Microsoft SQL Server 2008, Oracle 11g, and MySQL 5.1 Community Edition. Define value lists using fields in ODBC data source tables. Use Windows authentication (single sign-on) to access ODBC data from Microsoft SQL Server. Accurately access SQL-supported timestamp data from ODBC data sources. See Editing ODBC data sources.
|
|
•
|
Microsoft Excel 2007/2008 — Import data from and export data to Excel 2007/2008 format files. See Saving and sending records as an Excel file.
|
|
•
|
Better support for importing data from Bento 2 (Mac OS) — Use standard import procedures in FileMaker Pro to transfer information from a Bento 2 (or a later supported version) data source to a FileMaker Pro file. See Importing Bento data (Mac OS).
|
|
•
|
SMTP-direct email support — Choose File menu > Send Mail or use a script to send email messages directly from FileMaker Pro files without using email client software. See Sending email messages based on record data or the Send Mail script step.
|
|
•
|
Script triggers — Specify that a script runs when a specific event occurs, such as when a user or script enters, changes, or exits a field; when a key is pressed; when a field is modified; or when a record is committed. See Setting up script triggers.
|
|
•
|
Scripting user interface improvements — Use the Manage Scripts feature (formerly ScriptMaker) to display a default script you can use as a starting point for writing your own scripts, see whether individual script steps are supported in web publishing or in FileMaker Server schedules, and more. The Manage Scripts dialog box no longer opens in a maximized state when the FileMaker Pro window is maximized. See Creating and editing scripts.
|
|
•
|
Error reporting improvements — Control script steps no longer clear the last error condition reported by FileMaker Pro. See Control script steps.
|
|
•
|
Install OnTimer Script script step — Runs a specified script at the specified interval. See Install OnTimer Script.
|
|
•
|
Open Edit Saved Finds script step — Opens the Edit Saved Finds dialog box, which lets the user define new Find statements or edit existing Find statements. See Open Edit Saved Finds.
|
|
•
|
Print script step — Improved to let you save a specified target printer with a name of any length when a script runs. See Print.
|
|
•
|
Set Field By Name script step — Lets you use a calculation to dynamically specify a field name in a script rather than requiring you to specify each possible field name in an If...Else construction. See Set Field By Name.
|
|
•
|
Char(number) function — Returns the character or characters representing the Unicode points for a specified number. See Char.
|
|
•
|
Code(text) function — Returns the Unicode point or points for the specified text characters in Number format. See Code.
|
|
•
|
GetFieldName(field) function — Returns the fully qualified field name (tableName::fieldName). See GetFieldName.
|
|
•
|
Get(DocumentsPathListing) function — Returns a recursive list of files and folders located in the folder returned by the Get(DocumentsPath) function. See Get(DocumentsPathListing).
|
|
•
|
Get(TriggerKeystroke) function — Returns the text string that activated an OnObjectKeystroke or OnLayoutKeystroke script trigger. See Get(TriggerKeystroke).
|
|
•
|
Get(TriggerModifierKeys) function — Returns the state of keyboard modifier keys (such as the Shift and Control keys) when a script was triggered. See Get(TriggerModifierKeys).
|