Skip 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.

Running scripts on server?

Featured Replies

Can you run scripts on FileMaker Server 5.5?

This may sound bit odd, but here's why I'm asking:

I have a plug-in (Troi Activator: phenomenal!) that allows you to schedule things to take place (i.e. running scripts, backups, etc.). I have programmed my databases so that it'll do certain functions on a preset schedule, but these scripts have to take place on the server. Is this possible?

you can't do scriptmaker scripts with filemaker server. server only serves files, nothing else. As far backups though, server 5.5 has the ability to schedule live backups of served databases. To run the scriptmaker scripts on a schedule, you have to have a client machine that is always connected to the server, and then use Troi to schedule the scripts on the client machine.

  • Author

Ah, I was wondering about that. Let me ask this then:

I have a database that stores all my settings in global fields. Unfortunately, since globals are relative/local to the current machine, whenever the global settings are changed, they don't change on the server. Is there a way for me to be able to change the global values on the server machine so it applies to the entire network, or is there something else I could/should do?

Thanks!

The only way to change the global defaults is to take the file off the server, open it locally in FMP, change the values and close the file.

A different way to handle this would be to create a dedicated file for global values. Except that the fields wouldn't be globals, they would be plain fields, and there would only be one record in the file, so any changes made to the fields would be seen be all users.

The trick will be in creating the constant relationship to the file from your other files so that the values can be referenced from other layouts.

  • Author

Yes, that's the conclusion that I've come to. What I've figured out is that I'll have normal fields with the settings that people change. Then, when the user opens the file, an On Open script will set the identical global fields to the values of the stored normal fields so the settings are the same no matter what the relationship is.

Follow up: is it possible to run scripts in any of the more recent versions of Filemaker Server?

Thanks so much for your help!

  • Author

Dang. Why can I not use:

Set Field[ gEnsembles-4, "GetRepetition( Ensembles, 4 )" ]

It won't set any repetitions of global fields greater than the first repetition. It also won't paste into any repetition of a global field except for repetition 1. How do I get around this??

Set Field[ gEnsembles-4, Ensembles ] should work. When setting the same repetition as you are referencing, there is no need to specify the repetition number in the calculation.

There is a bug when using GetRepetition, but it only becomes a problem when setting a different repetition than the one being referenced, such as setting the third repetition of a field with the second repetition of another.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.