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.

Featured Replies

Righto, im currently utilizing text globals as critical relational fields... i know they are session specific but ive got them set as auto enter calculations... is there any reason they would disapear despite being setup as auto enter ... ?

Cheers in advance, genx

Does the auto-enter calculation replace existing values? If so, could it be replacing the existing value with blank data. Perhaps you could set these using the Opening Script?

  • Author

...the opening script, that seems like an ok idea but a bit extensive, could you explain to me exactly how globals work? and exactly when a text calculation will recalculate?

IMO, an Opening Script is essential. A good GUI should resize the window to fit content, show/hide the Status Area, zoom to 100%, etc. It's very easy to setup, a basic one takes a couple of minutes.

Globals have a single value regardless of which record is current. Every user will have a private copy of a global. Globals are also commonly used to store graphic elements of the GUI in container fields (which users never modify). In a multi-user environment, the OpeningScript should initialize any globals that the user will manipulate to avoid problems with who-did-what-when.

Global calculations will recalculate if any of the fields within change. It's common to use a trigger field to force recalculations, and a common trigger field is a field set to auto-enter the modification time. An example is:

Left( GetAsText ( TriggerField ) ; 0 ) & SomeOtherStuff

The Left.. does not add anything to the string, but it's presence will cause the calculation to reevaluate when the trigger field changes.

I'm a bit brain dead tonight, so if my explanations are not clear enough, do speak up!

  • Author

no, that was all clear, i do have an opening script and a fairly complex one at that, i was just refering to setting the globals (there are a fair few) every time the file was opened...

Speaking of which are globals user specific then?... or session specific?

Cheers, genx

Globals are user specific because in a multi-user situation each user has their own private copy of globals.

Session specific is trickier. A guiding principle is that globals are only "saved" into the file when the file is closed. In FileMaker Pro, when the host user closes a file, their values of the globals are what gets saved (since they're the last to close the file). Until they close it, other users get the value of the global from when the host user opened the file. In Filemaker Server, since there is no host user, the globals are never saved, the value in the file when opened by Server is always the value all users get.

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.