[Seek Help] Prepare a form for course registration

Dear all,
I'm a newbie for both joomla and chronoform and I have to prepare a online form for visitor to register a course.

Background:
Have created database storing all the course information as below:
Table name: j9f6_training
Fields:
id, courseid, name, language, date, weekday, time, quota, introduction, location

which which course have a quota for 7, means each course can have max 7 ppl to join.

Expect
Page 1 > course listing with register button included
Page 2 > if quota is not full, show registration form and quota-1 when form submitted
is full, show message and end

Questions
1) can i generate page 1 by chronoform as well?
2) hv no idea how to do for page 2. I only prepare the registraion form (but not sure how to load the quota field by the specific course), the database and data for the course info.
3) am using a responsive template, so if the chronoform is responsive as well?

Understand that there is tons of information and suggestion here, but I feel difficulties as a newbie.
I would be appreciate if anyone can help me for this, or just a link / reference will be helpful.
Thanks a lot.

Hi wlwan,

If your are a newcomer take this one step at a time. Build a couple of forms with the absolute minimum of elements to test how it works,

There was a thread here a month or so ago about course bookings with limited places. It's quite practical, you do a DB read when the form loads to check how many places are left.

The default ChronoForms template is reasonably responsive - there are more options on the Styles tab.

Bob

Thanks Bob for your reply.

Have just checked the past articles and find the thread you mentioned... (link copied here for easy accessing for others...)
http://www.chronoengine.com/forums/posts/f2/t91036/booking-form-that-reduces-seat-availability-on-submission.html?hilit=course+bookings

Actually I still have no idea about what's the next step after installing your action... Luckily I find your website have lots of video and hope I can get an answer from there.

Anyhow, wish me luck and I will report the result whenever it is work or not.
Tons of thanks.

Wing

Hi wlwan,

The first step is probably to build the registration form, get that working and saving data to the database. That will get you familiar with some parts of ChronoForms.

Second step is to build the course selector form using a DB Read action to load the available courses from the database table that you already have.

Third step is to work out how you want to apply the course limit. You can choose to disable full courses in the selector, or to allow them to be selected and then show the user a 'full' message instead of the registration form.

Bob

have try to set up a basic form to test the sending email function, it fails and error message as below:
•Mailer Error: Could not instantiate mail function.

No that sure the reason behind. have tried to use phpmail and smtp with gmail, both fail...

attached: setting info for your checking.

and tried the google smtp as well, fail again

host: smtp.gmail.com
port: 465
security: ssl
username and password: my own account

input all the above @ joomla global configuration > server page
:cry:

Hi wlwan,

Please check with your webhost what the correct mailer settings to use are.

Using Gmail should work OK - but you may need to set the From Email address to the Gmail login email for the mails to be accepted.

Bob