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 / May 2005

Tip: Looking for answers? Try searching our database.

Autopopulating fields with SharePoint data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John K. - 23 May 2005 23:09 GMT
Hello,

I have a form that has SharePoint Contacts data at the backend.

What I am trying to do is this:

When a name is selected from the DocOwner pull-down (the list is from the
SharePoint FullName list), I would like the DocOwnerEmail and DocOwnerPhone
pull downs to be automatically populated with that DocOwner's information. or
example:

I have John Smith, jsmith@ms.com, 444-555-5555 listed as a contact in SP.

When I choose "John Smith" from the DocOwner pull-down, I want the
"jsmith@ms.com" and "444-555-5555" to be automatically populated in the
appropriate fields.

I am guessing I can do this as a rule, but with 20 users that may change
over time, I'd like to find a general way to populate the appropriate fields
by just choosing the name of the contact.

Any help would be greatly appreciated.

Thanks!
Greg Collins [InfoPath MVP] - 25 May 2005 23:07 GMT
Rules or code will work. You need to filter the contact information, based on the selected user, to get the correct information to populate the fields with.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

Hello,

I have a form that has SharePoint Contacts data at the backend.

What I am trying to do is this:

When a name is selected from the DocOwner pull-down (the list is from the
SharePoint FullName list), I would like the DocOwnerEmail and DocOwnerPhone
pull downs to be automatically populated with that DocOwner's information. or
example:

I have John Smith, jsmith@ms.com, 444-555-5555 listed as a contact in SP.

When I choose "John Smith" from the DocOwner pull-down, I want the
"jsmith@ms.com" and "444-555-5555" to be automatically populated in the
appropriate fields.

I am guessing I can do this as a rule, but with 20 users that may change
over time, I'd like to find a general way to populate the appropriate fields
by just choosing the name of the contact.

Any help would be greatly appreciated.

Thanks!
 
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.