Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Scheduled scripts and external databases

Featured Replies

We are running FMS 11 Server advanced and also run a 'robot' FMP 11 Client on a separate computer on the network, whose job is to assemble a certain data set overnight from databases on the Filemaker server - this dataset is used for personnel scheduling.

A Planning database on the server references the robot's scheduling data and updates it's own dataset. The script in the Planning database that runs the update calls several scripts in the robot client. This script works correctly when run locally from a client.

We set up a schedule on the server to run the update script in the Planning database but it does not appear to work. Using the 'Show Compatibility' box on the update script does not show the Perform Script steps which refer to the external database as incompatible.

Are server side scripts able to call scripts in remote databases?

Thanks

Brian

Page 133 in fms11_help.pdf

"A server-side FileMaker script that is running on one FileMaker server cannot open a database that is hosted on a different FileMaker server."

  • Author

Thanks @supernatural

That was it - looked at the log files and the Perform Script steps to the external files were giving error 100 (file not found)

Brian

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.