Problem with Profile Fields and webqueryopen

My form uses profile fields to provide a list of sections for list boxes, radio buttons etc.

Depending on the various selections, certain parts of the form are either hidden or unhidden.

When an item is either hidden or unhidden, something like “Seq=1#_RefreshKW_MadeBy” is appended to the URL. I am assuming this is a virtual url for the current session.

As long as the extra items in the URL are not shown then everything works fine. If the extra session information is shown then the profile field information is not populated.

I first used @GetProfileField. That was failing so I wrote script in WebQueryOpen to populate various fields from the profile field.

Now it seems when the session information is in the URL, WebQueryOpen does not run at all. I know this because I set one of the fields to a string “AAA” and not from the value of the profile document. So I know the failure is not of the profile document but in the webquerysave itself.

What I did to solve the problem was to place editable fields on the form that hold the various lists of selections from the profile document. The WebQuerySave populates these fields. The fields have a hide when for when the form is displayed in a Notes client but “display” on the web. I then set the HTML attribute to type=hidden so they don’t really display on the web. The hidden fields act as a “placeholder” for the various sessions.

Anyone have any better ideas?

Subject: Problem with Profile Fields and webqueryopen

Possibly if you use @DbLookup instead of @GetProfileField you may have better luck? It would require architecting your solution somewhat differently to use normal documents instead of profile documents and I’m not even sure if this is the issue. However, it seems like your problem is transient and sometimes this can be attributed to Profile documents.

Subject: RE: Problem with Profile Fields and webqueryopen

I thought about that but I have an easier change (I guess).

I added editable fields on the form that are hidden on the client but show on the web. I gave these fields the type=hidden attribute so they don’t show in the browser. I created a WebQueryOpen agent to populate these fields.

I then use the contents of these fields as the forumla for the various lists.