Filemaker Pro 13

Errata

View Errata for this book
Submit your own Errata

The FileMaker Pro documentation provides a learning path to productivity, installation instructions, online Help, and more. The following manuals are included: 1 FileMaker Pro User’s Guide (this manual): contains key concepts and basic procedures 1 Installation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced: contains. Download filemaker pro 13 for free. Development Tools downloads - FileMaker Pro Advanced by FileMaker, Inc. And many more programs are available for instant and free download. FileMaker Server 13 and WebDirect are 64-bit processes, for which plug-ins need to be compiled for 64-bit. On Windows, 64-bit plug-ins have a different extension: fmx64. In the download of a 64-bit compatible plug-in you will find this extra copy of the plug-in. Plug-ins for Mac OS X can be universal and the extension is always the same: fmplugin. FileMaker Pro commands, called script steps, specifying options (if necessary), and arranging the steps in the correct order to perform the task. Using this script steps reference The content in this document was originally written for the FileMaker Pro and FileMaker Pro Advanced Help.

FileMaker Pro 13: The Missing Manual

By Stuart Gripman, Susan Prosser

Missing CD-ROM

Download all of these files: FileMakerPro13MM_missingCD.zip

(all .zip files referenced below contain the .fmp12 file)


Introduction

  • Feedback - http://www.missingmanuals.com/feedback
  • Errata - http://tinyurl.com/fmp13-mm
  • Registration - http://oreilly.com/register
  • Safari - http://my.safaribooksonline.com
  • Missing Manuals Library - http://www.missingmanuals.com/library.html

Chapter 1: Working with a Database

  • FileMakerPro13MM_Ch01_missingCD.zip - Example file for Chapter 1

Chapter 2: Managing Data - The Basics

  • FileMakerPro13MM_Ch02_missingCD.zip - Example file for Chapter 2

Chapter 3: Creating a Custom Database

Filemaker pro 13 windows 10
  • FileMakerPro13MM_Ch03_missingCD.zip - Example file for Chapter 3

Chapter 4: Adding Power to Your Database

  • FileMakerPro13MM_Ch04_missingCD.zip - Example file for Chapter 4
  • http://get.adobe.com/reader - Download Adobe Reader

Chapter 5: Creating and Managing a Relational Database

  • FileMakerPro13MM_Ch05_missingCD.zip - Example file for Chapter 5
  • http://www.microsoftstore.com/Visio_2013 - Microsoft Visio diagramming software for Windows
  • http://www.smartdraw.com - SmartDraw diagramming software for Windows
  • http://www.omnigroup.com/OmniGraffle - OmniGraffle diagramming software for Mac
  • http://www.conceptdraw.com - ConceptDraw diagramming software for Mac

Chapter 6: Field Options

  • FileMakerPro13MM_Ch06_missingCD.zip - Example file for Chapter 6

Chapter 7: Layout Mechanics

  • FileMakerPro13MM_Ch07_missingCD.zip - Example file for Chapter 7
  • http://www.50states.com/abbreviations.htm - A list of two-letter state abbreviations

Chapter 8: Layout Design

  • FileMakerPro13MM_Ch08_missingCD.zip - Example file for Chapter 8

Chapter 9: Understanding Calculations

  • FileMakerPro13MM_Ch09_missingCD.zip - Example file for Chapter 9
  • http://www.filemaker.com/help/html/help_func_alpha.html - List of FileMaker functions

Chapter 10: More Calculations and Data Types

  • FileMakerPro13MM_Ch10_missingCD.zip - Example file for Chapter 10

Chapter 11: Understanding Scripts

  • FileMakerPro13MM_Ch11_missingCD.zip - Example file for Chapter 11

Chapter 12: Exploring Script Steps

  • FileMakerPro13MM_Ch12_missingCD.zip - Example file for Chapter 12

Chapter 13: Applying Developer Utilities:

  • FileMakerPro13MM_Ch13_missingCD.zip - Example file for Chapter 13

Custom Functions Websites:

  • http://www.facebook.com/PauseOnError - FileMaker developer conference
  • http://fmfunctions.com - Website dedicated to custom functions
  • http://fmforums.com - A library of custom functions
  • http://filemakertoday.com - FileMaker Today website offers a custom function thread

Chapter 14: Advanced Relationship Techniques

  • FileMakerPro13MM_Ch14_missingCD.zip - Example file for Chapter 14

Chapter 15: Reporting and Analysis

  • FileMakerPro13MM_Ch15_missingCD.zip - Example file for Chapter 15
  • http://maps.google.com - Google Maps
  • www.mapquest.com - Mapquest

Chapter 16: Advanced Calculations

  • FileMakerPro13MM_Ch16_missingCD.zip - Example file for Chapter 16

FileMaker Plug-ins:

  • www.24usoftware.com - 24U Software
  • www.360works.com - 360Works
  • www.cnsplug-ins.com - CNS Plug-ins
  • Filemaker pro 13 training
  • http://fmnexus.com - FMNEXUS (now known as Beezwax)
  • www.nmci.com - New Millenium Communications
  • www.productivecomputing.com - Productive Computing
  • www.qutic.com - Qutic Development
  • www.troi.com - Troi Automatisering
  • www.filemaker.com/support/technologies - Learn to write FileMaker Plug-ins
  • Chapter 17: Advanced Scripting

    • FileMakerPro13MM_Ch17_missingCD.zip - Example file for Chapter 17

    Chapter 18: Adding Security

    • FileMakerPro13MM_Ch18_missingCD.zip - Example file for Chapter 19

    Chapter 19: Sharing Data with Other Systems

    • FileMakerPro13MM_Ch19_missingCD.zip - Example file for Chapter 20
    • http://www.filemaker.com/products/filemaker-server/server-13-specifications.html - Technical specifications for FileMaker Server
    • http://help.filemaker.com/app/answers/detail/a_id/12541/~/filemaker-server-13.0v1-release-notes - FileMaker Server 13 Release notes

    Chapter 20: Sharing Data with Web Direct and FileMaker Go

    • https://www.filemaker.com/products/filemaker-server/docs/concurrent_connections_datasheet.pdf - Information on multiple connection licenses
    • http://www.fmstartingpoint.com - Template for small business solutions
    • https://fmhelp.filemaker.com/docs/13/en/fm13_webdirect_guide.pdf - Guide to designing for WebDirect
    • http://www.sixfriedrice.com/wp/products/rfm/ - Ruby on Rails web technology
    • http://www.lassosoft.com - Lasso web technology

    Chapter 21: Sharing Data with Other Systems

    • FileMakerPro13MM_Ch21_missingCD.zip - Example file for Chapter 21
    • http://www.mysql.com - MySQL (Community Server)
    • http://www.actualtechnologies.com/filemaker.php/ - Find ODBC drivers for the Mac at Actual Technologies
    • http://www.filemaker.com/support/technologies/xslt.html - XSLT resources on FileMaker website
    • http://support.apple.com/kb/DL895 - ODBC Administrator Tool for Mac OS X
    • Appendix A: Getting Help

      • www.filemaker.com/support/downloads/ - FileMaker's support website offers software updates and support files
      • www.filemaker.com/support/webinars/ - Instructional webinars on FileMaker's support website
      • www.filemaker.com/products/demos/ - Free online videos by FileMaker developers
      • www.filemaker.com/downloads/pdf/prof_support_form.pdf - FileMaker's support form to apply for an Annual Support Contract
      • www.filemaker.com/technet/ - FileMaker Technical Network
      • www.filemaker.com/fba/ - FileMaker Business Alliance
      • www.filemaker.com/developers/devcon/index.html - FileMaker Developer's Conference
      • www.fmpug.com/chapters.php - FileMaker Local User Group Listing
      • www.filemaker.com/support/mailinglists.html - Listing of email lists

    (Page updated: November 4th, 2014)
    Below you'll find some information regarding compatibility of Troi Plug-ins with FileMaker Pro 13. This is based on our initial tests. We are performing more tests, and will be providing more information. Please check back for updates.
    (The web page with information regarding compatibility of our plug-ins with FileMaker 12 is still available here.)

    Summary

    Running plug-ins with FileMaker Pro 13

    In general all our plug-ins that worked with FileMaker Pro 11 and FileMaker Pro 12 still work with FileMaker Pro 13. See below for the details on specific plug-in versions.

    Running plug-ins with FileMaker Pro 13 and Mac OS X

    FileMaker Pro 13 for Mac OS X can only run on Intel Macs. All current Troi Plug-ins are Universal versions, which can run on both Intel and PowerPC Macs. Of course on PowerPC our plug-ins will only run under older versions of FileMaker Pro.

    64-bit plug-ins are needed for FileMaker Server 13

    FileMaker Server 13 and WebDirect are 64-bit processes, for which plug-ins need to be compiled for 64-bit. On Windows, 64-bit plug-ins have a different extension: fmx64. In the download of a 64-bit compatible plug-in you will find this extra copy of the plug-in. Plug-ins for Mac OS X can be universal and the extension is always the same: fmplugin. A universal plug-in is a single plug-in that will run on a 32-bit process as well as on 64-bit process. You can not easily see if a OS X plug-in is 64-bit compatible. We have created a simple dropper app called 'Troi Architecture Check' to determine for which architectures a plug-in is compiled. You can download the app here.
    At the moment Troi Activator Plug-in v3.5.2, Troi File Plug-in 7.5.1 and Troi URL Plug-in 4.0 are 64-bit compatible: they will run with FileMaker Server 13 and WebDirect on both Mac OS X and Windows. Please note that running on FileMaker Server 13 and WebDirect Troi Activator can only send messages, not receive them.
    We are working on updates for our other plug-ins to work with FileMaker Server 13 and WebDirect.

    The same plug-in architecture

    The plug-in architecture has not changed in FileMaker 13. So there is no need to change any function calls when converting to FileMaker 13 (as compared to the change in plug-in architecture introduced in FileMaker Pro 7).

    Simple plug-in updating

    Plug-in updating has been simplified in FileMaker Pro 12 and 13. You now store plug-ins in solution files and install updates from container fields. The Auto Update plug-in is no longer needed. All new versions of Troi plug-ins provide an example file to demonstrate this update process in FileMaker Pro 12 and 13.
    NOTE We have already prepared most of our plug-ins for this improved updating process. However, some of our plug-ins still need to be updated to reflect the correct version number (they return 1.0 instead of the real version number). See the table below.

    Location of installed plug-ins

    When you make use of the new plug-in updating functionality the plug-ins will be installed in the same location as with auto-updated plug-ins from FileMaker Server 9 through 11:

    Filemaker pro 13 system requirements
    • Windows XP:
      C:Document SettingsUser NameLocal SettingsApplication DataFileMakerExtensions
    • Windows Vista, Windows 7 and 8:
      C:UsersUser NameAppDataLocalFileMakerExtensions
    • Mac OS X:
      Macintosh HD:Users:User Name:Library:Application Support:FileMaker:Extensions

    TIP If you use auto-update ànd install plug-ins manually: it is best to only install plug-ins in the folders above and no longer use the Extensions folder next to the FileMaker Pro application itself.

    Filemaker Pro 13 System Requirements

    Mac

    Overview of Troi Plug-ins for FileMaker Pro 13

    Here is an overview of all our plug-ins that are native and have been tested to work with FileMaker Pro 13 (and also FileMaker Pro 12 and 11).

    Works native in
    FileMaker 13, 12, and 11
    date of first version*
    Mac OS X
    Intel
    Windows
    remarks
    Activator Plug-in January 13th, 2014
    3.5.2
    3.5.2
    FMP13 version released!
    Troi Dialog Plug-in November 4th, 2014
    5.5.8
    5.5.8
    FMP13 version released!
    Troi Encryptor Plug-in September 25th, 2007
    2.5.2
    2.5.2
    version number is 1.0 with Get(InstalledFMPlugins) function
    Troi File Plug-in May 27th, 2014
    7.5
    7.5
    FMP13 version released!
    Troi Grabber Plug-in April 19th, 2012
    2.3
    2.3
    initial testing shows no problems
    Troi Serial Plug-in March 27th, 2012
    3.2
    3.2
    initial testing shows no problems
    Troi Text Plug-in October 12th, 2006
    3.0.1
    3.0.1
    version number is 1.0 with Get(InstalledFMPlugins) function
    Troi URL Plug-in June 24th, 2014
    4.0
    4.0
    FMP13 version released!

    * This is the first version that was tested with FileMaker Pro 13

    Filemaker Pro 13 System Requirements

    Other older FileMaker Pro compatibility pages

    Filemaker Pro 13 Upgrade

    The web pages with information regarding compatibility of all our plug-ins with other FileMaker versions are still available:

    Filemaker Pro 13 Tutorial

    • FileMaker Pro 13 compatibility (this page)