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.
1,092
questions
0
votes
1
answer
25
views
Salesforce apex how to save checkbox multiple values in database
I am trying to save the values from checkbox group in apex. I have converted the values from comma delemited to a list of strings. How can I save the values into the picklist type field. I have ...
0
votes
0
answers
37
views
Picklist Labels not translated
I have set up translation on a custom picklist field as shown:
The language selected for the Picklist Labels is French, and my User's Language is set to French.
According to my understanding, this ...
- 660
0
votes
0
answers
33
views
Create Header Actions dynamically in lightning Datatable
In the documentation provided by Salesforce on the 'Datatable' component we find the necessary instructions (see section 'Creating Header Actions') to create actions at header level.
It is also ...
- 1
-1
votes
2
answers
42
views
Salesforce formula for multiple picklist values
I am trying to write a formula where if Field- 'Status' contains picklist value as 'New','In-progress' or 'Escalated' then I want to make Field - Urgency to 'False'.
Can anyone please help me I tried ...
- 1
0
votes
1
answer
31
views
Record types, with their corresponding reason and subreasons
I am new to Salesforce Service, I would like to generate a report or a SOQL query to retrieve all record types, with their corresponding reason and subreasons. All the queues with notification steps ...
- 135
0
votes
0
answers
35
views
Custom Object Definition ID: bad value for restricted picklist field <CustomField>
I got this error when creating package version (1) Create_New_Order: Custom Object Definition ID: bad value for restricted picklist field: MOrder__c
<?xml version="1.0" encoding="UTF-...
- 55
-1
votes
1
answer
81
views
Picklist value: Advertisement in picklist: AccountSource not found
There is something really strange, I got these errors after try to create patch update version
vctqs1@Thus-MBP erp-salesforce % sf package version create --package 'Manabie User' --installation-key ...
- 55
1
vote
0
answers
33
views
Cannot deploy a new picklist field to a scratch org due to error: "Duplicate label"
We are using scratch org validation as part of our CI/CD process. I created a new custom picklist field. When CI job deploys this field to a brand new scratch org the following error occurs:
Metadata ...
- 5,077
0
votes
1
answer
71
views
Picklist field is disabled in LWC Datatable
I have a picklist field which I am fetching data from Apex. Now the scenario is I have to fetch all the data and I'm able to see those values in console.log but the picklist field looks greyed out and ...
-1
votes
2
answers
44
views
Limit selection of picklist values to Flow usage only
I have a picklist for type on Accounts, and I'd like to lock it down so some of the values are only accessible to be selected via Flow, or so that if a specific value is selected, ONLY flow can change ...
-1
votes
1
answer
16
views
Why am I getting this error when I sue the solution posted for how to use a picklist field in a formula field
Error: Incorrect parameter type for operator '+'. Expected Text, received Number
The formula content is this: I need to pull together the Tracking # + the Case # + the Pickup Type__c, which is a ...
0
votes
0
answers
38
views
Validation Rule Question - Required Fields
Hoping someone can help me figure out my validation rule. I'm pretty new to writing code so any help is appreciated. I want my rule to state: If the picklist value is soft closed or closed then to ...
- 1
-2
votes
2
answers
44
views
creating a commission formula for custom object
I am new to Salesforce and hopefully I'm asking the right question.
I have created a custom picklist under my Accounts object to determine what tier my customer has agreed upon. Tier 1 would be a ...
- 1
0
votes
0
answers
35
views
Picklist Choice Set - New Resource Value unavailable
I hope someone can help...
I'm creating a Screen Flow to create a new Opportunity with a Picklist Choice Set in one of the Trailblazer Playgrounds.
I've created a StageName Picklist Choice Set and I ...
- 13
-1
votes
1
answer
56
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, ...
- 1
-1
votes
1
answer
161
views
How can I restrict a standard picklist so that only existing values can be used?
I will preface my question because I do not know Salesforce well at all. My company upgraded to Salesforce because a consultant recommended it. Nobody knows how to use it correctly; somehow, ...
0
votes
0
answers
62
views
Working with managed files in Unlocked Packages
I am working on an org where we are building a custom solution on top of a managed package. The managed package provides the base objects and a number of standard fields. I have extended this with ...
- 3
0
votes
0
answers
35
views
Report considering changes in picklist value
we are a non-profit helping immigrants. We have a custom picklist field showing at which stage our customers are (let's say before the immigration and after the immigration). We need a report that ...
- 1
2
votes
1
answer
156
views
How to clear the value of picklist field with a formula field
I have an action on the Account object where I want to update some values on the record. In some conditions I want to force the user to re-select a value for a picklist field (Account Country). My ...
- 135
0
votes
1
answer
93
views
Invalid field Status__c for AggregateResult using GROUP BY in SOQL
I want to count records based on different values provided to records using Status__c field. Status__c is a picklist field. For efficiency purpose, I want to run one query but get different result of ...
- 54
0
votes
1
answer
102
views
Error: Incorrect parameter type for TEXT. Expected Number, Date, DateTime, received Picklist
I have a picklist custom field, let's call it Class__c of Unit custom object. I want to assign a default value to it. Default value is current user's Unit__c value. User's unit is also a picklist ...
-1
votes
1
answer
125
views
Storing a table with multiple value data in custom metadata types
I have a table with two columns. One column is a role and the other are keywords associated with that role. For example:
Roles
Keywords
Admin
Desk, Forms, Data Entry
HR
People, Communication
What ...
- 133
0
votes
0
answers
44
views
how to display filtering option for picklist values to successfully get records in visualforce page,Also how to provide grouping for same record name
I am trying to build one Visualforce page where I am able to get all approval history information. But I am not able to provide users the opportunity to filter records based on "Status". ...
- 1
0
votes
0
answers
52
views
how to display filtering option for picklist values to successfully get the records in visualforce page
I am trying to build one Visualforce page where I am able to get all approval history information. But I am not able to provide users the opportunity to filter records based on "Status". ...
- 1
-2
votes
1
answer
115
views
Export several objects picklist details into CSV file using apex
Context
We need to export picklist label and API values for several objects, in a csv file using apex.
Several posts exist on this subject but the objective is to export picklist values for several ...
- 4,185
0
votes
1
answer
77
views
I need to map custom component value to record field
I am looking for solution using LWC. My problem statement is like:
I have custom component which is showing us roles in picklick and I need to map selected roles into custom field, Can you pls suggest ...
- 9
-1
votes
1
answer
286
views
Is this a known issue - Inactive Picklist Value shows up on a new Order
I have an inactive picklist on the OrderType field on Order.
When I create a new Order record from an existing Quote record, then the Order after creation shows 'New' as an Option in the OrderType ...
- 845
0
votes
1
answer
61
views
Best Practices For "Nullable" Checkboxes
I'm managing an org where a bunch of new checkbox fields are going to be added - they are optional and it is important to know if the checkbox was actively being checked or not checked by the user. So,...
- 2,272
0
votes
0
answers
66
views
Lead conversion - map a non-global picklist value to global picklist value
I'm hitting a problem with Lead conversion where I want to map a field with picklist values to a field with a global picklist of values.
The values are valid (Yes or No) in that they are the same as ...
- 1
1
vote
0
answers
363
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
592
views
How do I prevent going backwards in an opportunity once a specific step is reached?
I need to prevent users to change opportunity status back to an earlier stage once a specific stage has been reached.
StageName values in order are:
New
Preselection
Instruct
Closed (Won/Lost)
Once ...
- 29
0
votes
1
answer
451
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 ...
- 143
-1
votes
1
answer
462
views
Formula field to evaluate two fields separately and returns a value based on one or the other values
The formulas work separately but I need the formula to evaluate the formulas in a "or" situation. IF I use & for the first formula - it concatenates the field but I want a Closed Or an ...
- 1
0
votes
0
answers
43
views
Unable to use createddate in picklist field default value formula editor
I am trying to populate a default value in a picklist field by using below formula:
IF((DATEVALUE(Createddate) - Manufactured_Date__c)<365,"Yes","No")
I am getting an error ...
0
votes
1
answer
96
views
Picklist value on record UI and label are different
I am observing that an existing custom field (lets call it 'Type'). I see that on the record page that the value I selected (and can change to other similar values) is of 'PR - A':
But the value in ...
0
votes
1
answer
282
views
How to get average from picklist value field in Salesforce?
I was wondering if anyone has come across this scenario?
I have one picklist field called Knowledge_Level and it has a rating range 0,1,2,3,4. This picklist field is in a related object called ...
- 87
0
votes
0
answers
33
views
Cleanest way to map user accounts to picklist dropdown?
In a restricted environment (no Apex or adjustments to user records allowed), I have the task of creating picklist that are (at least loosely) mapped to user accounts that at record user can choose ...
- 145
0
votes
0
answers
47
views
Getting INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST while creating a record for CareRequestExtension
All. I am trying to create a record for CareRequestExtension via apex. While creating the record I am providing non-existing values to some picklist fields of CareRequestExtension. For some picklist ...
0
votes
0
answers
73
views
Show case picklist values from parent object
I am working on showing picklist value on the basis of user permission set / profile.The picklist values on child needs to be shown on the basis of certain permission assigned to the user.
I do not ...
- 17
0
votes
1
answer
117
views
Adding a value to a picklist field of an entity in an org via apex
All,
I am trying to add a value to a picklist field of an entity (i.e. Document Attachment Status of Care Request Extension ) via apex class in my org only.
I tried following approaches but those are ...
0
votes
0
answers
42
views
How do I make more fields drop down
Hi I am trying to create the following fields
Industry/Type of work for past 10 years-Section
Current position/industry
Length of time in position/industry
Prior position/Industry
Length of time in ...
0
votes
0
answers
9
views
How to package a custom picklist value inside Salesforce package [duplicate]
Correct me if I'm wrong but I've read that you are unable to package a custom picklist value inside a Salesforce package. I tried confirming this by creating including the following metadata in the ...
- 5
0
votes
1
answer
49
views
LWC looks different in prod environment
Hello guys I made a LWC form embebed in an Aura component in my scratch org and deployed to the production environment. When I was testing two things happened.
The first one is related when I scroll ...
user128393
0
votes
0
answers
84
views
How to decode validFor for dependent picklists in Python?
According to this question, validFor="AAAI"should translate to 000000 000000 000000 001000.
With the following function I get 10000010100000101000001010010010 however. What is the problem?
...
- 123
-1
votes
1
answer
126
views
Get all inactive values from a picklist to change api names successfully
We are trying to change the API names for picklist values in the "Industry" standard field on the "Account" object.
Unfortunately, we are encountering an error message that says &...
- 1,147
0
votes
1
answer
156
views
Checkbox formula two picklist fields
I am working on a formula checkbox field that should flag true if 2 picklist fields (each on different objects) are the same:
IF(
ISPICKVAL(Child_object_picklist, "Child_object_picklist__r....
- 3
0
votes
0
answers
29
views
Custom field value as null when going from apex to aura callback
I'm working on some updates on a custom development implying an aura component.
Some users have reported an issue that now they don't see a custom field value being filled on the lightning:...
- 877
0
votes
0
answers
141
views
new custom field visible in view mode but not in edit mode in classic
I created a new custom field in a custom object in classic (picklist). The field is in the page layout and has all permissions and visibility given. It can be seen in view mode but disappears when I ...
- 1
1
vote
2
answers
2k
views
PicklistValueInfo does not returns Custom object's picklist records but only returns standard object's picklist records
So i executed this below query and it successfully returned records,
SELECT DurableId,EntityParticleId,Id,IsActive,IsDefaultValue,Label,ValidFor,Value FROM PicklistValueInfo where EntityParticleId = '...
- 461
0
votes
1
answer
52
views
What is the best way to get picklist schema in LWC
I am trying to fetch multiple picklists to show on LWC components. I am seeing many examples to do this using getPicklistValuesByRecordType from 'lightning/uiObjectInfoApi' and few examples by ...
- 29