General

Re: Dropdown blank space

Rager — Wed, 27 Aug 2008 19:44:26 GMT

... agree ((

Hi all,

I have the similar problem, but with some "extensions". I've developed the Loading event hander in the managed code of browser-enabled form. I fill the drop-down list there using the data from the list located on SharePoint site. For example, SP list contains the following data (string):

one
two
three

But when I open the form in the browser I get the following result:

<blank>
three
one
two
three

How can I delete the "three" on point 2? <blank> can't be deleted as I heard (or can yet?? - would be great). But what about "three"? I tied to edit view1.xsl file located within .xsn - nothing happens (if I just hard-code the values within this file - no <blank> and "three" are displayed).

Re: Dropdown blank space

jeeva — Wed, 23 Jul 2008 04:52:01 GMT

Hi Siva,

I try your steps but its not working in my forms.

Re: Dropdown blank space

Shiva — Tue, 22 Jul 2008 07:49:59 GMT

Hello Susmitha,

You have to add the rule and follow these steps,

1. Rules -> ‘Add’ - > ‘Add Action’.

2. Select ‘Set a field value’ option in first dropdown in Action.

3. Select your field with help of ‘Select a Field or Group’ option in ‘Field’.

4. Select your external data source list value in ‘Value’.

This rule you can apply in OnLoad or whenever you will get external data source values.

Re: Dropdown blank space

Susmitha — Tue, 22 Jul 2008 07:36:49 GMT

Re: Dropdown blank space

Susmitha — Tue, 22 Jul 2008 07:19:25 GMT

How can i set the first value of external datasource to the dropdown....Is there any solution for not displaying the blank value??????

Re: Dropdown blank space

Susmitha — Tue, 22 Jul 2008 07:07:26 GMT

Thanq...But am not successful in adding filter....so can u please make it clear.My form is browser enabled

Re: Dropdown blank space

Susmitha — Tue, 22 Jul 2008 07:05:47 GMT

Thanq....But am not able to add the filter condition.......can u please make it clear....My form is a browser enabled form......

Re: Dropdown blank space

jeeva — Tue, 22 Jul 2008 06:52:15 GMT

Hi,

In my case connecting dropdown box to form's data source?

how can i remove that blank .

Re: Dropdown blank space

Anuma — Tue, 22 Jul 2008 06:40:08 GMT

Hi,

Can you add one filter condition while connecting the dropdown list box to secondary data source?

Add filter condition as “Field” is not blank.

Field à from which field in secondary data source you are getting data to the dropdown field.

Re: Dropdown blank space

Shiva — Tue, 22 Jul 2008 06:40:02 GMT

Hello Susmitha Welcome to the Forums,

Whenever we displaying the dropdown values of manual and we have a option called to set default value. Because of here we don’t have option called blank.

For external data source connecting we might have a chance to those entries might not be have any value. For this binding is directly to node but not a value. In manual adding values is we can directly point those values to dropdown list. But in external source we don’t have option called to bind the value of set of nodes to dropdown list. For this it will show the blank value for retrieving from external data source.

If you want to show always first value in dropdown then you can add one rule to set first value of external data source to dropdown list.

Dropdown blank space

Susmitha — Tue, 22 Jul 2008 06:18:00 GMT

Hi, I'm trying to retrieve values into dropdown in Infopath2007 from External datasource i.e., fom SQL server 2005..Values are retieving sucessfully but follwed by blank space.Why it is happening?????How to avoid the blank space comming on retrival......When manually entering values into drop down therz no such blank space found........why itz happening only when trying to retrieve for External datasource?????