Table Layout & Sorting

For the single record shortcode, you can use a rule like this in the custom CSS setting:

.pdb-single dt {
    float: none;
}

You may need to add additional rules to get it looking the way you want.

For sorting the list, it is possible to set up a multi-column sort like that using javascript. If you create a custom template for the list shortcode, you can include the javascript in the template.

Here is a simple jQuery script that should work for this: sorttable.js

• This reply was modified 6 years, 1 month ago by xnau webdesign.

HI

Thanks for your reply. Sorted the table layout but cannot get my head round how to add the javascript; the tutorial is not making any sense for me ?? no idea where the code needs to go!

I’m sorry…I have to leave that to you, I’m not familiar with the details of using the code I gave you a link to, that was only meant as an example of the kind of script you’re looking for.

The Javascript will go in the custom template, but it will be up to you to configure it.

Hi! after a good night sleep I have worked it out (finally!)

(reference to other people wanting this)
I used the plug in Table Sorter by Farhan Noor

Went into plugin editor > participant database > templates > both pdb-list php files, found <table and replaced the default to
<table class=”wp-list-table widefat fixed pages list-container tablesorter {sortlist: [[2,0]]}” id=”myTable”>

and it works! https://www.bitsyboos.co.uk/the-database

Hope this helps others

OK, that’s good, but I suggest you put your custom templates into a safe location because a plugin update will overwrite your changes to the plugin files.

This is explained here: Using Participants Database Custom Templates