Solved

Sharepoint + Infopath + search list

Posted on 2013-06-25
4
671 Views
Last Modified: 2013-06-26
I have a simple sharepoint list, and have created a form using infopath for the user to enter the information.

Is there anyway to have a button on the form, that the user can click and search a certain field to see if a value already exists in the list - so if a value already exists a message would show that it is a duplicate request.
0
Comment
Question by:dkilby
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
Yes.
create a data connection to the same SP list again
when they start a new entry, query the secondary connection, which will load all values
when they update the field you want to check add an action with condition field equals field in the list and is not blank.
then the action would be a message, make a hidden message field visible since it is web based, and reset the field to blank.
0
 

Author Comment

by:dkilby
Comment Utility
So i created a "search" button that pulls data back from the list using the action on button clicked.

The data pulled back do i put it into a hidden field to then validate against or some other way.

Thanks
0
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
Comment Utility
When you query a secondary data source the information is the but "hidden" if you do not show it in the form view.

so ya you would do the check without showing the user or maybe hae a filtered list to show them the matching record so they could update.
0
 

Author Closing Comment

by:dkilby
Comment Utility
Thanks for the help
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

728 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

12 Experts available now in Live!

Get 1:1 Help Now