Filemaker 10 - Global fields reverting

Posted on 2011-05-11
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
    LVL 4

    Assisted Solution

    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

    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 24

    Accepted Solution

    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.
    LVL 4

    Expert Comment

    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.
    LVL 1

    Author Closing Comment

    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 24

    Expert Comment

    by:Will Loving
    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    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…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video discusses moving either the default database or any database to a new volume.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now