Remove checkbox from top level category when 'get options for database'

5 posts by 2 authors in: Forums > CMS Builder
Last Post: May 16, 2014   (RSS)

By pixelMIGHT(Josh) - April 17, 2014

I have one section that creates a categories menu that allows a user to generate tags and create a category list. This menu is then brought into a section through 'Get options from database (advanced)' and the user checks-off appropriate tags. Is there a way, in the CMS editor, to remove the check box from the top level category and make it bold. Basically, creating a category menu within the CMS. There is not need to check the top level options and it looks confusing to a user.

Any suggestions?

Thank you,


By Chris - April 21, 2014

Hi Josh,

Can you post the query you've set forĀ 'Get options from database (advanced)' and a screenshot showing the offending checkbox?

All the best,

By pixelMIGHT(Josh) - April 23, 2014

Hi Chris,

Thanks for getting back to me.

Basically, what I would like to do is, in the CMS, have imported category menus arrange so they show the category levels in a logical manner as opposed to one indiscriminate checklist as shown in the attachment. The menu is limited to 2 level, so there is only one level of multiple category headings and an then multiple list items, in a sense. (Note: I am referring to the functionality in the CMS, not on the webpage.)

What I'd, ideally, like to happen is that the 1st level, or heading, show in bold - or - the 2nd level, or list items, become indented. This way, there is a clear, logical distinction in the CMS as to what is a heading or list item and easy for the client to understand the list.

I'm not sure if there is a simple way that I am overlooking or if it is a simple tweak or not. Either way, it's not that big of a deal, but I think it would be a little more clear for the client.

A screen shot of the CMS and webpage is attached. I've also attached a shot of the screen editor.




cms.jpg 93K

webpage.jpg 75K

cms_editsection.jpg 235K

By Chris - April 29, 2014

Hi Josh,

It's not possible to make the fields bold without developing a custom plugin, but what you can do is use a custom Mysql query to add a hyphen and a space (for example) before the labels of checkbox items with a depth > 0 (top-level categories have a depth of 0).

List Options:

Get options from MySQL query (advanced)

SELECT `name`, CONCAT(IF(`depth`, '- ', ''), `name`)
FROM `<?php echo $TABLE_PREFIX ?>portfolio_tags`

(Or see the attached screenshot)

I hope this helps. If you still need bold items, we can build a custom plugin for you through our paid consulting service -- please let me know if that's something you're interested in.

All the best,

portfolio_tags.png 14K