dkilby
asked on
Sharepoint + Infopath + search list
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.
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.
ASKER
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
The data pulled back do i put it into a hidden field to then validate against or some other way.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help
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.