RSForms Pro Submission Values in List

[joktanh]

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.

 

[cheesegrits]

I don't think you can display the FieldName values as separate columns, because they aren't columns. The are just values of a column.

I guess if you knew all the possible values of the FieldName column in advance you might be able to build a MySQL view with a rather complex query, but that would be less than optimal.

Or if you chose "merge data" in the Fabrik list join options, you could have a single row for the main table row, with all the FieldNames in one cell in the row, and use some CSS styling to display them in your preferred format.

-- hugh

 

[joktanh]

Thanks for your reply Hugh! I tried the "merge data" option but unfortunately when I edit the row I can only edit first "FieldName" and "FiledValue" value listed. Is there a way to edit all the values within the row? See pictures attached. Thank you very much for your help.

 

[mattsh]

I don't know if you found a solution to this.

If not, I think you should try the mappings plugin for RSForm to save data to a separate db table, see RSForm documentation, http://www.rsjoomla.com/support/doc...submission-info-to-other-database-tables.html

Matt