Display Submissions on a Page

Hello @mpbaweb,

It is a specific behavior to your project, and would be required customize your copy of the plugin to display the list of submissions in the way you want.

As you need a custom coding service, please, contact me through my private website:

https://cff.dwbooster.com/customization

Best regards.

Thank you for your speedy reply.

I would have thought this would be a major benefit to all users, to be able to display the submissions on a page. For example, the similarly priced VFB Forms plugin does this very well even in the free version but their PayPal integration is rubbish, so we have eliminated VFB Forms from our shortlist.

I was hoping this might be included in a future update. Even if it could display all the fields via a shortcode it is better than not at all. At a very basic level, would this not involve querying the submissions table in the database and making specific fields available by a shortcode parameter?

I think customisation would be beyond our budget. We are OK with paying for the Pro and even the developer version, but at 25/hour I think customisation is not practical for us.

Hello @mpbaweb,

Thank you very much for your suggestion. Yes, I think too that this feature can be beneficial for many users. I’ve included the feature in list of future updates, however, I cannot tell you exactly when will be released.

Best regards.

Thank you

Super support

4 stars from me. (5 when we get this feature ??)

Unbelievable!! 3 days later and the developers add this feature. 5 stars!! Blown away by the support. Buying the Pro version today

I tried to test this this in the demo area on :
demos.net-factor.com/calculated-fields-form

But the test page just displays the shortcode rather than the results

Screenshot:
https://www.mpba.org.uk/wp-content/uploads/2018/03/formdemo.jpg

Maybe the change has not been uploaded to the demo server?

Hello @mpbaweb,

I’m sorry, I’m working yet in included the latest features into the demo website.

Best regards.

Hello @mpbaweb,

I’ve included the latest features in the online demo.

Best regards.

Ok,
So I just paid for the Pro version and installed it. The results display partially works, but the results are not displayed as a table. It needs to look like this

Name Team Entry Date
ABC DEF 06/03/2018
XYZ PQR 06/03/2018
QWQ AAA 05/03/2018

Hello @mpbaweb,

The [CP_CALCULATED_FIELDS_RESULT_LIST] shortcode is very similar to the shortcode for summary [CP_CALCULATED_FIELDS_RESULT], with only two particularities, the “formid” attribute with the form’s id is required, and this shortcode would be replaced with list of summaries.

I’ll try to describe the process with an example.

Assuming the form with id 1 has many fields, but you want to display some of fields with a table structure (the names of fields used in the example are hypothetical), so you can insert the shortcode with a structure similar to the following one:

[CP_CALCULATED_FIELDS_RESULT_LIST formid="1"]
<table><tr><td><%fieldname1_value%></td><td><%fieldname2_value%></td><td><%fieldname3_value%></td></tr><tr><td><%fieldname1_value%></td><td><%fieldname2_value%></td><td><%fieldname3_value%></td></tr><tr><td><%fieldname4_value%></td><td><%fieldname5_value%></td><td><%fieldname6_value%></td></tr></table>
[/CP_CALCULATED_FIELDS_RESULT_LIST]

Additional details about the special tags you can use in the thank you pages and notification emails in the following link:

https://cff.dwbooster.com/documentation#special-tags

Best regards.

Ok. I tried that, but that structure does not appear to respect normal html table formatting. It creates a bit of a mess. See my test page:
https://www.mpba.org.uk/test-results/

Also, I am unable to figure out how to display the submission date

For comparison purposes, this is what VFB does:
https://www.mpba.org.uk/ndc-r1-20180325/

• This reply was modified 7 years ago by mpbaweb.

Hello @mpbaweb,

The plugin you are referring is forcing you to a structure in the results, and of course, it give you other facilities, but we’ve preferred (at least in this version) don’t force to the users to a structure in the results and let they take their own decisions about how to display the results.

For example, if you insert the shortcode for the list as follows:

<table>[CP_CALCULATED_FIELDS_RESULT_LIST formid="1"]<tr><td><%fieldname13_value%></td><td><%fieldname16_value%></td><td><%fieldname18_value%></td></tr>[/CP_CALCULATED_FIELDS_RESULT_LIST]</table>

The results would be formatted much better.

Best regards.

Not really. There is no header row for the fieldnames. If you try to include it in the table, it repeats the header for each submission. If you insert another table to hard-code the headings, then it is mis-aligned. And I still cannot figure out how to display the submission date.

Example of misalignment and repeating header:
https://www.mpba.org.uk/test-results/

The previous example of what the other plugin does was simply to give a visual presentation of the ideal way this could be done. I don’t expect all those features, and we rejected that plugin because of its crazy PayPal implementation. But I would expect the submissions display to show the field headings and for these to be aligned with the submission values. And I need the submission date in the list.

I don’t want to sound ungrateful. I am very impressed with the speed you have addressed this issue.

• This reply was modified 7 years ago by mpbaweb.
• This reply was modified 7 years ago by mpbaweb.

Hello @mpbaweb,

In this case, you simply should insert the table headers before the shortcode, as follows:

<table><tr><td><strong>First Name</strong></td><td><strong>Last Name</strong></td><td><strong>Class</strong></td></tr>[CP_CALCULATED_FIELDS_RESULT_LIST formid="1"]<tr><td><%fieldname13_value%></td><td><%fieldname16_value%></td><td><%fieldname18_value%></td></tr>[/CP_CALCULATED_FIELDS_RESULT_LIST]</table>

Best regards.

Excellent. That’s fixed the alignment.

Now just need to get the submission date/time to display.