Solved

InfoPath Field Values

Posted on 2013-01-28
3
629 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

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

Accepted Solution

by:
clayfox earned 500 total points
ID: 38827530
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
ID: 38831290
That did it! Something so simple. Thanks a lot!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
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…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

734 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