?
Solved

Need a SharePoint List Trick

Posted on 2011-10-14
6
Medium Priority
?
241 Views
Last Modified: 2012-05-12
I have a couple custom lists, lets call them list1 and list2

lets say that list1 is a list of codes that is updated daily from an extyernal source.

code1
code2
code3
code4

list2 is my working list where we enter information, the first value entered in a field called code and I would like to have something kick off when that first field is entered and you mouse out of the field that checks list1 to see if the code exists.  If it doesnt it should come back and say invalid code and not allow the screen to be entered.

can this be done??
0
Comment
Question by:Matt Pinkston
  • 3
  • 3
6 Comments
 
LVL 14

Expert Comment

by:abhitrig
ID: 36971002
Can't you create a lookup in your list2 to the list1 and make it required? That way the users have to choose an existing code.

if you still need to do this, yes you can use javascript to make a call to the list (webservices if using 2007)  by using the client obejct model (if using  2010)
0
 

Author Comment

by:Matt Pinkston
ID: 36972013
list1 has 6,000+ entries
0
 

Author Comment

by:Matt Pinkston
ID: 36976772
Was hoping for a javascript that might work
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 14

Expert Comment

by:abhitrig
ID: 36976889
Look at SPservices on codeplex...its the javascript swiss army knife for SharePoint
0
 

Author Comment

by:Matt Pinkston
ID: 36978860
I don't see anything specifically called SPservices on codeplex, do you mean JQuery?
0
 
LVL 14

Accepted Solution

by:
abhitrig earned 2000 total points
ID: 36979674
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

840 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