Skip links

Quick tip: Start file for shared FileMaker database

Script trigger when starting the database

Quick tip: Start a server-based FileMaker database at the click of a mouseWith FileMaker Server any FileMaker databases can be conveniently stored in the local Network or via the Internet. To share a FileMaker file located on a serverDatabase dialog box, either the button [Hosts] or the menu command [Open remote] must be selected. The server that provides the database in the network must then be selected. Only then can the desired FileMaker database be opened by double-clicking or using the [Open] can be started. With a small help database, this process can be simplified considerably by clicking directly on an icon in the Finder or Windows Explorer and the database opens automatically. In this quick tip, we will show you how to create such a help file.

1. create a new FileMaker database

First you create a new database in FileMaker in the normal way. To do this, select in the menu bar under [File] the menu item [New database] and assign a name of your choice. In our example, we call the new database "Start.fmp12".

Create a new database in FileMaker

2. create a start script

In the new database, select in the menu bar under [Scripts] the menu item [Manage scripts] and the script editor will open. Click on the button in the lower button bar [New] and call the new Script for example "Startscript".

Now double-click in the left-hand column in the [Files] the command [Open file]whereupon the command appears in the newly created script. Select the newly created command and then select the command [Add FileMaker data source] from. Now navigate as usual to the FileMaker database that you want to open on the server. In our example, this is the file "gFM_Business.fmp12". The command should now look like this:

Open file ["Your_database"]

Now double-click the [Close file] command in the left-hand column and leave the associated parameter at the default value "Current file". The creation of the start script is now complete.

Start script to open a FileMaker database

3. setting up the script as a start script in FileMaker

In the last step, you must now define the created script as a start script. To do this, open the menu bar under [File] resp. [File] the menu item [File options] and select the register button in the top bar [Script trigger] from. Activate the checkbox in the first option "Open on first window" and select "Open on first window" under [Select...] your created start script.

Script trigger when starting the database

After confirming the dialog with the [OK] you have completed your FileMaker start file and you can now close FileMaker. By double-clicking on your newly created database, you can now test whether the database opens correctly on the server.

After a successful test, you can move your start database to any location, such as the Dock under Mac OS X or to the desktop. To start your database on the server, simply double-click on your start file.

Leave a comment

  1. Thank you for the description. I assume that the procedure for Filemaker on Windows is similar, right? In other words, the operating system must be configured to open the corresponding database when Filemaker is started. The release then also takes place as a start script in Filemaker.
    I look forward to your feedback.
    Best regards,
    Thomas

    1. Hello Thomas,

      This procedure should work in the same way under Windows as under Mac OS X. I do not believe that FileMaker has to be stored in the operating system to open FileMaker databases (although this is usually the case), because the database is opened directly via the FileMaker script (with FileMaker). Just give it a try! :-)

      Best regards,
      Markus Schall

  2. I have exactly the problem mentioned in the first paragraph. I have a Filemaker 12 pro advanced running on a server under Windows Server 2012R2 - with three PCs as clients. (Filemaker Server is somewhat 'overkilled' for my small application)

    After I have set it up exactly according to the instructions, I still get the usual message: The file is in use etc...

    Is there a way to open a database on the server 'remotely' via script without FM Server?

    Kind regards

    1. Now, the host from which the FileMaker database is to be opened should actually be displayed in the client. If you have a local FileMaker database on the client, you should be able to create this database as an external data source without any problems and then use it in a script.

      Best regards from Oldenburg

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: Creating a startup file for a shared FileMaker database