CDML and Value Lists

[CristyCT]

Hi,

I've posted this to some of the other sections of the forum, but to no avail. Perhaps one of you could help me...

I am creating an online registration system for placement testing at my university (nearly 2000+ incoming freshman will use this service). Users will go to an online form to fill out their personal information (name, SSN, phone, etc), and then select an exam date and time from a drop down menu. I have already created the form in CDML.

Here is the problem: When a certain date and time reaches more than 30 registrants, that date and time must automatically remove itself from the drop down list. However, I don't know how to do this using FM and CDML together. Should I create something in JavaScript or Java to facilitate this on the web side? or should I create something exclusively in FM Pro that will do the trick? Either way, the changes must be reflected in real-time on the website.

If any of you have done anything like this or know of some good sources for CDML and web interactivity, please feel free to write me as soon as possible.

Thanks for reading this and regards,

Cristy

[Keith M. Davie]

"When a certain date and time reaches more than 30 registrants, that date and time must automatically remove itself from the drop down list."

An answer was provided to this recently. It involved a calculation field. Sorry I don't recall the thread (or the calculation), but it was on an Internet forum.

Since Social Security numbers are truly "privileged information" and since access to SSN's can provide one with the ability to steal the commercial identity of another, SSN's must be treated with extreme care. There are some security issues with FMI allowing huge holes to exist through which data can be exposed. While your school may well be protected, you may find knowing about the FMI security issues to be useful to you. If so be prepared to spend a little time reading this thread:

http://www.fmforums.com/threads/showthreaded.php?Cat=&Board=UBB21&Number=19032&Search=true&Forum=UBB21&Words=chazboi&Match=Username&Searchpage=0&Limit=25&Old=1year&Main=19032

"If any of you ... know of some good sources for CDML and web interactivity ...".

How much time do you choose to devote to this? If you make the time to do it this forum, the Web Companion and the Using FileMaker Online forums are well worth reading in their entirety. In fact, they are probably the best sources available for "CDML and web interactivity". You will find threads covering things you have not even thought about but which are germane to your solution.

[Garry Claridge]

I think that you could do this with FMP value lists and calculated fields.

Are the exam details in a master file; e.g. exam_name, exam_location, exam_date, exam_time? Is this then related to the students file so that a 'Portal' could be used on a layout of the exam_master file? If so, you could look at using the Count() function in a Calculated field to check if the Portal has 30 rows.

You now will be able to build a Value List on the condition that a course has less than 30 rows.

I hope this gets you headed in the right direction.

All the best.

Garry

[Sharky]

If you found out how, please post this one on http://www.ib2.nl/filemaker/

I am also very interested what the results are.