Solved

InfoPath Field Values

Posted on 2013-01-28
3
591 Views
Last Modified: 2013-01-29
Hi experts,

Currently I am creating a InfoPath 2010 form with data connections associated. I am attempting to populate a "Sales" member's name and commission rate from a SharePoint list. The list is setup as a Data sources within the form.

What I would like to see happen is when I select "SalesPerson", I would like it to auto-populate their commission rate in another field. To avoid additional data entry.

I have tried every combination with filters and formulas, but have still been unsuccessful.

Any help will be much appreciated!

Thanks,
TG
0
Comment
Question by:techguy57
  • 2
3 Comments
 

Author Comment

by:techguy57
Comment Utility
The form is also being created to be used within a browser..
0
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
Comment Utility
I would create a rule on the control where you select the sales person.

make the action to set a field value.
Commission field in your form should be the target.
The formula would be to select commission field from your data connection but then use the filter button in the lower left of that browse box.
then select salesperson in the data connection list equals the sales person field in your form that was just set.

Usually it is the filter that people miss.  Which is easy to do.
0
 

Author Closing Comment

by:techguy57
Comment Utility
That did it! Something so simple. Thanks a lot!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sharepoint and PHP 12 82
SharePoint 2013 Patch Path 5 35
SharePoint 2013 - User  keeps dropping 7 33
Onedrive for business 3 29
Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now