I have a pref table with a global calc field, that returns the variable; $$title

I have done this to display the project name on all layouts.

The problem is when the user switches to another project, which changes the $$title variable, the global field in the prefs table (single record) need to be refreshed to display properly.

any suggestions on the best way to fresh the prefs filed?

Make the global calc field an unstored calc, perhaps?

Otherwise, maybe the project-switching script, if there is one, can take care of resetting the variable, if it doesn't already.

figured it out.

In the same table I added a text field that is set along with the variable, which is used in the calculation of the global field, which forces an update.

variable_refresh.zip