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.

Default Global Fields

Featured Replies

Does anyone know how to set a default value on global fields. Right now, I can't really make out what determines its initial value.

Sometimes it looks like the last thing I picked (as admin) but that isn't always the case.

Global values default to the last value held when the file was closed in single-user mode.

In any multi-user scenario, it is best practice to not rely on this default, but to explicitly set the global to its pref value in an UpdateGlobals script (probably a subscript to an Open Script).

This depends on how you are hosting the database.

Global fields will retain their last value when they were last hosted by FMPro/FMPro Advanced.

In a peer-to-peer setup, only the HOST can change the default global values, the CLIENTS CANNOT change the default global settings, but will do so for their own working session.

IN FMServer setup - no one can change the default global values. These must be set by FMPro (as HOST) prior to uploading to the server.

If you have a 1 record table for "constants" and "globals" (or a table each), then there is another possibility, which is a "constant global calculation," that is a calculation with global storage. Generally you'd have the value in a regular field, say a container, then a calculation field which does nothing but equal the regular field, but with its storage set to global.

It can be used in cases when you have something which you want to be available everywhere, without needing multiple relationships (from different table occurrence groups). It does not need to be set on startup, as it is always there. But you cannot change it easily, except by going to the Constants table and changing the original field.

It is useful for things like button graphics, the business's logo and info, etc., things which seldom change.

One glitch is that the calculation takes a little while to update on screens after changing the original, in hosted situations. So it is best for things that change rarely.

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.