I have made a form and it works properly. You can find it at this link.
They can choose if they want to order 1 tickets or more upto 20 tickets.
See:


I would like a counter on the site to know how many tickets are sold. In the backend I can see all submissions and I can see for each row the amount of money they've payed (10 EUR per ticket, no other prices/no discount).

Is there a possibilty to write a script of use a plugin that shows the sum of this column? So the total amount of money they have payed? And then divide it to 10 to know the numbers of tickets sold? I would like to put this on the website.

Another solution can be that I will use a script that will stop a user to order more tickets if a maximum is reached.

I can imagine RSEvents has more possibilities than RSFormPRO but that's not yet an option. We might use that software later when some new features are available.

Thanks in advance!

Hello,

You could try counting the number of submissions made with each option, then restrict the submission process after your desired limit per option is reached. Although not a copy paste solution a good starting point can be found here:

www.rsjoomla.com/support/documentation/r...sions-to-a-form.html

Since you will need to check the number of submissions based on the value, the table you should perform the query for is #__rsform_submission_values and not #__rsform_submissions.