Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / December 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RL Pope - 27 Dec 2005 19:01 GMT
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 - 28 Dec 2005 18:17 GMT
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=23bd8a37d2a340c1956fff4
1876dc255


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 - 28 Dec 2005 19:04 GMT
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.

> I am trying to do this too! I have tried a few different things and nothing
> is working. I just looked at this example:
[quoted text clipped - 7 lines]
>
> Nothing is happening, and I'm not sure what to do next...
BethA - 28 Dec 2005 21:05 GMT
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 - 29 Dec 2005 04:18 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.