advanced lists

I have had to do this several times for basically the same reason but cannot find an example in my own code.

Here is where I got the solution when I needed it

http://www.interactivetools.com/forum/forum-posts.php?postNum=2233847#post2233847

You will just need to concatenate the city and address or whatever to suit your needs.

Thanks Ron. That looks useful. It must be time to learn some MySQL.

I don't know enough to understand how to remove the depth check or why CONCAT is on the same line. If anyone can help with details while i try to learn more, I'd appreciate it.

• It's a simple table named "locations". All should be included.
• I'd like to display the "city" and "address" fields for each checkbox

Here is another question. I will be duplicating this for two different editors. When pressing "create" to create a new record in the "locations2" table editor, the admin should see the checkboxes / locations all selected already as default. More often than not, an admin will only uncheck one or two in locations2, then save.

I don't see where i can make checkboxes pre-selected. The only thing i can think of is making the checked value mean "NO" as opposed to it usually meaning "YES". However, the above table "locations" would mostly be unchecked by default. Setting the checkboxes up to mean the opposite when checked would be very confusing when dealing with identical looking editors for the same locations. How can I make checkboxes pre-selected in one table or not selected in another when creating new records in an editor?

thanks! 

I'm sorry ... too much assumption on my part.  I was in your same shoes when I first purchased CMSB and knew NOTHING about PHP MySQL or web development in general.  I learned all I know from this forum and online documentation.

First, you need to change the location lookup field List Options to Get Options fro MySQL query (advanced)  Then enter the following in the query. (I am assuming that the table and field names match your database)

SELECT num, CONCAT(name, ' - ',address)
  FROM `<?php echo $TABLE_PREFIX ?>locations`

This will concatenate the name, a spaced hyphen and the address in the lookup dropdown list.  I attached a screenshot.

As for default check boxes ... very simple .. set default to checked.  See attached screenshot.

Hope this helps!

Embarrassingly, I've been around a while but don't stray from routine usage much.

For the check boxes, I'm using them as you use a dropdown in your screenshot, in the advanced list options (multi value). Unfortunately, the default checked option doesn't appear to be there. 

OK, if I understand the first part of your question, it should be solved with the concatenation of the address to the city name in order to distinguish multiple locations for the same city, but without a better understanding of what you are trying to set the defaults to, I cannot offer a solution.  I guess I am not understanding why there would be a default on creation of a new record to a list of locations within that record. 

Actually, i guess i answered my own question. Using a multi selection dropdown for 100 locations, pre-selected, would be ridiculous.  I should go with the reverse and make "selected = opt out" since its only a few that would opt out.

...unless someone knows a better way, plus I'm curious if you can pre-select things in this way (multi lists, pre-checked pulled from another table).

I'm doubting now that it's possible in CMSB. I mean, next would be wanting to pre-select only certain locations instead of all of them. i don't see that you could do that.

Ron, thanks so much for the MySQL. It works great. I look forward to exploring more. :) I learned very little, years ago, with the command line. Hated it.

How would I show the state if that's in another editor as an advanced list (another table)?  Unfortunately, it displays as a number. Much like on a page where you would have to use state:label.

SELECT num, CONCAT(state,' - ',city, ' - ',address)
  FROM `<?php echo $TABLE_PREFIX ?>locations`

Something to do with JOIN?

screenshot attached.