Questions tagged [picklist]
A picklist is a field type in Salesforce that contains a list of values from which a user may select a value. A picklist is represented as a drop-down box in the UI.
269
questions with no upvoted or accepted answers
14
votes
0
answers
13k
views
SFDX Deploy: Global Value Set Cannot Be Resolved
I am trying to use DX to deploy to a sandbox. It has been a major hassle. At this point the only error I get is this:
Global value set 'External_Evaluation_Required__c' in record type 'Exception' ...
- 1,050
9
votes
1
answer
925
views
Is there a way to automate the deployment of changed picklist values in a pipeline using SalesforceDX?
Sometimes we need to change the label or, more commonly, a value for a picklist item.
Suppose we do change the fullName attribute of a picklist field, to match an external system that will integrate ...
- 12k
6
votes
1
answer
731
views
Unable to query with cross-Object pick-list field filter on Custom Metadata SOQL
I came across something weird, SOQL which has a filter as cross-Object picklist field doesn't return rows, even if records exist.
Minimum viable code to replicate:
Create a new custom metadata type, ...
- 35.8k
5
votes
1
answer
1k
views
Fetch unique values using visual workflow
I am creating a dependent picklist in visual workflow using dynamic choice elements. The data source for picklists is database. When I fetch values I am getting duplicate values as it is in the ...
- 51
4
votes
0
answers
190
views
When to use FieldDescribeOptions.FULL_DESCRIBE in SObjectField.getDescribe(options)?
Background
Playing around with the SObjectField class has led me down a rabbit hole in wondering why and how I can make use of the getDescribe(options) method where options is a FieldDescribeOptions ...
- 4,877
3
votes
0
answers
992
views
How to populate a picklist field with its label value instead of API value in apex
I have configured the picklist values like this.
If I want to populate the picklist field by label value we need to query object schema and iterate to find API value.
Schema.DescribeFieldResult ...
3
votes
1
answer
634
views
How to get Picklist color value (hexadecimal value)?
Assuming we select for each picklist value a specific color (ie not dynamic assignment)
how to query the hexadecimal color value in Apex/soql ?
- 31
3
votes
1
answer
1k
views
lightning-record-edit-form: display text field as a custom picklist?
I've created a custom object where the user manually enters a locale value (ex: en_US, es). Instead of letting the user manually enter a locale, I'd like to provide the user with a combo box of valid ...
- 1,162
3
votes
0
answers
248
views
How to programmatically update picklist fullName value in the same deployment without getting a "duplicate label" error?
I have the following code:
<?xml version="1.0" encoding="UTF-8"?>
<CustomField xmlns="http://soap.sforce.com/2006/04/metadata">
<fullName>Some_Custom_Field__c</fullName>
...
- 501
3
votes
0
answers
1k
views
Get the active and inactive values from the Picklist
I'm trying to get the active and inactive values, especially the inactive ones, from a picklist to activate them via code. The problem is that I can only get the active values.
List<String> ...
- 121
3
votes
2
answers
757
views
Programatically how can I link Case Status Values to a Defined Business/Support Process
I am trying to create a custom visualforce page that is aware of the Case Status Values that are related to a specific Case Support Process.
I am able to get all Status Picklist Values from a ...
- 2,892
3
votes
0
answers
1k
views
Picklist Values org to org migration using Ant Migration tool
Hi I am working in a project that merge two Salesforce org into one. While migrating standard picklist values using the Ant Migration Tool, I can retrieve picklist values using the following package....
3
votes
1
answer
134
views
Account History tracking shows codes instead of full names after enabling State/Country picklists
I'm seeing that changes made on an Account after we have enabled State & Country/Territory Picklists on our sandbox default to showing the shortcodes for Country & State. Isn't it possible to ...
- 1,955
3
votes
0
answers
1k
views
System.DmlException: INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST
I am getting the below error:
Errors
Treatment Code: bad value for restricted picklist field: 95972
System.DmlException: Upsert failed. First exception on row 0; first
error: ...
3
votes
0
answers
553
views
Picklist Sum Formula Question
I received a request to create 20 numerical picklist fields and a formula summing the chosen numerical character. In this case, it is merely adding several selected numerical picklist value to each ...
- 213
3
votes
0
answers
136
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 ...
- 1,236
3
votes
0
answers
1k
views
Tool to migrate field dependencies
Currently we have several controlling picklist fields that have 300-400 dependent fields under them.
We are doing the field dependency matrix manually in the UI.
Is there any tool that can be used to ...
- 3,053
3
votes
0
answers
95
views
Parsing the datetime field in Site.com for pick lists
I am creating pick lists that contain months and years on an event list page in Site.com. The page brings in data for the events using a data-repeater. One of the fields being used is datetime which ...
- 31
3
votes
3
answers
108
views
Valdiation Formula Broken
The scenario for the validation rule is:
-if one lookup field is empty, then check that other n fields are not empty
(if a lookup is empty, then make sure that the fields that will be used to create ...
- 747
2
votes
0
answers
114
views
REST API patch allows me to write invalid picklist values to Opportunity.StageName
After running this...
curl -X PATCH "https://custom.my.salesforce.com/services/data/v56.0/sobjects/Opportunity/0060900000OWbmEAAT" \
--header 'Authorization: Bearer INTENTIONALLY_REMOVED' \...
- 451
2
votes
0
answers
2k
views
How to save picklist value in custom lightning datatable?
I have just started working with Lightning Web Components, and I am attempting to add picklist functionality to my datatable. My standard cell edits/saves are working as intended, but I am unable to ...
- 21
2
votes
0
answers
2k
views
How to modify the height of a lightning-combobox dropdown?
I have a lwc combobox and I wanted to control the number of options shown.
I tried a lot of CSS and slds existed on the internet but I couldn´t changed it.
Could anyone help me?
<div class="...
- 21
2
votes
0
answers
232
views
order of execution for evaluating restricted picklists
I am inserting lead via soap api (formassembly form) with a before insert trigger that translates (invalid) incoming picklist values in various languages to valid api values.
update - also tested via ...
- 4,385
2
votes
0
answers
211
views
How to get picklist values and translations using Aura and Apex?
Background:
I was using a an aura lightning:recordEditForm containing a picklist field. This component will automatically detect user language and use the translations you have set for that field.
...
- 341
2
votes
1
answer
1k
views
LWC picklist value undefined on initial load
I have a lightning-input-field inside a lightning-record-edit-form, used to create records. The field-name is a picklist field which uses a Picklist Value Set, with one default value.
When the form ...
- 3,665
2
votes
1
answer
714
views
Lightning Component not updating records
I need help getting my muddled-together-lightning-component to update existing records. I do not really know what I'm doing so it's a wonder I've made it this far :) My component lists all child ...
- 73
2
votes
0
answers
746
views
Create dynamic picklist in Flow Builder from Text
The requirement goes like this:
There is a MultiPicklist Field A on the Account (options -> A;B;C;D;E) and a Single Picklist Field B (options -> A;B;C;D;E) on Case.
When the user updates the case, ...
- 194
2
votes
1
answer
523
views
Unable to update manage package picklist field entries using apex code (metadata API)
Unable to update manage package picklist field entries using apex code (metadata API).
I tried using two ways of creating picklist values of metadata API.
Way 1:
public static void ...
- 635
2
votes
1
answer
1k
views
REST API: create dependent picklist values
I am aware that it is possible to create dependent picklist values using the Metadata API but I want to use the REST API.
I know how to create triggers, classes, and pages but I can't wrap my head ...
- 3,856
2
votes
0
answers
1k
views
Deployment failed: Component Errors: Duplicate picklist value:Yes_or_No - No
Issue: When validating a change set of 300 items into production, I
received one component error:
API Name: Opportunity.New_Integrated_Payments_Customer |
Type: Record Type | Line: 5028 | ...
- 3,452
2
votes
4
answers
5k
views
Binding a click event to document Lightning Component
I am using SLDS Picklist in Aura Component, I am trying to close the picklist when user clicked outside the picklist. I am trying to bind a click event to document and call the action to close the ...
- 43
2
votes
0
answers
267
views
How to deploy URL encoded picklist values in record types through ant?
In the metadata the picklist definition has the not URL encoded values of:
A $100 million+
B $50 - $99 million
And in the record types definition the values have been automatically URL encoded ...
- 71
2
votes
1
answer
488
views
How to use/show custom Picklists created in salesforce, in visualforce Pages to show possible values?
I have some custom fields (Picklists) in Salesforce Instance, like Languages__c which contains some Languages names.
I want to use it in a custom detail view of record, that is generated by using ...
- 325
2
votes
0
answers
2k
views
Global Picklists: Apex assignment
I'm currently developing an update to our application inside a sandbox using the new feature of Global Picklists. Unfortunately I can't simply assign one exact picklist value (exposed as a string) in ...
- 123
2
votes
0
answers
449
views
Creating a pie chart from a multi-pickist field
It appears Salesforce stores multi-picklist values as semicolon-separated values. I want to create a pie chart based on the individual values in a multi-picklist field.
For example, if I have field ...
- 4,753
2
votes
0
answers
104
views
APEX Triggers? Creating Reminders? Updating custom fields dynamically
When a custom field for my Lead changes (the user changes a value in a picklist) and saves the Lead, I want to:
update another field on the Lead object with a value (i.e., the user selects wait 2 ...
- 199
2
votes
0
answers
502
views
Programmatically access selected Chart Colors on Picklist Values
Is there a way to find out, programmatically, if my users have selected chart colors for a picklist value? I'd like to write VisualForce (ideally in CSS, but anything is fine) that is consistent with ...
- 4,162
2
votes
1
answer
208
views
Unable to access picklist value in apex
I am developing VF page and have couple of pick list values but I can't access any of the selected picklist value in apex controller.
I have modified a code little for simplicity.
I am getting null ...
- 445
2
votes
0
answers
713
views
Rendered not working translated picklist value radio buttons
Im trying to translate visualforce page. I have used custom labels to built the page. the page is translated good. For picklist values I used the below code, the picklist values are also translated ...
- 4,019
2
votes
2
answers
768
views
Picklist custom field with grouped values?
we have a picklist custom field for Opportunity objects where we have all the countries where my company works. Would it be possible to group the values in this field by region or continent? For ...
- 399
1
vote
0
answers
62
views
Getting the value entered in the “Display text input” field of a picklist choice in a flow
I was looking for the simplest way, in a flow, to allow the user to pick either a value from a list of presets, or to type a custom value.
I noticed that I could configure one of the choices like this:...
- 111
1
vote
1
answer
85
views
Picklist value inside Custom Label
Hello I was wondering if I can save several values in one custom label.
Because I have a global picklist value set but I only want to use some of them (but I cannot deactivate those values because ...
- 77
1
vote
0
answers
83
views
Open picklist over scrollbar
I'm trying to show a picklist over the scrollbar of my lwc.
I tried with z-index and overflow in some places but I don't find how to do that (maybe it's impossible?).
Here an example code that I wrote ...
- 11
1
vote
0
answers
358
views
LWC Fires on Change Event when Record Edit Form Picklist Fields are reset
On my Lightning Page I am using a Record Edit Form with Input fields for Picklists and Text.
When any of the Input fields are changed the onchange Event Handler is firing the HandleChange Event. This ...
- 339
1
vote
1
answer
189
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 ...
- 11
1
vote
0
answers
683
views
Flow - Update picklist with label value, not API name
I have a flow that is comparing the value of a text field (BillingCountry) to a picklist (Billing_Country_Name__C). If the text input is a valid Country picklist value, the flow should update the ...
- 11
1
vote
0
answers
60
views
Restrict Users from updating one field before another dependent field is updated and Saved
In my Org, there are two interdependent fields named Pacing and Pacing Notes.
The Pacing can't be set to Customer-Specific until the Pacing Notes field is empty. I am checking and validating this ...
- 263
1
vote
1
answer
961
views
I have a new set of picklist values based on the record types of a custom object. How do I enable them 'selected' by default when the org is upgraded?
I have a new set of picklist values based on the record types of a custom object. How do I enable them 'selected' by default when the managed org's package is upgraded? These new set of picklist ...
- 11
1
vote
0
answers
157
views
Multi-picklist width collapses in Lightning with SLDS component loaded
I'm converting an org to Lightning and have this markup in a Visualforce page:
<apex:inputField value="{!classInstance.opportunity[field]}"
required="{!IF(isSaveOnly,...
- 354
1
vote
1
answer
1k
views
How to add Dynamic Picklists to your LWC Design File for FlowScreen?
What is the best way to add dynamic values as datasource to FlowScreen components? Is there a way? Assuming that it's not supported, what would be the best alternative to keep the code consistent.
I ...
- 796