Questions tagged [rsform]
Questions about the popular Form Extension RSForm Pro, by RSJoomla
54
questions
0
votes
0
answers
28
views
RSform: How to skip strings in query output if variables are empty?
I have this Code. I don't know PHP, but I got the result I wanted. Almost. As you can see, the output will include empty URL parameters if none are provided. Some fields will always be filled, others ...
- 9
1
vote
1
answer
408
views
RSForm get value from html and submit as hidden field
I have a website which shows user profiles and their relevant userID is available on the page where my form is (but hidden through CSS).
(The userID is for the profile being viewed and not the user ...
- 2,076
1
vote
0
answers
98
views
Pass PHP Variable To JavaScript In RS Forms
how can I pass this php variable to my JavaScript in RS Forms code behind?
$doc = JFactory::getDocument();
$doc->addStyleSheet("https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap....
- 140
0
votes
1
answer
82
views
Capturing Value From RS Forms Drop Down
Using RSForms and Joomla - how can I capture the selected value of a drop down in the php code behind?
- 140
1
vote
1
answer
58
views
Joomla mysql query - group_contact
I have mysql query:
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
$formId = 21;
$query = "select * from #...
- 83
1
vote
1
answer
54
views
PieChart For RSForm for PlotaLot based on a dropdown field
So I got this Pie Chart to display the Count of Voters vs Position and it's working fine.
SELECT Position,
COUNT(1) AS count
FROM (
SELECT
MAX(IF(FieldName = 'Position', FieldValue, NULL)) ...
- 113
1
vote
1
answer
221
views
Create Plotalot chart from RSForm Pro data using pivot query
I'm trying to extract RSForm Pro form data from the database to create Plotalot charts.
There is a field on the form called "resolved" to which users respond "Yes or No". I would ...
- 13
1
vote
0
answers
69
views
How to add custom attachment validation into form?
I have a form that using RSForm Pro to build and I have an issue where the default validation for the attachment only appear after I click submit. And the problem now is my form is using the Joomla ...
- 23
0
votes
1
answer
95
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 ...
- 43
1
vote
2
answers
181
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
...
- 43
2
votes
1
answer
1k
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->...
- 43
1
vote
1
answer
142
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 ...
- 47
2
votes
1
answer
108
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 ...
- 47
1
vote
1
answer
234
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 ...
- 47
0
votes
0
answers
284
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 ...
2
votes
1
answer
897
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 ...
- 33
0
votes
0
answers
87
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 ...
- 1
0
votes
2
answers
189
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 ...
- 1
0
votes
1
answer
61
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 incorrect Joomla ACL settings for public access to the fields, but I ...
- 77
2
votes
4
answers
215
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:
...
- 41
2
votes
1
answer
120
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 ...
- 4,781
0
votes
1
answer
180
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 ...
- 101
1
vote
1
answer
224
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 ...
- 294
0
votes
2
answers
4k
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 ...
- 294
2
votes
2
answers
333
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 ...
- 265
2
votes
2
answers
286
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 ...
- 265
1
vote
1
answer
118
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 ...
- 265
0
votes
1
answer
112
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-------------------...
0
votes
1
answer
837
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` ...
- 101
1
vote
2
answers
465
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 ...
- 265
2
votes
2
answers
393
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 ...
- 173
0
votes
2
answers
342
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 ...
2
votes
2
answers
425
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 ...
- 108
1
vote
1
answer
228
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 ...
- 31
1
vote
0
answers
686
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 ...
- 31
2
votes
2
answers
578
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.
...
- 217
3
votes
1
answer
553
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 ...
- 83
0
votes
1
answer
757
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: ...
- 83
2
votes
1
answer
2k
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 ...
- 123
0
votes
1
answer
112
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 ...
- 108
0
votes
1
answer
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 ...
- 991
1
vote
0
answers
320
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 ...
- 43
0
votes
2
answers
175
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,...
- 415
2
votes
1
answer
252
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 ...
- 3,593
1
vote
1
answer
240
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 ...
- 408
1
vote
1
answer
714
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 ...
- 19.6k
1
vote
1
answer
896
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 ...
1
vote
1
answer
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,076
2
votes
2
answers
3k
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 ...
- 2,076
2
votes
1
answer
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:...
- 2,076