If a global affects only you as a user. How do you set a value in a script to affect all users instead of just yourself? For example as an admin, the system is up or down.
set the value in a table/record that everyone appropriate has access to and cause a commit. If commit is successful then everyone with access will see the data change.
The two most common methods are:
1) Put the data in non global fields and use a Cartesian join to link it to every table occurrence where you need access to this data.
Pro: the data is accessible just as soon as you commit the data.
Con: you might need to link occurrences of this table to a lot of other table occurrences.
2) Use the same record with nonglobal fields as 1), but use a script performed by the OnFirstWindowOpen trigger to set global fields to this data.
Pro: No need to complicate your relationship graph with a lot of added table occurrences.
Con: Any update of this data only appears when the user next opens the file.
My answer is not conventional nor can I claim credit for it. See Instant Messaging In FileMaker from Inspirations Software Design LLC.
This messenger would allow to reach everybody at once. I have it on several databases for years. Never any problems and you can set it up in 30 minutes.
ExecuteSQL() can avoid linking, but calculation become very long. I guess someone made custom function for this.
Retrieving data ...