I have RSJoomla Forms (RSJF)
Would like to create a front-end form with RSJF.
If I use this and have the data in RSJF can I access and display data as I did accessing SQL data?

Any experience with RSJF would be really helpful

If this is not possible let me know what FORM extension can be used to create a form and collect data where ARI Data Tables can display?

Thank you in advance

We don't have experience with RS Forms extension, but we can try to help if you send SQL dump of RS Forms tables with sample data by email and specify what do you want to see on frontend.

Regards,
ARI Soft

No I do not know where the RSJ form data is located
Certanly I cannot see MySQL tables

What FORM extensions can you recommend to collect data from visitors that ARI-Tables can access can show on the front-end?
Does ARI-Soft have any such extensions?

Thank you

Set "SQL query" parameter to the following value:



Change FormId in "WHERE" clause with ID of your form.

Set "SQL -> Graph transformation -> Enable" to "Yes", "SQL -> Graph transformation -> X axis column" to "FieldName", "SQL -> Graph transformation -> Y axis column" to "SubmissionId", "SQL -> Graph transformation -> Value column" to "FieldValue":



Regards,
ARI Soft

Thank you very much
Its working well with RSJForms
I have emailed you with a question regarding how to limit the display fields giving the site URL and pages
Your support has been simply fantastic (even for a person with limited knowledge in SQL and Joomla)
Kumara

Hello

The ARI Data Tables are working well (with RSJForms) and the page that I have displayed a list of article publications given below
ausframe.org/index.php/publications/aridatatables-rsj-form-data

My issue is that I do not know how to control the order/sequence in which the fields are displayed.
Currently its displayed - RCS, PubMedId, Source, Title, (Authors are not even displayed)
How I want it displayed - Title, Authors, Source, PubMedId, RCS

The SQL query is in the correct order (below), but seems ineffective
SELECT
SubmissionId,
FieldName,
FieldValue
FROM
#__rsform_submission_values
WHERE
FormId = 6
AND
FieldName IN ('PubMedId','Title','Author','Source','RCS')
ORDER BY SubmissionId DESC

How do I display the fields in the order I want? -
Thank you
Kumara