• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

RSForms Pro Submission Values in List

joktanh

New Member
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.
 

Attachments

  • rsform_fabrik.png
    rsform_fabrik.png
    101.8 KB · Views: 876
  • rsform_results.png
    rsform_results.png
    79.9 KB · Views: 769
  • rs_form_submissions.png
    rs_form_submissions.png
    165.3 KB · Views: 715
  • rs_form_submission_values.png
    rs_form_submission_values.png
    231.7 KB · Views: 875
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
 
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.
 

Attachments

  • fabrik-merge-data.png
    fabrik-merge-data.png
    42.6 KB · Views: 648
  • edit-merge-rows.png
    edit-merge-rows.png
    31.9 KB · Views: 626
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top