• 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: Show total combined submissions from forms

Show total combined submissions from forms 11 years 5 months ago #25688

Hi

I have 3 forms and I want to have a module block that shows me the total combined submissions.

Any ideas how to do?

Thanks
Last Edit: 11 years 5 months ago by slewis1972.
The administrator has disabled public write access.

Show total combined submissions from forms 11 years 5 months ago #25697

I found this code:

$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";

If I place it in a custom hmtl form. I have installed sourcerer as that allows me to run code. I am using the above with also a echo command so make sure I get output.

I cannot get anything to output, I have changed "your_form_id" to the relevant form to atleast get totals from 1 form but no joy.

Any ideas?
The administrator has disabled public write access.

Show total combined submissions from forms 11 years 5 months ago #25825

Any ideas of has anyone a different script that will output what I need?

Thanks in advance.
The administrator has disabled public write access.

Show total combined submissions from forms 11 years 4 months ago #25896

Ok, resolved it after a few posts on a sql forum. This works for me:

$database = JFactory::getDBO();

$database->setQuery("SELECT COUNT(`SubmissionId`) FROM #__rsform_submissions WHERE FormId in ('8', '4', '3') ");

echo "So far we have <strong>".$database->loadResult()."</strong> submissions"
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!