Pulling back a list of submitted forms to the front end

Squiz Matrix Support
1

Hello,


I want to show on the frontend a list of forms that have been submitted in a table in the same way it is presented in the backend (access will be restricted by role).



Backend form submitted log

[attachment=385:Picture_5.jpg]



So what's the best way of doing this? I tried creating an asset listing page and pointed it at the submission logs and all I got was link in the format 'Form Submission #21462' but when clicked on the page just refreshed!



Thanks
Picture_5.jpg (35.6 KB)

2

From memory, Form Submission assets don't get URLs.


If this is the case, the only way to display the information is using an asset listing with a dynamic root node which is set to the asset ID of the form submission (eg. via a GET variable).



Note that also Form Submissions are created with Public User have read access denied, so if you're trying to display form submissions on a public page, you may have some trouble (forms weren't really designed to do this).

3

[quote]From memory, Form Submission assets don't get URLs.


If this is the case, the only way to display the information is using an asset listing with a dynamic root node which is set to the asset ID of the form submission (eg. via a GET variable).



Note that also Form Submissions are created with Public User have read access denied, so if you're trying to display form submissions on a public page, you may have some trouble (forms weren't really designed to do this).[/quote]



Hi Dan,



Thanks for the reply.



So in my Asset Listing page in the 'Dynamic Parameters' section which setting do I use:



Array of specific asset IDs or selection group (specified assets must be children of the static related node)

Replacement Root node for the listing (must be a child of the static root node)



and then I set this to 'GET Variable Name' but what am I adding into the text field?



As for making the submissions read public, I have done this by deleting the red public access and then adding it back in with Granted selected.

4

You might not want either of those. If you just want to list Form Submission assets, you should be able to use their keywords in the "Type Format" bodycopy of the Asset Listing. Try customising the Type Format for Form Submission assets, and in new the bodycopy the list of keywords available should be in the dropdown list.

5

Hi Daniel,

That is working perfectly :D

Thank you.