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
-
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, 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.
- The topic ‘creating dynamic lists’ is closed to new replies.
