< Back

Document Subject: WebQueryOpen computed fields
Hint Short Cut: Add this to your code & documentation to help you find this page.
http://#WQOComputedField or http://A555F9/nn.nsf/ByAlias/WQOComputedField

Setting a field in the WebQueryOpen event agent works well for editable fields, but for computed fields it gives annoying results...




For prepopulating editable fields you can so this by setting a field in the WQOform agent.

NB Tip calling agents WQOformname or WQSformname makes it clear where the agent is used !

Get the documentcontext like normal:

Dim s As New notessession
Dim db As notesdatabase
Set db = s.currentdatabase
Dim doc As notesdocument
Set doc = s.documentcontext

and then set the field

doc.name="whatever"

this will then come up as editable value in the field name in the web form.

Note the document does NOT need to be saved.

 

For a computed field you need:

doc.cname="computed value"

doc.cnameWQO="computed value"

then on the actual form

the computed field "cname" is set as computed with the value: cnameWQO

and another editable field cnameWQO which is hidden on the form when reading

and also has the HTML other set as type='hidden' with no value set .

Notes: the document does NOT need to be saved in the WQO agent.

If the web form is not saved then no document is created.