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!

Global fields are local in a served environment. 

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.

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

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.