Solved

InfoPath Field Values

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

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…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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