Fix a field value for a QV document

[felcar2013]

hi

do you know if it is possible to "fix" a value for the whole document? Lets say, i want always that the last timestamp is selected as default for all my document objects, so that i do not need to select it or i do not need to tell the user to always select that value.

thanks

[Anonymous · Accepted solution]

You can set up an action on opening of the document (Document properties > Triggers > On Open > Select in Field). You may need to put in an expression to assign it to =max(TimeStamp).

Jonathan

[somenathroy]

One approach could be taken:

Declare a variable vMxTimeStamp = Max(TimeStamp)

And then have to include this variable in all document objects's expression like

Sum(TimeStamp={<$(=vMxTimeStamp)>} where applicable.

But this solution does work as long as a user session is live. When a user starts another session vMxTimeStamp is reset to Max(TimeStamp).

Regards,

Som

[felcar2013]

thanks for your answer! it was very useful