dynamic multi-select from API call

Hello Sergio, 

I've done something similar. In my case, The users from Sugar have a Sales Channel property (A multiselect field, so they can have different Sales Channels).

Then, when I'm creating an opportunity, there is a Sales Channel dropdown field that will populate ONLY the values from the assigned user, and everytime the user gets changed, the function will retreive the proper Sales Channels.

If the assigned user has only one sales channel , then it will be selected by default.

({
extendsFrom: 'OpportunitiesCreateView',
initialize: function (options) {
this._super('initialize', [options]);
this._filterSalesChannelDropdown();
this.model.on('change:assigned_user_id', this._filterSalesChannelDropdown, this);
},

_renderHtml: function(options) {

this._super("_renderHtml", [options]);
},

_filterSalesChannelDropdown: function() {
//debugger;
var self = this;
var userBean = app.data.createBean('Users', {id:self.model.get("assigned_user_id")});
var saleschannel_list = app.lang.getAppListStrings('Sales_Channel_list');

var request = userBean.fetch({

success: _.bind(function(data) {
if (userBean.get("sales_channel_c")){
inString = (userBean.get("sales_channel_c")).toString();
var dd_values = {};
var dd_array = {};
var array_count = 0;
_.each(saleschannel_list, function(value, key) {
//console.log(key, value);
if(key === ""){
dd_values[key] = value;
}else if(inString.search(key)==-1){
delete dd_values[key];
}else{
dd_values[key] = value;
dd_array[array_count] = key;
array_count = array_count+1;
}
});
self.model.fields['sales_channel_c'].options = dd_values;
if (Object.keys(dd_values).length == 2){
self.model.set('sales_channel_c', dd_array[0]);
}
}
},this),
});

},

_dispose: function() {
this._super('_dispose', []);
}

})

Hope this helps.

Angel Mtz.

Angel Martinez

   thank you for your response i've been reading about this after Francesca Shiekh showed me the way, now my question for you is, where do you put that code? did you updated enum.js or created a new file? if you created a new file where was it and is it a js or php file?

Angel Martinez

   thank you for your response i've been reading about this after Francesca Shiekh showed me the way, now my question for you is, where do you put that code? did you updated enum.js or created a new file? if you created a new file where was it and is it a js or php file?

Looks like Angel took a different approach and is using the create view controller.

<mysugar>/custom/modules/<your module>/clients/base/views/create/create.js

He is building an array of dropdown values and setting the field's options to that array:

self.model.fields['sales_channel_c'].options = dd_values; 

That works but what he's doing is just filtering the existing dropdown to include only a subset of values, as opposed to building the list dynamically from scratch - which I think is what you were asking about. He is removing from view the values that he doesn't want the user to see when a new record is created, but whatever value the user does set, it exists in the language's app_list_strings array so it will display correctly.

You don't have a set dropdown list that you are filtering, do you?

FrancescaS