Display All Entries in a Table

Knowledge BaseForm EntriesList Entries → Display All Entries in a Table

You may easily display all entries from a form in a table by using the shortcode described below. The presentation of data is not customizable in this shortcode. If you need more control, you can create a custom display.

Usage

Insert the following shortcode in a page, post, or anywhere shortcodes are accepted.

[formresults id=x]

‘x’ = ID of the form you want to show entries for

Parameters

Required

  • id – ID of the form you would like to show entries for

Optional

  • cols – Limit number of columns shown. If not specified, this defaults to 99. Example: [formresults id=x cols=4]
  • fields – Select specific fields to show with a comma separated list of field IDs or keys of the fields to display. Example: [formresults id=x fields="25,26,27"]
  • google – Use Google tables. This will allow you to paginate and automatically sort your table. Example: [formresults id=x google=1]
    • pagesize – Change the page size if using Google tables. Defaults to 20. Ex. page_size=10
    • sort – Turn off the Google table sorting. Defaults to on. Turn it off with sort=0
  • style – Turn Formidable styling on or off. By default, Formidable styling is loaded. Disable styling with style=0. Example: [formresults id=x style=0]
  • no_entries – The message if there are no entries to display. If not specified, this defaults to “No Entries Found”. Example: [formresults id=x no_entries="No Entries"]
  • clickable – Make the email addresses and URLs into clickable links with clickable=1. Example: [formresults id=x clickable=1]
  • user_id – Show entries for a specific user with any user ID, user name, or “current”. Example: [formresults id=x user_id="current"]
  • edit_link – Include a column with a link to edit the entries. Example: [formresults id=x edit_link="Edit"]
  • page_id – If you include an edit link, add the ID of the page that your form is on, if it’s not shown on the same page as your table. Example: [formresults id=x page_id=5]

PHP Alternative

echo FrmProEntriesController::get_form_results(array('id' => x));

‘x’ = ID of the form you want to show entries for

To see an example of the default output for this shortcode, click here. For complete customization of the way the data is displayed, use a Custom Display.