Questions tagged [rsform]
Questions about the popular Form Extension RSForm Pro, by RSJoomla
47
questions
1
vote
2answers
44 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
102 views
How to add pagination in joomla custom php code?
Please help me to add pagination (getLimitBox) to my table result.
I have for example 100 rows in my table and I want to show 10 page.
<?php
$formid=23;
$db = JFactory::getDbo();
$query = $db->...
0
votes
0answers
8 views
How to add hidden field with language code to Rsform?
How can I add a hidden field to a RSForm form with a language code value like en-GB?
If I can receive the language code with the form submission, then I can ensure that my external application sends a ...
0
votes
1answer
29 views
How to conditionally add filters to my query of the rsform_submission_values table?
$FormId=23;
$qustioan1=qka1;
<form method="post" action="#">
<select name="state" onChange="irancitylist(this.value);">
<option ...
0
votes
1answer
33 views
Joomla Contact Form's and some of RS Form's fields aren't editable (disabled)
I've noticed that Joomla Contact Form's and some of RS Form's fields aren't editable (disabled). I think it's probably because of wrong settings of Joomla ACL for a public access to the fields, but I ...
1
vote
1answer
69 views
RSFORM combine 2 submission form results in one Plotalot view
After requesting help from local db-masters with no result, I would like to ask this question here. The output required is this for example:
Shelter ClientID Year Month Fees Amount ...
2
votes
1answer
73 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 ...
1
vote
1answer
125 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 ...
0
votes
0answers
81 views
RSForm filter submissions using submission directory on frontend
I have created a form using RSForm pro and my users can submit their information with this form. One of the form fields named "age". There are three admins in my site. They should see and check users ...
0
votes
2answers
2k views
How to add line break into placeholder text area?
How can I add a line break into the placeholder text area of the RSform?
Tried without success:
- \n
- <br/>
-
A sample of the form with the non working text area can be found here ...
0
votes
2answers
62 views
About Rsform submission
I have a claim form built with RSform used in local network.
The users who write the complaints are the users of the joomla site(for exemple user1 user2 user3).
The form contains : the details of the ...
2
votes
1answer
270 views
Get the list of article and related specific custom field value
I need to compose a list for a RSFormPro form field which contains options that display article titles and their respective date from a custom field.
In front something like this :
Select your ...
2
votes
2answers
343 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
2answers
240 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
4answers
119 views
How to use cookies to populate RSForm fields without notices/warnings?
I have used this code to save the RSForm data in a cookie and if the user tries to fill in the same form again, the previously entered data is loaded as default values:
Script called on form display:
...
0
votes
0answers
36 views
Add link to another form's submission view
I have two separate forms - a user form and an incident form. In the user submission view, I need to generate a link to all incidents that the user may have. These users may have more than one ...
2
votes
1answer
74 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 ...
0
votes
1answer
99 views
How to update Community Builder fields of user with RSFORM
I have Joomla 3.8.11 and RSFORM 2.0.14.
I want to update the Community Builder fields of the logged-in user.
The main fields that I am trying to update are via some checkboxes:
The checkbox field ...
0
votes
2answers
151 views
How to write a condition to check if a number is a multiple of 30?
How to set up an array so that instead of maximum - an array on multiples of 30 is shown
i.e $max = 30, 60, 90, 120, 150......and so on
If array $max matches on multiple of 30, 60, 90, 120, 150, 180,...
0
votes
2answers
230 views
Joomla + RSform get from database
I want to add number of confirmed forms from users. Every time they use the form it will show their order number - different for every logged in user.
I've adden hidden field "counter" and in Script ...
1
vote
1answer
76 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 ...
0
votes
1answer
801 views
RSForm Pro Search form
I have created a search form with RSForm Pro, unfortunately it isn't working.
The concept is to do a TAG Search all the Fields of the Form (Select and Radio) have values which are part of a URL which ...
2
votes
2answers
235 views
How to query certain rows from a table based on other associated rows in the same table?
I'm trying to query my jos_rsform_submission_values table for FieldValue data in rows with a FieldName of Container# which shares a SubmissionId with another row where the FieldValue is "Pending" and ...
0
votes
1answer
101 views
implode - URL doubling - image display error
Trying to display the avatar(image) from a folder already stored using a form.
Error: image not displayed. I found the URL doubled in the inspect element:
----------inspect element-------------------...
3
votes
1answer
504 views
Get date value with jinput
In my form I have selecting date with datetimepicker which i'm using only date picker.
I need to get the selected date value to do some calculation in php through ajax.
Here is my code but the ...
2
votes
2answers
333 views
Display image in RSFORM after passing it through URL
So far i have been able to pass a K2 image into both a textbox and a hidden field of RSFORM - which is great! But i would like the user to view the item (image) they are ordering while filling the ...
1
vote
2answers
298 views
Allow front-end editing of user forms?
Good day,
I was wondering if there is a component available which will allow me to do the following:
A user completes a form, submits it and receives an email upon submission. If they want to edit ...
1
vote
1answer
82 views
Don't add empty fields to database after submission?
Is there any PHP code which will allow me to NOT submit any empty fields to the database. I have a form with about 200 fields, and a lot of the times many of them are empty.
How can I not add the ...
0
votes
1answer
535 views
Php-sql result in joomla displayed in question marks
I have a simple sql query, in a joomla php server, rs forms pro. The result contains Greek characters. However, the result is displayed in question marks.
$sql = "SELECT `FieldValue` FROM `table` ...
2
votes
2answers
224 views
How to add a payment reference to RSForms!Pro?
Okay, so I have this Joomla website that I maintain for someone. It has the components RSForm! Pro and RSEvents!Pro installed. Every once in a while, we have an event, and the signup for it will be ...
1
vote
1answer
187 views
RSform- scroll screen up when posting from one form to another
I have a form built with RSForm pro on my website home page and when user submit that, it redirects them to a second form (booking form) and auto populate the fields selected on first form. Im ...
1
vote
0answers
433 views
RSForms - Change the items of a radio group based on a selection of a drop down
I need to change the items of a radio group based on a drop-down selection in RSForm pro.
Right now I'm using the Conditional Fields feature to show different radio group field and that caused too ...
1
vote
1answer
860 views
Get K2 itemID in category listing
I have a form created with RSForm Pro and I am loading this form in some K2 items with the RSForm Content Plugin.
I want to get the title of k2 item that form submitted from it.
in k2 item view I ...
0
votes
1answer
107 views
Prefill Phoca Gallery image into RSForm file upload or hidden field [closed]
I wish to know how to pre-fill Phoca gallery image to RSform file upload or hidden field so that if a user is viewing images created with Phoca gallery he/she can select an option to order that ...
1
vote
0answers
281 views
Dynamically add new set of textboxes
Is there a way that RSForms can insert dynamic boxes when a trigger is clicked?
For example, if someone has three children to sign up for a class and there is only one text box for one child's ...
0
votes
1answer
686 views
Filtering dropdown form with jquery.ajax
i have two dropdown getting value from database:
Table_Buildings
|id|---|building_name|
Table_Floors
|id|---|Floor_name|---|building(Foreign key to table_Buildings)|
and in my form
Dropdown: ...
2
votes
1answer
1k views
Submit to RSform! pro from anywhere using jQuery ajax
I'm in the process of making an administration app for Joomla RSform! pro. The app is hosted as an article so it is on the same domain as Joomla itself.
I need to move or copy a submission from one ...
1
vote
1answer
2k views
RSForm check if email is in database before submitting form
I have an RSForm which has the following fields:
Full Name
Email Address
I only want to capture new data, how can I use the $_POST script to check if the email address submitted is already in the ...
1
vote
1answer
542 views
How to enable email cloaking for my email address that is shown in rsform?
I have a contact us form built using the RSForm Pro component.
At the top of the form I have a brief intro-text, using the RSForm freetext field, where I have my email address for those that don't ...
0
votes
1answer
1k views
How to input mask in RsForms?
How to create a input Mask with jQuery in RSForms?
I have try all documentation from RSJoomla without success:
https://www.rsjoomla.com/support/documentation/rsform-pro/form-fields/textbox.html
My ...
1
vote
1answer
1k views
Submit external data to RSForms MySQL table
I have a form on a non-Joomla website which has the following fields:
Full Name
Email Address
Work In A Pub (Tick box)
Supplier (Tick box)
Over 18
I have the following code to send from the external ...
2
votes
1answer
215 views
RS Form delete with message
I am using RS Forms Pro and I am able to view a list of submitted forms via a menu link. I am able to view, edit and download the forms from this page. I have since added delete functionality which ...
1
vote
1answer
230 views
RSForm!Pro - Google Analytics Plugin causes duplicate GA code
If using the plug-in RSForm!Pro - Google Analytics Plugin to put in GA code on your forms, along with using Asynchronous Google Analytics plug-in, on those pages that has a form, there is a duplicate ...
2
votes
2answers
454 views
Setting a cookie after an RSForm has been completed
I have a module (RSForm Pro) which shows on my site on page load.
I want all new site visitors to be shown this module, but I don't want it shown if details have been added to the form or the form ...
2
votes
1answer
1k views
RSForm!Pro Update form class if the error message shown
What's the best way to update the form class in RSForm!Pro if the error message is shown?
Could this be done using jQuery or a PHP script?
The code when the error is shown is:
<form action="http:...
0
votes
2answers
1k views
How to pre-fill RsForm with URL parameters
I followed this guide on how to pass a parameter through the URL in RsForm,
and with it I tried to define default value of one box. Even though I followed that tutorial, my browser accepts the url but ...
2
votes
1answer
1k views
RSForms Pro changing the class of Radio Group label
I am setting up an RSForm! Pro form using Radio buttons, but I want to hide the radio buttons input and use the label for the selection, the HTML for the question is:
<div class="rsform-block ...