Re: Autopopulating fields with SharePoint data

Agni Jonnalagadda — Tue, 24 May 2005 21:27:06 GMT

Hi Jhon,
Welcome to the Forum!
You need to add a Rule which queries your sharepoint list when you select "DocOwner". (There is a rule which can query a dataconnection)

Add another Rule which sets values for other two fields.
Hope this Helps!

Agni
InfoPathDev India

Autopopulating fields with SharePoint data

moneytrain8 — Tue, 24 May 2005 12:07:22 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.

If there is another (or better) way to do this, maybe via an Access backend or some other data source, that's fine, too. I don't ned to use the SharePoint back end, but since we are using SharePoint as our CM source, I figured that would be best.

Any help would be greatly appreciated.

Thanks!

SharePoint Integration

Re: Autopopulating fields with SharePoint data

Autopopulating fields with SharePoint data