Variables on server when document updated

[isaiah82]

Hey All - I have a bit of a tricky situation I'm wondering if anyone else has come across. Using QV/QVS 8.2.

When my document is loaded (OnOpen trigger) I call a macro to set a variable value hidden to the users. This is used as part of a security model. The is set based on the value of an expression stored in another variable. In short, you could say it sets the value to the user's AD username, but is important so it can be overriden manually by select users.

I'm finding when the document is updated (e.g. saved by me) and refreshed automatically in the user server sessions, the value of this variable is overwritten by the value set when I saved the document, which is causing me trouble. I need a way to recalculate/repopulate the variable like it's done when the document is initially opened.

Anyone done anything like this before? Thanks! -Isaiah

[#2 · Accepted solution]

I do something similar. You have to set the variable to be a formula (i.e., beginning with an = sign).

In the OnOpen Action, I set my variable to ='=OSUser()' then the objects have conditional visibility based on that variable.