Title: creating dynamic lists
Last modified: October 21, 2016

---

# creating dynamic lists

 *  [butterfly99](https://wordpress.org/support/users/butterfly99/)
 * (@butterfly99)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/creating-dynamic-lists/)
 * Hi there,
 * Great plugin with lots of potential!
    I have read a lot about the plugin and 
   traced this forum but couldn’t find an answer to my question or overlooked it
   😉
 * I plan to use this interface with the possibilities to link MySQL to Access. 
   In this way I can make complex administrator applications (with a local copy 
   of Access) with the ability to share the information on the web with other people
   through WordPress.
 * What I miss is a way to get the items for a dropdown menu out of **another **
   table. e.g. Participants must be able to choose a (slowly) varying number of 
   courses to pick from. The table with possible courses is updated through Access.
 * On the other hand these courses should be stored (with some additional info like
   date, certificate) and listed when a participant visits his personal page.
 * I hope I made myself clear.
 * Regards,
    Paul

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/creating-dynamic-lists/#post-8343301)
 * OK, this is fairly advanced stuff, but it sounds like you’re ready for that. 
   I don’t offer support for using the API, it’s expected you know your way around
   the code enough to get the job done without much help.
 * In the [Participants Database API](https://xnau.com/work/wordpress-plugins/participants-database/participants-database-documentation/participants-database-api),
   you’ll find an action named ‘pdb-before_display_form_input’ which provides you
   with the PDb_Field_Item object just before it is used to show the form element.
   You can alter the object at that point, so for instance, with a dropdown, the
   options will be held in the “values” property of the object. You can insert your
   own list of option title/values and they will be displayed as the dropdown options
   when it displays. That takes care of question one.
 * The second item has to take place after the update is submitted so that you can
   take a look at what selection was made, then insert the appropriate extra information
   into the db. You should use the ‘pdb-after_submit_update’ action for that, it
   provides the newly saved data, which you can use to locate and save your additional
   information directly to the Participants Database table.
    -  This reply was modified 9 years, 7 months ago by [Roland Barker](https://wordpress.org/support/users/xnau/).
      Reason: added the API link
 *  Thread Starter [butterfly99](https://wordpress.org/support/users/butterfly99/)
 * (@butterfly99)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/creating-dynamic-lists/#post-8343535)
 * Thank you!
    I wasn’t aware of the API yet. I will look into it.
 * Paul

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘creating dynamic lists’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [butterfly99](https://wordpress.org/support/users/butterfly99/)
 * Last activity: [9 years, 7 months ago](https://wordpress.org/support/topic/creating-dynamic-lists/#post-8343535)
 * Status: not resolved