Solved

InfoPath Field Values

Posted on 2013-01-28
3
631 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

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. …
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

624 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