Questions tagged [multi-select]
All requests and queries related to Multi Select Picklist can be grouped under this tag
238
questions
-1
votes
2
answers
70
views
Validation rule for Multi picklist
I have a requirement where if a value "Others" from a Multi picklist is selected, "please explain others" text box should be used, if any other value from Multi picklist is ...
-1
votes
2
answers
58
views
Multi Picklist and number fields
I'm trying to create a new formula field that gives results as a text by concatenating few fields like multipicklist fields and text fields and numbers fields.
But i have been receiving an error when ...
1
vote
1
answer
181
views
Querying on Multi-Select Picklist in Get Records in Flow
After a whole lot of frustration, I found out it's not possible in the Get Records action in Flow to filter on a multi-select picklist, and you get an error: the idea to make this actually possible.
...
0
votes
0
answers
119
views
How to save multi select lookup values
I have created a multi select lookup component.
Below I am pasting my code.
HTML
<template>
<div class="slds-form-element" onmouseleave={toggleResult} data-source="...
-1
votes
1
answer
57
views
Filtering an email list in a flow by industry picklist with multiple selections
I am trying to set up a flow to send an email to newsletter subscribers in a custom object (Newsletter) filtered by industry.
Currently industry is a picklist field, not a multi-select picklist, ...
3
votes
2
answers
353
views
Pre select values in multi select combobox
I found this awesome repository on medium to have a multiSelectCombobox, and it works fine, but I wasn't able to pre-select values.
https://github.com/svierk/awesome-lwc-collection/tree/main/force-app/...
0
votes
0
answers
50
views
Sending values from a multi picklist to an account in pardot
I have a custom multi picklist field on my account object that tells us some required documentation we need from an account. We want to set up an automatic engagement that lets people know when they ...
0
votes
1
answer
565
views
Includes does not work with multi select picklist in flow formula
I created a record triggered flow and tried to create a formula which can check for a multi select picklist which I can use later in the flow.
The formula is like this -
IF(INCLUDES( {!$Record....
0
votes
1
answer
456
views
compare multislect pick list with another picklist
I have a multislect picklsit on User object and a picklist on case object, I am trying to write a validation rule so that if picklist value selected on case is not matching with one of the multislect ...
-1
votes
1
answer
811
views
LWC Multi Select Picklist depending on a combo box
Currently am stuck in between these.... first I'd have a combo box based on the selection (onchange) I need to render some data in multi select Picklist....so the problem is of I select any of those ...
0
votes
0
answers
113
views
Selected Picklist value not showing in UI but data is saved in backend by saving the record
I'm facing an issue with my picklist value called the selected value from picklist is saved at backend but in UI the selected value is not showing up.
I can able to see the value in UI before the ...
0
votes
0
answers
120
views
Search for Specific Text in a Multi-Select
I have a multi-select that lists bandwidths. Some are in Mbps, and some are in Gbps. I need to know if any of the selected options is over 1 Gbps, so I'd like to search the multi-select for the text '...
-3
votes
1
answer
53
views
Changing Picklist to Multipicklist and using in formula field
I have changed the picklist fields to multiselect picklist and trying to use this in the formula filed getting below error. kindly some one help.
Field changed as
Mand_A__c(Picklist) ------> ...
2
votes
1
answer
160
views
Transform a List<String> for use in Multi-Select Picklist where clause
I have a list of strings which I need to put together in every valid combination so that the result can be used in an includes WHERE clause of a multi-select picklist in a SOQL query. Basically, I ...
0
votes
0
answers
166
views
Condition Using Multi-Select picklist not satisfying in Flow
I am having an issue in a Salesforce flow. I am using a condition on the flow using Contains which is not satisfying the condition. Please refer to the screen-shot given below :
Here ...
1
vote
2
answers
900
views
Validation Rule on Multi-Select Picklist to only allow one value
I need a validation rule on a multi-select picklist field that if a specific value is selected, no others can be selected.
Right now I have:
Includes(Multi_Select_Field__c, "Value1")
But ...
1
vote
3
answers
2k
views
Getting this error on updating multipicklist field using flow:- INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST: bad value for restricted picklist field
I am trying to update a multipicklist field on Accounts using the multipicklist field on Opportunity, which is also using the same global picklist value set. But I am facing two problems with this:-
...
0
votes
0
answers
31
views
Predefine the values in a collection variable
Is there a way to add text values to a collection variable from a predefined list? I have a very long list (>100 items) that I want to loop through item by item but I can't find a way to quickly ...
1
vote
1
answer
331
views
Multiselect Picklist values are not stored in the database as User entered order in UI
Requirment : Values should be stored in order as they selected in UI. But Multiselect Picklist values are not stored in the database as User entered order in UI.
Please help us is there any solution ...
0
votes
2
answers
642
views
LWC select element with multiple
I'am trying to retrieve all the selected values from a select element with multiple options but I can only grab the last selected value.
HTML
<select class="slds-select" id="select-...
1
vote
1
answer
448
views
How can I develop a select all/deselect all for duallistbox in aura?
I'm building an AURA component that has dualListBox that is dependent on on lightning:select (https://prnt.sc/mc05yPEzmBO7), so based on the value selected on the lightning:select I populate the ...
0
votes
1
answer
127
views
Multi Select Picklist field VR
Is it possible to create a Validation rule or something on multi select picklist field so that the user can select maximum of 3 and minimum of 1 values out of 10.
-1
votes
1
answer
538
views
Collection choice set not available in Assignment element
I have a screen flow with a multi select for the user to select what records they want to update. I am trying to use the collection choice set in an assignment element to remove the first Id until the ...
0
votes
0
answers
380
views
Multi-Select values not staying checked on screen flow
I have a screen flow component on the Account object that lets users make selections and save their changes. The component is always visible so that users can see the current selections for that ...
1
vote
1
answer
2k
views
Formula to update multi-picklist with Salesforce Flow
The requirement I have is that a multi-picklist (MSP) field ("Specialty") is updated based on any additional values from another multi-picklist field ("Specialty Marketing") with ...
0
votes
1
answer
108
views
Key press Filter search on a field it work's in classic but not in salesforce lightning
When we have Hundred of values in picklist it's difficult and time consuming for user to scroll down and search there value, so with the help of Keypress on keyboard that cursor reaches the initial ...
1
vote
1
answer
224
views
Add value to multi-select picklist with batch class
I'm trying to add a value to a multi-select picklist with a batch class. The debug statement shows that its being added but it's not saving for some reason. Any ideas?
public class ...
1
vote
1
answer
435
views
Data Transformation from mutli-select picklist to array of number in a flow
I have a multi-select picklist field that I need to transform to an array of number to use in a API. How can I do this in a Flow?
Context:
I need to send the result of a multi-select picklist to an ...
0
votes
0
answers
2k
views
multi Picklist values in LWC
i am new to lwc. I am stuck with assigning values to multi picklist in Lwc like that
let applicationnNameValues= 'A;B';. I am using standard createRecord method. when i remove that value ...
0
votes
1
answer
1k
views
Enable to add more than 100 values on multi select picklist field in salesforce
I have a custom multiselect picklist field with 500 values in the application and now i need to enable the selection of more than 100 values at a time on any record.
As per the salesforce limitation, ...
0
votes
1
answer
492
views
Validation Rule on a Multi select picklist limiting the total number of characters selected
I have a multi-select picklist with many items, however I want the total number of characters to be less than 60. For example a user can select this: apple car banana pineapple watermelon grapefruit ...
0
votes
1
answer
940
views
How to refresh dependent dual listbox in LWC
The attached image is an LWC, in which Category is a controlling picklist (Combobox) and Sub Categ is the Dependent Picklist.
Eg. Category 1: Sub Categ 1,2,3
Category 2: Sub Categ 2,3
I am storing ...
0
votes
1
answer
817
views
Validation Rule for Picklist and Multi picklist
Option__c(picklist) This is picklist field which contains values (Yes/No) and default as Yes.
This field(Option__c) should only be mandatory, when the field State__c(multi picklist) has selected as NY....
0
votes
1
answer
245
views
How do I prevent deleted multi-select picklist values from reappearing after deletion?
The custom field values on a multi-select picklist just reappeared after I deleted them, and the user who influenced this is our Pardot integration user. How do I prevent this from happening again? I'...
0
votes
2
answers
114
views
Best practices after retiring a multi-select picklist value
I need some help in determining the sequence of steps and best practices when migrating data from one field to another after retiring a Multi-Select picklist value.
Previously, my org used a multi-...
0
votes
1
answer
160
views
Validation Rule - using multiselect picklist
Im trying to write my first validation rule.
If 'fruit' is one of the selections from (multi select) picklist A.
Display the following fields:
Apple
Orange
Pear
Otherwise do not display these ...
1
vote
0
answers
825
views
How to add values to available part in multiselect picklist using apex?
I want to add some values to the available part of the multi-select picklist.
The below code adds the values to selected part of the multi-select picklist
//SetupObj__c is custom object
//...
-1
votes
1
answer
728
views
Conditionally add slds-is-selected on multi select dropdown
I have created a multi-select combobox in LWC, passing list of columns to it from the parent components. Its a json which is being passed from parent to child.
JSON :
[{"align":"left&...
0
votes
1
answer
269
views
multiselect pick list - LC and Visualforce component
I basically need to build a multi-select picklist component that works both in Lightning and Classic.
There're already solutions available for both scenario, LC embedded in FlexiPage and Visualforce ...
4
votes
1
answer
3k
views
How to populate multiselect picklist from list or array of string or a string(; separated) in lightning web component
In my lightning web component, I have a which has a multiselect picklist field from an object. I want to populate that field with values from a list returned from an apex method. I tried to assign ...
0
votes
0
answers
441
views
Get a count of values selected in a multi-select picklist on all contacts
I have a multi-select picklist (colors__c) in my contact object (with 20 records). Let us say the picklist has 4 values (red, blue, green, yellow). And I have a separate object (object__c), which ...
1
vote
3
answers
8k
views
Validation rule that includes multi picklist field
I need help with a Validation rule that basically says if Account Type = Customer, and you want to set Account Stage = On going, you have to make sure first that multi picklist field does not contain ...
1
vote
1
answer
936
views
Multi-select pick list in a screen flow
I created a component that would make a multi-select pick list on a screen flow. It works except you can't assign it to a variable that can be referenced when moving on to the create records part of ...
0
votes
2
answers
331
views
How to add the 'AND' condition in dynamic query for multi select picklists?
List<String> newMultiSelectList = new List<String>();
newMultiSelectList.add('Pro-Life');
newMultiSelectList.add('Establishment');
newMultiSelectList.add('GOP');
string value = '(\'' + ...
0
votes
0
answers
398
views
VF Page with the Multi select picklists
I am trying to use the multi select picklist field in my VF Page. The multi select picklist field has a default value, I was hoping when I use this field in the VF Page I should be able to see the ...
1
vote
1
answer
4k
views
Dynamic Multiselect picklist value on Aura Component
I want to populate Multiselect field with list of values dynamically. Instead of assigning the values to Array of string in aura attribute, I'm referring to the object from controller directly,
But my ...
0
votes
1
answer
2k
views
Multi-select picklist issue
I would like to build a row-level formula with a multipicklist in a report. But I can't even find/select the multi-select picklist field. When I copy the Api Name of the multi-select picklist field ...
0
votes
1
answer
439
views
Cannot read property 'contains' of undefined When Rendering Fields Based on Selected Multi-Picklist Values in Salesforce LWC
I am encountering the following error in Salesforce Lightning page wherein I try to render some fields based on values of multi-select picklist field:
I even tried includes but same error occurs. ...
3
votes
1
answer
958
views
onchange event does not trigger on Multiselect picklist in LWC
Goal is: Based on Multiselect Picklist value selection/deselection, I want to hide/show certain text area fields on my LWC form.
Below is my LWC:
HTML:
<template>
<lightning-record-edit-...
0
votes
2
answers
3k
views
How to exact match multi picklist field value with a string field in Apex
user.City__c.contains(Sales.Contact__r.City__c)
City is a field on user Object which is a multipicklist values with ; separated values, I want to compare city with city value from contact.
The problem ...