• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Display total number of submissions in Module

Display total number of submissions in Module 11 years 7 months ago #25083

Hello,
I want show how many people have submitted a form, and show this number in a module.

How can I achieve that?

Thanks,
Michael
The administrator has disabled public write access.

Display total number of submissions in Module 11 years 7 months ago #25084

Hello Michael,

This can be achieved in 2 ways:

1) By using the Custom HTML module (included in Joomla) and a plugin that allows you to execute PHP code to retrieve the number of submissions to your form.

2) By creating an empty form, that contains a PHP "Script called on form display" to handle displaying the submission number, and using the mod_rsform module to display it in a module position.

The required HTML code to retrieve the number of submissions in a form, for the latter case is:
$database = JFactory::getDBO();
 
$database->setQuery("SELECT COUNT(`SubmissionId`) FROM #__rsform_submissions WHERE `FormId`='your_form_id'");
 
$formLayout = "This form contains <strong>".$database->loadResult()."</strong> submissions";

For more information about the mod_rsform module, please refer to the following article:

www.rsjoomla.com/support/documentation/v...module-position.html

... and for the PHP scripting documentation, please refer to the following article:

www.rsjoomla.com/support/documentation/v...602-php-scripts.html
Please remember that my responses aren't considered customer support, to receive customer support please submit a new customer support ticket, and we will gladly assist you.

Best Regards,
Cristian Nicolae.
Last Edit: 11 years 7 months ago by cristian.nicolae.
The administrator has disabled public write access.

Display total number of submissions in Module 9 years 6 months ago #32718

  • gerardo1
  • gerardo1's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
There's a problem with this. If is a paid submision the limit counts all the submisions and not only confirmed ones. ¿Any solutions?
The administrator has disabled public write access.

Display total number of submissions in Module 9 years 6 months ago #32736

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
gerardo1 wrote:
There's a problem with this. If is a paid submision the limit counts all the submisions and not only confirmed ones. ¿Any solutions?

If you take a look at the RSForm!Pro _rsform_submissions database table, you will notice that it incorporates a "confirmed" column that you can include in your SQL.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!