Jump to content
Sign in to follow this  
Flynn

Missing Global Field Data

Recommended Posts

I have a problem with global fields when running or filemaker server

When data is chanaged in a global field the information is lost after the user closes the database.

If the global field is set before it is activated on filemaker server this data will stay, but again reverts to the original entry after the user closes the file

How do I get the global field to retain its data

Thanks

Share this post


Link to post
Share on other sites

The behavior you are seeing is the correct behavior. Globals are local to each user.

To maintain persistent values, you can use either a one record table or you can close the files, open them in FileMaker Pro, set the globals, close the files, and then reopen with FMS.

Steven

Share this post


Link to post
Share on other sites

Does this mean that global fields in a server environment are temporary and or locked to an original entry before the database is activated on a server?

Edited by Guest

Share this post


Link to post
Share on other sites

Both.

In a multi user environment any user can have their own data in a global but once they quit a session the data is lost and on restarting a session any user will find the data in a global to be set to that which the global contained when last closed in single user mode

HTH

phil

Share this post


Link to post
Share on other sites

Global values are local to each user. They get their initial value from the value stored with the database when last opened locally, but user modifications to the global values are independent of each other (i.e. my changes to the global will not be shown on your copy) and will not be stored in a hosted file.

If the users need a single value that is shared between them (with updates being propagated to all users) then you should consider a single-record table.

If you want the users to be able to have and modify their own values perhaps you should consider user-specific records in a USERS table or such rather than global fields. Both of the above methods have the drawback that you need relationships to the tables to see/manipulate the values.

If the global values aren't meant to be modifiable you might consider making the field a calculation field with global storage. You get all the benefits of a global field (referenced without relationships on the graph) with the added ability to change its value on the server, albeit you will need to do so in Define Database.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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