Questions tagged [multi-select]
All requests and queries related to Multi Select Picklist can be grouped under this tag
213
questions
0
votes
0
answers
76
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
69
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
37
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 ...
1
vote
1
answer
175
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
125
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
0
answers
44
views
How to use Multi select option in einstein bot
I have a flow that returns a List. How can I get the user to select multiple values from this list?
0
votes
1
answer
41
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
29
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
0
answers
16
views
Hide options based on multipicklist field value
Is it possible for a product rule to hide product options if one of the Quote's text field is in the value of a multiselect picklist on Product of that option?
0
votes
1
answer
48
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 ...
0
votes
0
answers
197
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
161
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
41
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 ...
2
votes
1
answer
868
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
192
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 ...
0
votes
3
answers
2k
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
541
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
81
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
45
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
1k
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
464
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
216
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. ...
2
votes
1
answer
548
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
1k
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 ...
0
votes
1
answer
879
views
how to capture multiselect picklist value in text field using workflow
I am trying to copy picklist value from workflow field update and when record is created and edited.
but the problem is multiselect picklist values support only include and includes function. so multi-...
0
votes
1
answer
260
views
Multiselect picklist values are not prepopulating while clone using custom button URLFOR
Created custom button and added on page layout in lightning i want to clone specific fields only so using url hack.
{!URLFOR('/lightning/o/Request__c/new?&recordTypeId=0129C000009CIiu&...
5
votes
1
answer
851
views
Is it possible to set # of visible lines on a multi-picklist field with lightning-input-field in LWC
While using lightning-input-field within a lightning-record-edit-form in a LWC, I noticed that multi-picklist fields don't respect their default visible lines setting. It always seems to show 4. I've ...
0
votes
1
answer
616
views
Multi-Select Picklist Alternative
I am looking into the best alternative solution for data capturing and reporting. I am trying to avoid multi-select picklists.
I want to capture at the Opportunity level:
Field1__c (that contains): A,...
0
votes
1
answer
668
views
invalid operator on multipicklist field
We have a custom object, Programs that has several multiselect picklists. One of these is called keywords. When I look in the field I see that the terms are separated by semicolons. I do this to ...
0
votes
1
answer
2k
views
Trigger to update Multi-Select Picklist
I created a trigger to update a multi-select field on the Account object with the values from a multi-select field on child Opportunities. If values already exist in this field on the account then the ...
0
votes
1
answer
303
views
Multiselect picklist SOQL error [duplicate]
I'm trying to get records of custom object where MultiSelectPicklist__c have names of publicgroups.
List<String> groupIds = new List<String>();
List<String> groupNames = new List<...
1
vote
3
answers
3k
views
SOQL query for Multiselect picklist
Hello I'm trying to use string in SOQL query where clause for multiselect picklist.
I need to get records of CustObj__c where Multipicklist__c fild have 'abc' or 'xyz' values.
String str = '\'abc\',\...
0
votes
1
answer
89
views
Multi-select picklist validation rule checks against position in the multi picklist instead of values
Hope you are all fine,
I'm doing a validation rule over a multi-select picklist that should avoid to be changed on certain substatus. Validation rule is a as follows:
AND(
$Profile.Name <>...
0
votes
1
answer
32
views
Multiselectpicklist inlineeditsupport double click shows disrupted popup
I have a multiselectpicklist within apex:inlineeditsupport shown on a Visualforce table. When double clicked on it, the pop up window is corrupted as shown. I found that the issue is because of the ...
1
vote
1
answer
1k
views
Set Specific Record as default in Record Choice Set in Flow
My flow starts by searching for a specific contact, then on the next screen there is a multi select picklist which lists all of the contacts at the account of the first contact. The thing is, I want ...
0
votes
0
answers
53
views
How to create a multi-select lookup relationship between two custom objects?
While coding for Force.com please tell how to create a multi-select lookup relationship between two custom objects?
[![I am trying to achieve something like this][1]][1]
2
votes
1
answer
422
views
Best practice how to escape multi-select picklist field of object in dynamic SOQL request
I am trying to write dynamic SOQL queries, but I don't know the exactly correct way how to escape the multiselect picklist with multiple categories included the way it is working and not vulnerable to ...
1
vote
2
answers
300
views
Associate a Case with Multiple Locations
I need to give users the ability to create a case that's associated with multiple locations. There's currently a Master-Detail relationship between Account and Location. When a user is creating a case ...
1
vote
0
answers
783
views
Get Multi select picklist and update corresponding category using custom metadata type
We have a Custom Metadata Type which shows the relation between a product of interest and categories. When a product of interest is selected we would like the corresponding categories to be selected. ...
0
votes
0
answers
73
views
LDS Multiselect picklist
I am trying to use the following code from the Lightning Design System documentation. I am getting SVG errors. Can someone tell me how to resolve this? Can I use something other than the svg code?
4
votes
1
answer
93
views
SOQL Count of non-blank multi-select fields
I'm trying to find out how many people answered a multi-select question in a survey. For this count I do not need to know what they picked, simply that they picked something (or didn't not pick ...
0
votes
1
answer
420
views
Email alerts based on Multi-select picklist values
The campaign has a multiselect picklist for Sales Theater (Values = AMER, APAC, PBST, Global etc) and wants to send an email alert to corresponding Distro List.
Examples below:
1. Selected picklist ...
0
votes
1
answer
1k
views
Lightning:dualListbox Style Not Working As Expected
When I create a dualListbox on a lightning component I am unable to see the values. When I inspect I can see that the values are there.
It almost looks like the color is set to white or transparent. ...
0
votes
0
answers
87
views
Edit task whoId in Vf page
We have a requirement of editing a task whoid from VF page multi- select list(contacts).The page opens from task custom button.
VF page code block:
<apex:page standardController="Task" extensions=...
0
votes
1
answer
45
views
multiselect pick list custom field
I have a long if(includes formula that is aggregating a few common responses into the same text values. (It's longer than below but that is enough for my question). There are actually 3 outcomes I ...
0
votes
2
answers
2k
views
How to remove an option from mutli-picklist field in apex trigger
I want to write an apex trigger action to remove a particular value from multi select picklist field based on some condition.How can I do this?
This is my trigger action:
public static void ...
0
votes
1
answer
30
views
IF(CONTAINS) question from an MPL
I am trying to aggregate data from an MPL into a separate field with fewer values. When I run the formulas, it is only returning the first value. Is there a way to rewrite the formula so that all true ...
-1
votes
1
answer
51
views
Question on Multiselect Picklist
I am trying to assign values to a multiselect picklist which also allows users to input a unique value (lots of values).
I would like to create a formula to assign a 1 to all values, and 0 to blank.
...
0
votes
1
answer
373
views
How to implement a custom Field Dependency with a Multi-select Picklist as controlling field?
Right now a Multi-select Picklist could only be on the dependent field. There is a custom way to use it as controlling field?
Right now my workaround is to use a validation rule to avoid the update/...
1
vote
1
answer
91
views
SELECT opportunities AND contacts AND tasks
o See all opportunities (where field isclosed = false), contacts
and tasks (where field isclosed = false) related to the account.
I Have This Select
Select Id,
(Select Id, WhoId FROM Tasks ...