Questions tagged [rsform]

Questions about the popular Form Extension RSForm Pro, by RSJoomla

Filter by
Sorted by
Tagged with
1 vote
1 answer
26 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 #...
user avatar
  • 73
1 vote
1 answer
29 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)) ...
user avatar
0 votes
0 answers
29 views

Capture multiple images using camera in file upload field in RSForm Pro

I want to capture multiple images using camera in file upload field in RSForm Pro. Currently, it won't allow me to capture multiple images in the single field. Please see the file upload field, in ...
user avatar
1 vote
1 answer
96 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 ...
user avatar
  • 13
1 vote
0 answers
35 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 ...
user avatar
  • 23
0 votes
1 answer
49 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 ...
user avatar
  • 43
1 vote
2 answers
88 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 ...
user avatar
  • 43
2 votes
1 answer
352 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->...
user avatar
  • 43
1 vote
1 answer
108 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 ...
user avatar
  • 47
2 votes
1 answer
90 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 ...
user avatar
  • 47
1 vote
1 answer
182 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 ...
user avatar
  • 47
0 votes
0 answers
149 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 ...
user avatar
2 votes
1 answer
551 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 ...
user avatar
  • 33
0 votes
0 answers
53 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 ...
user avatar
  • 1
0 votes
2 answers
79 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 ...
user avatar
0 votes
1 answer
51 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 ...
user avatar
2 votes
4 answers
155 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: ...
user avatar
  • 41
2 votes
1 answer
103 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 ...
user avatar
  • 4,388
0 votes
1 answer
144 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 ...
user avatar
  • 101
1 vote
1 answer
123 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 ...
user avatar
  • 294
0 votes
2 answers
3k 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/> - &#10; A sample of the form with the non working text area can be found here ...
user avatar
  • 294
2 votes
2 answers
277 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 ...
user avatar
  • 155
2 votes
2 answers
269 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 ...
user avatar
  • 155
1 vote
1 answer
99 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 ...
user avatar
  • 155
0 votes
1 answer
104 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-------------------...
user avatar
0 votes
1 answer
742 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` ...
user avatar
  • 101
1 vote
2 answers
385 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 ...
user avatar
  • 155
2 votes
2 answers
294 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 ...
user avatar
  • 173
0 votes
2 answers
279 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 ...
user avatar
2 votes
2 answers
379 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 ...
user avatar
  • 108
1 vote
1 answer
208 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 ...
user avatar
  • 31
1 vote
0 answers
542 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 ...
user avatar
  • 31
2 votes
2 answers
438 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. ...
user avatar
3 votes
1 answer
536 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 ...
user avatar
  • 83
0 votes
1 answer
717 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: ...
user avatar
  • 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 ...
user avatar
0 votes
1 answer
109 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 ...
user avatar
  • 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 ...
user avatar
  • 991
1 vote
0 answers
294 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 ...
user avatar
0 votes
2 answers
165 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,...
user avatar
  • 375
2 votes
1 answer
228 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 ...
user avatar
  • 3,491
1 vote
1 answer
237 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 ...
user avatar
1 vote
1 answer
616 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 ...
user avatar
  • 19.5k
1 vote
1 answer
885 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 ...
user avatar
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 ...
user avatar
  • 1,992
1 vote
1 answer
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 ...
user avatar
  • 1,992
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:...
user avatar
  • 1,992
2 votes
2 answers
484 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 ...
user avatar
  • 1,992
0 votes
2 answers
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 ...
user avatar
  • 19
2 votes
1 answer
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 ...
user avatar
  • 1,992