How do I populate an Infopath textbox from a sharepoint field?

[RL Pope]

While it is easy to pull information for a combo box from SharePoint, I am
looking to populate a textbox with information from SharePoint.
Speciffically, I am using the Meeting agenda template. I made a data
connection to make a combo box to pull the subject from SharePoint and I want
to auto populate the duration with the duration from the same subject on
SharePoint.

 

[BethA]

I am trying to do this too! I have tried a few different things and nothing
is working. I just looked at this example:

http://www.infopathdev.com/downloads/free/default.aspx?i=23bd8a37d2a340c1956fff41876dc255

and followed - I made a rule on the field that should trigger the other
field's value change. The action in the rule was to set the other field's
value, but then use the filter data button to only select data that matches
the first field (if I'm making sense).

Nothing is happening, and I'm not sure what to do next...

 

[RL Pope]

After I posted this, I was able to get information from the secondary data
source (SharePoint) and put it in the default data field. The problem that I
run into now is when I apply a filter to retrive data from the correct row in
the SharePoint list, I only get the 'lowest' row accessed (now, if I am
making sense).

For emaple:
A share point agenda list:

SUBJECT OWNER DURATION
New Business Bob 5
Old Business Sue 10
Discussion Tom 15


So on the form, I make the subject a combo box and I want the Owner and
Duration field to be populated with the corresponding data. To do so I set
the default values of both fields to pull from SharePoint and I apply a
filter to match the subject in SharePoint with the subject in the combobox.
These 3 fields are in a repeating table.

When I go to fill out the form, these are the resuts:

Attempt 1 (picking the first choice--Only the first row is correct)

SUBJECT OWNER DURATION
New Business Bob 5
Old Business Bob 5
Discussion Bob 5

Attempt 2 (selecting the second choice first--The first two are corect and
any more show up the same as choice 2)
SUBJECT OWNER DURATION
Old Business Sue 10
New Business Bob 5
Discussion Sue 10

And so on (if I choose the third, I get three corect, and the rest fail).


I am at the same point. . .at my wits end.

 

[BethA]

You're doing better than I did - I'm not getting anything to populate. I'm
wondering if I'm having a problem with needing to trim the text.

Have you looked at any of the posts that mention using current()? I didn't
quite figure that out, but it might relate to your problem.

Good luck - I'll let you know if I find anything else out.

Beth

 

[BethA]

I don't know if this will help you, but I found out what wasn't working for
me: I hadn't selected "Automatically retrieve data when form is opened" so it
wasn't pulling anything in from the secondary data source. Seems obvious now
that I figured it out!

Hope you figure out your "bug."

Beth A