Add additional option to custom CMS dropdown

Hey there - just to confirm, you can't just add another text field or something similar after this dropdown?

Hmm, okay. How do you want it to look on the CMS editing screen?

The option should be the last option in the dropdown!

Thanks - nmsinc

Okay, this is a bit of a hack, but it might work.

Add a type to your types section called Other, then use the code below:

<?php
$where = "";
$where = "WHERE (company = '".$CURRENT_USER['member']."' AND discontinue = '0') OR title = 'Other'";
?>
SELECT num, title
FROM `<?php
echo $TABLE_PREFIX ?>types`
<?php echo $where; ?>
ORDER BY dragSortOrder, title 

This will get it into the dropdown regardless of the selection, and it assumes that you have a drag sort order on the types section. The ordering may still not work though, you might have to play around with it.

Great hack idea, however; if a choice is made of the current dropdown it saves the record number which is correct. The next option that I need to add to the dropdown is "Other" and I want to capture the text and not a record number when this option choice is made. Do you have any other ideas?

The reason I need it this way is that the Plugin "showHideDependentFields" cannot use record numbers and I want the "other" selection to open/show another field!

Thanks - nmsinc

Okay, if I understand this right - you need the "Other" selection in the dropdown to reveal a text field in the record?

You may be able to do a show/hide based on the title instead.

You have the idea right, now how can I add the additional text option to the dropdown and capture the Text when this choice is made while keeping the other options as record number?

Thanks - nmsinc

I'm afraid it's not possible. The closest you'll get is to allow a text field to be revealed on selection of the "Other" option in the dropdown, and then have the text field store the text value. You can't copy the text from that field into the dropdown.