Hello people,

Let me give a brief introduction: I’m managing a website for our bowling club. We organize about 4 competitions each year. Our members can subscribe to a competition through the website. We have a limit of 12 lanes for each competition. 2 members per lane, so a maximum of 24 subscriptions per competition.

In the past, I used my own PHP script with a form which I included in our Joomla website by using the component Jumi.

I want my subscription forms a lot more secure (no spam) and more professional looking. So i decided to switch to RSForm! Pro. Look great. A lots of nice features ready to go which used to take hours to program. Thanks guys!

My question:
I've read throughout the forums that there is a possibility to program a "dynamic dropdown". I want (as i explained above) a dropdown list, with all the competitions which still have room for an additional subscriber. So when a competition is full, I do not want it to show up in the drop down list.

I've looked throughout the forum, read about multiple possibilities, but none really "suited" my needs.
Can you guys help me?

As I noted: I’m an fresh RSForm user, with (a little) PHP/MySQL experience.

Thanks for your help!

Kind regards,
Leon

The dynamic dropdown form example can be found here:

http://demo.rsjoomla.com/rsformpro/form-exampes/dynamic-drop-down-change-form-example.html

but it's not really suited for your scenario. I would suggest finding a way to implement this example for your case:

www.rsjoomla.com/support/documentation/v...st-from-a-table.html

You would have to change the query to grab only the events that are not full and populate the dropdown.

Good luck!