refresh globals

[rivet]

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?

[iMarcW]

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.

[rivet]

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