Dear Support,
I am using Joomla 2.5.8 and Fabrik 3.0.7.
Is it possible to have the RS Forms Pro Submissions Results layout using a List in Fabrik? Refer to link below:
RS Forms Pro - Submission Results Back End
https://docs.google.com/file/d/0B5-dSAllCqTtNktsWEhHcHlpamc/edit?usp=sharing
I have set up a List using a left join but it it not quite working:
left JOIN jml_rsform_submission_values ON jml_rsform_submissions.SubmissionId = jml_rsform_submission_values.SubmissionId
See picture below to see my results
https://docs.google.com/file/d/0B5-dSAllCqTtU1RiOHlCVnpDejA/edit?usp=sharing
The challenging I am having is displaying the FieldName values e.g. rsfp_Product, submit, total etc as columns. All of these values are within FieldName field in the rs_form_submission_values table.
RS Forms Pro Submissions - Table Structure
https://docs.google.com/file/d/0B5-dSAllCqTtWWpfRXpXQ1RTcVE/edit?usp=sharing
RS Forms Pro Submission Values - Table Structure
https://docs.google.com/file/d/0B5-dSAllCqTtWnhQQmQtNlZpYWc/edit?pli=1
Thank you very much for your help and have a great weekend.
I am using Joomla 2.5.8 and Fabrik 3.0.7.
Is it possible to have the RS Forms Pro Submissions Results layout using a List in Fabrik? Refer to link below:
RS Forms Pro - Submission Results Back End
https://docs.google.com/file/d/0B5-dSAllCqTtNktsWEhHcHlpamc/edit?usp=sharing
I have set up a List using a left join but it it not quite working:
left JOIN jml_rsform_submission_values ON jml_rsform_submissions.SubmissionId = jml_rsform_submission_values.SubmissionId
See picture below to see my results
https://docs.google.com/file/d/0B5-dSAllCqTtU1RiOHlCVnpDejA/edit?usp=sharing
The challenging I am having is displaying the FieldName values e.g. rsfp_Product, submit, total etc as columns. All of these values are within FieldName field in the rs_form_submission_values table.
RS Forms Pro Submissions - Table Structure
https://docs.google.com/file/d/0B5-dSAllCqTtWWpfRXpXQ1RTcVE/edit?usp=sharing
RS Forms Pro Submission Values - Table Structure
https://docs.google.com/file/d/0B5-dSAllCqTtWnhQQmQtNlZpYWc/edit?pli=1
Thank you very much for your help and have a great weekend.