smarter lists

[freakalad]

Hi guys,
Don't think I've posted before, so here goes....


The [Dropdown Editor] is a pretty nifty feature, but unfortunately not enough.

2 pieces of functionality is required:
* sub-lists (hierarhies)
* option to use a MULTIPLE type select listbox, as opposed to a simple drop-down

One use-case example I'd like to give is that of an account-type.
When creating an account, I can only specify a single type to indicate my relationship with them (i.e. competition or partner), when in reality our relationship could be much more complex, i.e. my competition could in some cases be a partner or a reseller & these relationships are not mutually-exclusive.

Also, I would consider Resellers to be a sub-set of Customers, for example, and being able to indent an item below another should be able to indicate this relationship.

[letrium]

Try multienum type of a field.

[freakalad]

Interesting hack, thanks for the suggestion, but this really should be something that's integrated into the core, or at the very least a project/module, and not patched after the fact.

The reference I've found to this patch/addon is here, and is dated 2008, so there's no guarantee that it would work or be stable in the current release [CE 6.2], so there's no teling what the effect would be, in terms of security, stability, or data integrity.

Any other suggestions please?

[jmertic]

Does this bug cover this? If so please vote it up.

http://www.sugarcrm.com/crm/support/...pl=#issue_6025

[freakalad]

I think that is a fairly accurate description & good way of addressing the issue, thanks jmertic.

I've voted the request/bug as you've asked.

See the issue has been present since 2006, but not much movement on it in all this time

Cheers

[letrium]

You have only to add one file with one line of code to get this feature working. And this will be upgrade-safe.

[jmertic]

letrium, if you could provide this one-liner to us as a pull request to https://github.com/sugarcrm/sugarcrm_dev, we would be glad to integrate it back into the product.

[letrium]

Create file "custom/Extension/modules/Accounts/Ext/Vardefs/ANY_NAME_YOU_LIKE.php"
with next content:

 <?php
$dictionary['Account']['fields']['account_type']['type'] = 'multienum';
?>  

Then rebuild and repair db.

Do I understand your request right? Or i'm missing something?

[jmertic]

Re-reading this thread a bit, I think I've mis-understood the original request as well. So there's two issues at play:

1) Dependent dropdowns, meaning that you can select one item in a dropdown and then it can change the options in another dropdown. This is possible with Sugar Logic ( see http://developers.sugarcrm.com/wordp...ndustry-field/ for an example )
2) The ability to change a field from a single select dropdown to a multiselect. This isn't a Dropdown Editor role, instead you need to change this on the field in question. The suggestion letrium has here is spot on.

I was misunderstanding for a problem with editing dropdown list values that has sub-arrays for values, which Dropdown Editor does not support.

Thanks!

[freakalad]

2) The ability to change a field from a single select dropdown to a multiselect. This isn't a Dropdown Editor role, instead you need to change this on the field in question.

This is correct.
But it should rather be either "backed in" into the core, or as a module/add-on for proper integration, rather than being "hacked on" (I mean that in a nice way, promise).