Questions tagged [rsform]

Questions about the popular Form Extension RSForm Pro, by RSJoomla

Filter by
Sorted by
Tagged with
1
vote
2answers
75 views

How to count aggregate data from RSForm submission values with Joomla's query building methods?

user SubmissionId FormId FieldName FieldValue bob 2 16 state mystate1 bob 2 16 qda myqad1 bob 2 16 city mycity1 rob 3 16 state mystate2 rob 3 16 qda myqad1 rob 3 16 city mycity1 jac 4 16 state ...
1
vote
1answer
175 views

Charts/Graphs for RSFORM using mysql for VChart and/or PlotaLot

I am working for a homeless organisation in Capetown. We are using RSForms to register our clients (about 3500 per year). We have a sizable database, but it's very hard to create a dashboard. We are ...
2
votes
2answers
264 views

How to refactor two select queries on RSForm submission data?

I was wondering if anyone could help me JOIN multiple queries into one query. Currently, these 2 blocks of code retrieve information from the DB. I am using the "Sourcerer" plugin to add custom PHP ...
2
votes
1answer
86 views

PlotALOT RSForm Query showing only one result

After being helped very well by Stack community and learning a bit I created a query to show the sum of payments per client. A client can pay multiple times. I would like to know the sum of payments ...
2
votes
1answer
98 views

How to display zero values in the legend of PlotALot graph based on RSForm Pro results?

In the backend, I am compiling some survey results generated from RSForm Pro and I want to display the statistics graphically using a PlotALot pie chart. My form has 4 possible values for this ...
2
votes
2answers
412 views

How to retrieve RSForm submission data grouped by SubmissionId?

I have a table with 3 columns: SubmissionId, FieldName and FieldValue. 1) SubmissionId keeps ID submission. 2) FieldName stores field name of a form. 3) FieldValue stores field value of form field. ...
1
vote
1answer
110 views

RSform with multipage form is not jumping to the top of the form

If I create a new multi-page form in RSform the page switching is behaving non user centric. Means if I click on "Next" in the form the form is, to staying at the bottom of the page instead of jumping ...