delete value list values using scripts. Possible?

[CristyCT]

Hi All,

I am creating an online registration form using FMPro as the backend database. Users are asked to select a date and time from a drop down menu (whose values come directly from a value list within the FMPro database). Whenever a given date and time has reached thirty registrations, that date and time should be removed from the value list, signifying that it is full and no more registrations can be accepted. Therefore, when another user returns to the website, he/she will not see the dates and times that are full.

My question is this: have any of you ever wrote a script to facilitate this kind of action? If so, please feel free to respond. I do have a programming background (VB, Java, C++), so feel free to use programming lingo if need be.

Thanks for reading this. Regards,

Cristy

[Kundinger]

Hi Cristy,

It sounds like your doing some kind of class registration system. If this is the case, here is an idea. You could use a 'counter' field that keeps a running count of registrations. When it reaches 30, you could have FileMaker generate a "Sorry - Class Full" page back to the user.

Another idea. Create a 'calculated' value list that looks at the 'counter' field to see if is equlas 30. If the 'counter' field equals 30, then use ("") as the value list item.

Hope this helps...

Bob Kundinger

[CristyCT]

Hi Bob,

Thanks for your reply. You've given me some good ideas, but I have a few questions if you don't mind.

How would you go about creating a calculated value list? and where should/could I include the counter field? Is it possible to associate a counter with each item in the value list, perhaps with a conditional relationship of some sort?

Thanks for any insight,

Cristy

[Kundinger]

Hi Cristy,

It is easier to send you a sample file instead of trying to explain it.

E-mail directly at < [email protected] > and I will send you a sample file.

Thanx,

Bob Kundinger