Autopopulating fields with SharePoint data - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Autopopulating fields with SharePoint data

Last post 05-24-2005 02:27 PM by Agni Jonnalagadda. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-24-2005 05:07 AM

    Autopopulating fields with SharePoint data

    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!
  • 05-24-2005 02:27 PM In reply to

    Re: Autopopulating fields with SharePoint data

    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
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.