Sharepoint - create a class registration form with limited spots

Question

_{Thursday, July 3, 2014 4:01 PM}

Hi

I created a registration form where the user can select from a drop down list of classes that they want to attend:

Name (Text): ________________

email (Text):  _____________

department(Text) ______________

Position (Text) __________

Supervisor(Text) _____________

Training Time (Drop Down List) 

Option 1: 8AM - 9AM

Option 2: 10AM - 11AM

Option 3: 2PM - 3PM

and i want to limit the space available for each training time to be about 12 spots. After that the 12 spots are filled, whoever registers for that time slot will get a message stating that the class is full and register for a different slot.

I have two lists

List 1: participants first(text) and last name(text), email address(text), department(text), position(text), supervisor/manager(text), and training time(lookup to list 2)

List 2: Time of class(Text), #ofSeats (number), FilledSeats(number) , Remaining Seats (calculated field: =#ofSeats-FilledSeats) , SeatsIncrement (calculated: FilledSeats+1)

I have already tried the method from here

http://www.greggalipeau.com/2012/05/20/sharepoint-2010-class-registration-form /

and https://janikvonrotz.ch/2014/04/07/sharepoint-class-registration-form /

but was unsuccessful because i am unable to do the javascript part.

I have also tried to get a workflow going but am unsuccessful.

and I do not know how to code. So far, i've been working strictly with Sharepoint,infopath and sharepoint designer(for workflow)

PLEASE HELP

Thanks 

All replies (1)

_{Friday, July 4, 2014 6:38 AM ✅Answered | 1 vote}

Hello,

>but was unsuccessful because i am unable to do the javascript part.

What is the problem with javascript part?

As per that link You need to to create calendar list instead of custom list (if you have) then add a workflow on calendar list. Later create a site page (webpart page) then first add your calendar list as webpart on page so user can create a request. On the same page you need to add content editor webpart on same page so you can show the message. To add script in content editor webpart please refer this:

http://sympmarc.com/2011/03/29/adding-script-into-a-content-editor-web-part-cewp-in-sharepoint-2010/ 

Since this is jquery so you have to download jquery from (http://code.jquery.com/jquery-1.7.2.min.js).

Refer this for more about jquery: (http://sanssharepoint.blogspot.sg/2012/08/sharepoint-and-jquery.html)

Once you downlaod the jquery then go to your style folder and upload your jquery there and put the URL in jquery ref of your script. DON't forget to approve this query in style library.

Let us know if you have any issue

Hemendra:Yesterday is just a memory,Tomorrow we may never see
Please remember to mark the replies as answers if they help and unmark them if they provide no help