I have created a database that uses a number of global fields in calculations. The global fields allow users to edit the information, without knowing how to change calculations.
I added some of these fields while I was still working offline with the database. They work fine. The last fields I added do not retain their values after I exit FileMaker and other users can't see the global values. From reading the forums, I suspect that I because I added them after the file was hosted on Server 14.
Any suggestions for a way to fix this that doesn't involve scripts (which is exactly what I'm trying to avoid) or taking the file down off Server (which is a big hassle)?
It seems crazy that there isn't an easy way to get global fields to work as expected in hosted files.