Controls

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 18:52:50 GMT

I'm glad that I could help you

Re: Add items to dropdown list through VBscript.

vamirineni87 — Fri, 24 Sep 2010 18:51:13 GMT

You are the man!!!

I never used binding before so, it was kinda confusing when I read binding.

I really appreciate the help.

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 18:42:55 GMT

Here I save it to 2003 xsn...

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 18:33:23 GMT

Arf, ok check my image, I add 2 group and I bind my drop down to this group.

Re: Add items to dropdown list through VBscript.

vamirineni87 — Fri, 24 Sep 2010 18:12:48 GMT

EDIT: I only have office 2003. So I cannot open the form you have attached.

----------------------------------------------------------------------------------------------------------

The error is minor.
The ; semicolon at the end is screwing things up for some reason.

For this statement
oItem.selectSingleNode("XPATHNameChild").text = "name"
XPATHNameChild doesnt make sence to me.

if my fields are setup like this, "//my:myFields/my:fldChoices", there are no XPATHNameChild and XPATHIDChild.
So do I have to create other fields and somehow reference them to the dropdown?

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 18:11:21 GMT

Ok, tell me if it's ok for you.

Re: Add items to dropdown list through VBscript.

vamirineni87 — Fri, 24 Sep 2010 17:52:45 GMT

Here you go. The field name is 'fldChoices'

and there is a button that tries to populate the dropdown.

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 17:48:12 GMT

Can you please attach your form template ? when you reply click on option....

Re: Add items to dropdown list through VBscript.

vamirineni87 — Fri, 24 Sep 2010 17:44:42 GMT

I have tried something very similar before. However this is the error I get when I try to preview the Infopath (2003) form.

Expected end of statement
File:script.vbs
Line:279
Set oItem = XDocument.DOM.selectSingleNode("//my:myFields/my:fldChoices").cloneNode(true);

any ideas as to why this is occuring?

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 17:40:30 GMT

Here some example of VBS :

Dim oItem

Set oItem = XDocument.DOM.selectSingleNode("XPATH").cloneNode(true)

oItem.selectSingleNode("XPATHNameChild").text = "name"

oItem.selectSingleNode("XPATHIDChild").text = "ID"

XDocument.DOM.selectSingleNode("XPATHParent") .appendChild(oItem)

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 17:25:23 GMT

Ok, I suggest you to use a reference field of your node and clone it, after that you append it to real node. To do that create a new group like "reference", right click on your repeating node, select reference...

Re: Add items to dropdown list through VBscript.

vamirineni87 — Fri, 24 Sep 2010 17:18:01 GMT

I used code to query for the data. Its not a list. Its user information from GetAllUserCollectionFromWeb.

It returns an xml file that I want to parse and load usernames into a dropdown.

I figured out how to parse it and get the list of usernames and the IDs. but having problem populating the dropdown using the usernames as display names and IDs as values.

I guess may be a "append" method of some sort?

Re: Add items to dropdown list through VBscript.

Potemkine — Fri, 24 Sep 2010 17:07:56 GMT

hi, when you say

vamirineni87:
based on xml returned by a sharepoint webservice

you mean you use the Infopath Wizard or you use code to query your list?

Add items to dropdown list through VBscript.

vamirineni87 — Fri, 24 Sep 2010 15:59:14 GMT

I am trying to populate a dropdown in infopath form, based on xml returned by a sharepoint webservice. (I know what u are thinking, why code? I need to perform some business logic before populating it)

The problem i am facing is that I do not know how to add the items to the drop-down.

I found this, http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/c9593115-24c1-4c3c-960e-3149916f3fdb

It does exactly what I need, however its not in VB script, and I am not familiar with converting it over to vb script.

Is there a method or way to clone an item of an item from the dropdown and append to it in VBS.

copyitem = DOM.SelectSingleNode("//my:myFields/my:fldChoices").clone()

copyitem.displayname = "";

copyitem.value = "";

dropdown.append(copyitem)

thanks in advance