[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Filemaker 10 - Global fields reverting

Posted on 2011-05-11
Medium Priority
Last Modified: 2012-05-11
I have two global fields that I use once a year to help with a calculation.  I find that, although I change their value, the next time the database opens, they revert back to their original data.  I have looked at the opening scripts, etc., and there is nothing that tells them to do this.  Kind of strange and not sure where to look.
Question by:ServalStudios
  • 2
  • 2

Assisted Solution

challengeday earned 200 total points
ID: 35740578
What happens if you change the value, close the database and open it immediately following?

I assume you also looked at any script that might run when closing the file.

What I do when I need to find out what is modifying what is to run a Database Design Report  (from the Tools menu) with Report Format XML. Then open it up using a free program called XML Viewer http://www.mindfusion.eu/product1.html

I can then do a search for the field name and just go through every instance of it.

The other thing you can take a look at is making sure there is a field on the table that captures modify date time and modify account name. This at least will show you when and by whom a field on that table was last modified.
LVL 25

Accepted Solution

Will Loving earned 800 total points
ID: 35740834
If the files are being hosted on FileMaker Server, then each time you open the files, the global fields will display the last value that was in them when they were opened directly in FileMaker Pro - not as a guest, but directly. Global fields in hosted files will always loose any recently entered value and will display the last stored value - when they were opened as a single file - when they are next opened as guest.

To change the default value in a global field for hosted files, go to the Server, Stop FileMaker Server, open the files directly in FileMaker Pro or Advanced and change the value in the field.

To have a field retain data from one session to the next, you either need to be using the files opened directly in FM Pro and NOT using FM Server, or, if you are using hosted files, you need to use something other than global fields. Often developers will setup a table with a single record in it that contains all kinds of default values and preferences in regular, non-global storage, fields. You can then create relationships from those fields, treating them essentially as global fields because there is only one record in that table.

Alternately, you can use a Set Field script script to save the contents of a global field to that one record table and similarly use a Set Field script step to load that value into your calculation global each time you need to run it.

Expert Comment

ID: 35740926
That's excellent info about the workings of Global fields on Server.

We use the table with single record willmcn mentions.

We also run a startup script that sets some needed  global fields.

Author Closing Comment

ID: 35742173
I would have never guessed it was the Filemaker Server. This is interesting to know.  So I just open the database that is stored in the server database folder to change these fields?  I was thinking this was happening before the server, but probably not.

I also would like to do the database design report, as I have never done that before and could yield some interesting info.
LVL 25

Expert Comment

by:Will Loving
ID: 35742915
Make sure you stop the FileMaker Database Server in the FMS Admin Console before attempting to open the files in FM Pro or FM Advanced. Make you changes, quit FM Pro and then restart the Database Server in the Admin Console.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question