Removing Blank value

[Sony]

I have a sharepoint list using secondary data source that has only one entry
per column. I need to remove the null and only show the value that is
listed. I have seen a lot of articles and all seem so complicated and too
much work for one item per drop down box. Is there an easy way to do this?
Thank you.

 

[Ben Walters]

Sony,
I'm a little confused, as you describe it you have what sounds like a custom
sharepoint list this list has a couple of columns and each column represents
a single value so lets say for this example
FirstName, LastName, DOB
If this is the case then I'm not sure why your list would have null values
in one of the columns?

Could you perhaps provide more details?
Cheers,
Ben

 

[RJ]

My apologies, I was not thinking right. When you use a drop down list using
data connection to a sharepoint list, there is a blank value before you
actually see a list. I need that removed so it would look like its automated
for the user with that information in the form. I just want the info to be
defaulted to that text field( drop down control) so you wouldn't have to drop
down the list. There is only just one item and it would be annoying to have
to drop down a list just to get that one item. What do you suggest? I am
new to all this. Thank you for your time. I just read your post with
someone having a similar issue as mine. And webservice is something that I
will have to do as well? If so, please help me, i get stuck on how to
determine sample value.

 

[Ben Walters]

Hey RJ,
If there is just one item in the sharePoint list then there is really no
need to use a drop down control to display it ,
As it sounds like you want this value to appear when the form first opens I
would add rules to opening of the form to get this value and copy it into a
text node.

To do this first change you drop down list to a text box control.
Then select Tools>Form Options
The first tab of this dialog should be for open and save,
Under the Open bahaviour section click on the Rules button,
Add a new rule that set's a fields value,
Set your display field to equal the value returned from the sharepoint list


hope this helps if you need more details let me know

Cheers,
Ben Walters

 

[RJ]

Yes i need a few more details on how to get a data connection to that list
unless I am making it more difficult than it really is. How do I make this
happen? "Set your display field to equal the value returned from the
sharepoint list"

thank you so much for your time.

 

[Ed Thurber]

RJ:

You will want to set the Default Vaule for that element. There is a field
on the Properties page. click the formula button. click the Insert Field
or Group button. From the Select a field or Group dialog, select your
secondary data source from the dropdown at the top, then select the element
that contains your value.

click OK a couple of times. Be sure that your datasource is configured to
automatically download when the form is opened and that the "update..."
checkbox is selected below the default value field.

hope this helps

ed

 

[Frederik Van Lierde]

Hi Sony

There will be always a blank line.
If you need to be sure the user is selecting a value, just select the
Can not be blank checkbox in the dropdown listbox properties dialog
box.

Frederik Van Lierde
http.://www.SilverSandsAssociates.com
http.//BlueInfoPath.blogspot.com

 

[RJ]

thanks! Always discovering little things that you oversee that is so simple,
it worked and did exactly!