Global field not saving changes

[Matt Malyschko]

I have a global field on a Settings table that stores the email address for an outside contact to the system. Sometimes this email changes, hence setting it up in this manner.

 

However, whenever I load the file, this field is ALWAYS blank. Even after editing it multiple times.

 

I've tried everything I can think of - committing records, manually saving records, etc.

The file is a hosted solution, but all the other fields on the Settings table work perfectly.. why would this occur? It's doing my head in!!

 

Thanks in advance!

[Lee Smith]

Global fields are local in a served environment. 

[doughemi]

Is the Settings table a one-record table?  If so, you can relate a Table Occurrence of it to each table or TO that needs to access the settings.  Use a Cartesian (X) relationship.  (And of course, change the global fields to normal storage.) Then, the setting is available to any user in any context.

[webko]

What was the value of this field *before* it was placed in a served environment? Because that will be the value that shows on any login to the served system...

 

Global fields will always start (in a served environment) with whatever their last value was when it was not a served file (ie, just before you opened it in FileMaker Server)

 

Most people then use a script on login to change these values if required. Just changing the global field will not work - the next time you login, it will revert to the default value from just before it was served...

 

HTH

[Matt Malyschko]

Is the Settings table a one-record table?  If so, you can relate a Table Occurrence of it to each table or TO that needs to access the settings.  Use a Cartesian (X) relationship.  (And of course, change the global fields to normal storage.) Then, the setting is available to any user in any context.

Makes sense, thanks.