In Infopath 2003 can I import data into drop down fields?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jgleblanc - 26 Sep 2007 16:48 GMT

I am trying to see if I can import a long list into an infopath field, say a
drop down box. I don't want to hand enter 120 items.

Reply to this Message

Ben Walters - 27 Sep 2007 00:58 GMT

Howdy,
Getting items into a drop down list can be done in a couple of ways.
1: is to enter them by hand (obviously not an option at the moment) but good
if you form is not going to be online all the time.
2: You could use the Data Connections in InfoPath to connect to an external
data source (Web Service, Database, Xml file) and then have the drop down
list source the items from the connection. If you need help setting this up
check the following post
http://msmvps.com/blogs/benwalters/archive/2007/08/05/filtered-drop-down-lists-1
01.aspx

Hope this helps

Cheers,
Ben

>I am trying to see if I can import a long list into an infopath field, say
>a
> drop down box. I don't want to hand enter 120 items.

Reply to this Message

jgleblanc - 27 Sep 2007 14:41 GMT

Thanks so much for the reply. I understand about the data source fields, or
the data connections radio button as well. My problem is that my data is
already in excell. So I would have to create an XML, or access data base
just to import from one program to another seems like a lot of work for a
simplae command of cut and paste....

Thank you for your responses.

> Howdy,
> Getting items into a drop down list can be done in a couple of ways.
[quoted text clipped - 13 lines]
> >a
> > drop down box. I don't want to hand enter 120 items.

Reply to this Message

jgleblanc - 27 Sep 2007 14:57 GMT

Ben very nice website link. It didn't answer my question too much, but it
did answer another one. One question though: On your website below when you
are setting up the filtered field did you really want to compare "Make equal
to Make"? Shouldn't it be "Make equal to Model"? Just curious since I am
new to infopath...

Jacques

> Howdy,
> Getting items into a drop down list can be done in a couple of ways.
[quoted text clipped - 13 lines]
> >a
> > drop down box. I don't want to hand enter 120 items.

Reply to this Message

Kalyan G Reddy MVP (GGK Tech) - 27 Sep 2007 07:04 GMT

Hello

Open the Drop Down box Properties and explore the options under list box
entries

Signature

Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com

> I am trying to see if I can import a long list into an infopath field, say a
> drop down box. I don't want to hand enter 120 items.

Reply to this Message