check value in db and display differently

is there a way to check the form DB and see if "x" number were submitted then display a message rather than the field?

We have "slots" to fill for volunteers. Say position 1 needs 4 volunteers.

So if someone visits the form can it check if there have been 4 submissions to that field then display a message like, "thank you these spots are filled"?

I tried to find an extension that would make this work and couldn't find anything!! Thanks for any help.

Hi cjmicro,

I'd probably do it with Custom Code or an Event Switcher in the form On Load event to check the number of submissions. Then either continue with the main form or show a 'Sorry we're full' up message - you can do that by redirecting to another event.

Bob

so for example, i have a checkbox "positions" with a value "jump judge" and that can have 4 people. i can check the values in "positions" field and count how many have "jump judge" then have it display a message "sorry that position is full"?

i might as well ask now because you know my next question is how do i write the code to check and count values in a field? :-D