Questions tagged [multi-select]
All requests and queries related to Multi Select Picklist can be grouped under this tag
241 questions
0
votes
1
answer
548
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,652
0
votes
1
answer
289
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'...
- 1,360
1
vote
1
answer
5k
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
2
answers
195
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-...
- 31
0
votes
1
answer
215
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,363
1
vote
0
answers
1k
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,203
13
votes
4
answers
16k
views
How does SOQL consider INCLUDES for multipicklist? AND or OR
i have multipicklist for industry.
I have a records which has Bank,agriculture as the selected values.
If i need to get all the records have bank and agriculture selected together. Would includes ...
- 2,809
0
votes
1
answer
360
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 ...
- 502k
0
votes
1
answer
364
views
How to prioritize values in multi picklist
Hi Friends i got a requirement like want to prioritize values in multi picklist. It means if they select more than one field i want to prioritize like S.no.
Now i have sample picklist like.
I ...
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 ...
- 9,567
0
votes
0
answers
493
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
1
answer
2k
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,...
- 55
1
vote
3
answers
11k
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 ...
- 36
0
votes
2
answers
483
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 = '(\'' + ...
- 502k
0
votes
0
answers
413
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 ...
- 687
2
votes
4
answers
6k
views
SOQL Includes with Field Value?
I'd like to add a
FROM Account WHERE Clients_for_Job_Opportunities__c INCLUDES (AVTRRT__Job__c.Account.Name)
line to my SOQL query but at the moment it looks like I can only add static values.
So ...
- 195
1
vote
1
answer
5k
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 ...
- 5,371
0
votes
1
answer
522
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. ...
- 8,073
3
votes
1
answer
1k
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-...
- 1,926
1
vote
1
answer
2k
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 ...
- 87
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 ...
- 502k
0
votes
1
answer
451
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,371
6
votes
1
answer
2k
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 ...
- 22.8k
0
votes
3
answers
3k
views
Multiselect picklist - dataloader
When am trying to update contacts using Dataloader then multiselect picklist values for existing records gets overridden.I want values to be added to current multiselect picklist without overriding ...
0
votes
1
answer
4k
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 ...
- 7,434
1
vote
1
answer
1k
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<...
- 3,741
0
votes
1
answer
581
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
45
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 ...
- 8,073
0
votes
0
answers
127
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]
1
vote
2
answers
691
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 ...
- 103
2
votes
1
answer
681
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 ...
- 9,588
1
vote
0
answers
1k
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. ...
- 11
0
votes
0
answers
130
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?
- 1,543
4
votes
1
answer
320
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 ...
- 1,887
0
votes
1
answer
733
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 ...
- 22.8k
0
votes
1
answer
2k
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. ...
- 9,588
0
votes
0
answers
113
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=...
- 93.7k
0
votes
1
answer
49
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 ...
- 10.6k
0
votes
1
answer
31
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 ...
- 73.3k
-1
votes
1
answer
88
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.
...
- 502k
3
votes
0
answers
145
views
Multi select picklist values appear in much smaller font
I'm having some strange behavior with a multi-select picklist.
When I first try to inline edit the multi select picklist, the values are in a very small font. However, if I click out and click back ...
3
votes
2
answers
2k
views
more than one value selected in a picklist
I am trying to write a trigger or wf for a field to be updated if a Multi-select picklist has more than one value. Any suggestions on how to write if the multi-select has more than one value
- 1
1
vote
1
answer
1k
views
How to use multi select in App Builder to assign the value in attribute using design:component?
I want to Input multiple vales in an attribute but i can't find the perfect solution. i want like following Image . I Have tried with Dynamic Select List but it is not Multipick list and when I use ...
CommunityBot
- 1
1
vote
2
answers
21k
views
Use multiselect picklist values in lightning component
I have a lightning component that is pulling data from Products (product2) and it has a custom field (Benefits__c) that is multi-select picklist. I need to display those multiselect values in ...
0
votes
1
answer
1k
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/...
- 502k
1
vote
1
answer
122
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 ...
CommunityBot
- 1
-2
votes
1
answer
2k
views
how to create dependent picklist in vf page
I am having a multiselect picklist in that am displaying the list of profiles in the org using SOQL Query.My usecase is like when i click on any profile/profiles those related applications should be ...
- 17
0
votes
2
answers
2k
views
Validation Rule for multiselect picklist to prevent duplicate values
I have a multiselect picklist with ten values. One of these values cannot be chosen more than once on a record..
For example, multi_sel_picklist__c = "Aa" can only occur once on a record, with no ...
- 31
0
votes
1
answer
257
views
formula that syncs multi-select picklist from accounts to contacts object
I have a formula that sync multi-select picklist field from accounts to contacts object but having issue on character limit.
Eg.,
IF( INCLUDES(Account.Category2__c ,"Accessories (Bags, hats, ...
- 4,453
0
votes
3
answers
3k
views
How to display Multi Picklist values in new lines instead of separated by a semi colon in Salesforce
I have a multi picklist field called 'Rejection_Reasons__c' which is dependent on case status. When ever case status='Pending' or 'Rejected', the 'Rejection_Reasons__c' are set by user. As these ...
- 6,666