Posted on Tuesday, September 09, 2008
Our original 'Code picker' that I've released a while ago has been adapted a bit. It's now possible to also choose the column that will be used for content publishing whereas the first version expected a hard coded 'Description' column.
For example: Assume we wish to let content editors choose from a list of available countries. Instead of using the standard dropdown list and entering the values manually, we'll choose from a list of countries that are available in the database.
First, create a new table in the database 'Countries', holding two columns 'Id' and 'Description'. Secondly, create a new datatype called 'Country picker' and set its render control to 'Code picker' (Choose from the dropdown). Hit 'Save' to enter the configuration options. From the available tables, choose the 'Countries' table. Once table choosen, the system will look up all columns for that table. Choose the table that will hold the value that is published on 'Save and Publish' of any content that will be created based on this datatype.
At this point, you'll only need to drop a property of the newly created datatype 'Country picker' onto any of your existing or new document types and you're all set.
Currently, this datatype only supports MSSql. Still have to look into things needed to support MySql/VistaDb.
Any suggestions or comments are much appreciated. Please report bugs on the forum or in the comment form.
Best of all, the 'Live editing' feature supports this new datatype. No strings attached! It has been tested on the latest build (Change set 39462)
Download the package here.
Leave a comment