Dynamically adding a text value in picklist field

Hi Ankita, 

If you save a value to a picklist field via an action or by overriding the metadata for that field in the model, it will save it back as a new value by default. However, it will be listed as an Inactive Value in the Salesforce field settings. Setting it to active would have to be done via custom code, probably on the backend via Apex, since it’s an admin setting and would probably have to run outside permissions. 

Does that help? Thanks!

Matt

We done dynamic picklists - mostly when we need the picklist values to be based on more then one thing, so a standard Salesforce dependent picklist won’t work because it isn’t logical enough.

To do this, we create a snippet called picklistOption and on the field you want to adjust, change the render type to “Custom run a snippet” and select your picklistOption snippet.

Here is a sample picklist value changer. This one is based on the user picking a Fruit Type, and the Color picklist (which has the render snippet on it) auto adjusts based on the type of fruit selected.

This is just an example. 🙂 Our real ones have fields pulled off other models to drive logic.

var $ = skuid.$,
field = arguments[0],
value = skuid.utils.decodeHTML(arguments[1]);

            // Run the standard picklist renderer for the given mode
            skuid.ui.fieldRenderers[field.metadata.displaytype][field.mode](field,value);
            
            if (field.mode == 'edit') {
                var select = field.element.find('select');
                
                if (select.length) {
                
                    // Remove unwanted entries, we are removing all existing values and recreating them for each row
                    $.each(select.children('option'),function(){
                        if ($(this).val() !== value  && $(this).val() !== '--None--' && value !== '--None--') {
                            $(this).remove();
                        }
                    });
            
                      var fruitType = field.model.getFieldValue(field.row,'Type__c',true);
            
                    // Add new entries
                    if (value !== '--None--' && (value)) {
                        select.append($('<option value="">--None--</option>'));
                    }
                            if (fruitType == 'Apple') {
                                    select.append($('<option>Red</option>'));
                                    select.append($('<option>Green</option>'));
                               
                            }
                            else if (fruitType == 'Orange') {
                                select.append($('<option>Orange</option>'));
                            }
                            else if (fruitType == 'Banana') {
                                select.append($('<option>Yellow</option>'));
                        select.append($('<option>Green</option>'));
                            }
                    else {
                        //add common picklist values here
                        select.append($('<option value="">--None--</option>'));
                    }
                }
            }

Hi Matt, are you thinking using MetadataAPI? What would be your suggestion? I have a use case for it. Thanks