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,
[email protected], 444-555-5555 listed as a contact in SP.
When I choose "John Smith" from the DocOwner pull-down, I want the
"
[email protected]" 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!