Skip to main content

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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
41 views

Mass Delete picklist value (Not Manually)

We have multiple question on this topic but I didn't get any answer to mass delete the Picklist values at once. Most of them are old and I do not want to go for manual approach as there are almost ...
Aarya Tiwary's user avatar
-1 votes
0 answers
28 views

Understanding logic of date formula calculation

Please help me understand the logic of this calculated formula. The resulting datatype is Date. I believe the reasoning for some of the MOD() and FLOOR() functions is to consider business days vs. non-...
mivve's user avatar
  • 1
0 votes
0 answers
18 views

How to Create and Update Global Value Set and Picklists by APEX? [duplicate]

I Want to create Global Value Set and Picklists via apex, gone through some internet sources but didn't get any of them working for me. Any kind of help is appreciated. Thank You
Sahil Tatkare's user avatar
0 votes
1 answer
25 views

Having difficulties hiding a picklist value with a Custom permission and a Validation rule

I need to be able to hide one picklist value from a field on a Custom object from a set of users. I've created a Custom permission (View All Statuses), and a Permission set to assign to users who ...
Уляна Лозанчин's user avatar
1 vote
1 answer
39 views

Move standard picklist values using SFDX - 2024

This same question was asked 6 years ago and on May 7th 2019, @Felipe Echanique Torres posted this SFDX command: sfdx force:source:retrieve -m StandardValueSet:CaseType I'm doing some work for a group ...
PierreD's user avatar
  • 23
0 votes
0 answers
58 views

reactive picklist

does anyone know or have already made a reactive picklist? When you select the value of the field, another value is shown in the other. In this case, show the value of the product chosen from the ...
Edgard Batista's user avatar
8 votes
1 answer
207 views

Picklist field returning values instead of API Names in SOQL after Summer '24 release in sandbox

We have a query in similar format SELECT COUNT(Id), toLabel(Picklist_Field__c) alias, Picklist_Field__c FROM Account WHERE Id = 'acct id' GROUP BY Picklist_Field__c ORDER BY Picklist_Field__c The ...
Borz998's user avatar
  • 101
1 vote
1 answer
210 views

Can I use "Get Records" and "contains" with multi-picklist values in a flow?

I've designed a screen flow where the end user can select multiple values from a picklist. Consequently, I have created a Picklist choice set to capture this data and utilize the selected values to ...
Salsstars's user avatar
3 votes
1 answer
58 views

Add Hover Functionality Popup to Extended LightningDatatable

I'm a bit stumped here and hoping someone can help with this. There's a lot to unwind but I wanted to include everything in this post. I've got the following LWC setup to display contact roles ...
mcg123's user avatar
  • 71
1 vote
1 answer
39 views

How to sort newly created Picklist Choices?

This is a very frustrating problem because I feel I am using the proper methods but just not getting the results. I'm trying to sort this picklist I'm creating through Tooling API. I am using the ...
Zoom_v's user avatar
  • 3,894
0 votes
0 answers
21 views

Picklist Choice Record Type visibility controlled by Tooling API

I'm updating picklist choices by using Tooling API callouts to the User object, pulling in user names based on their Role. This was working great (thanks to some great help from people on here). But ...
Zoom_v's user avatar
  • 3,894
1 vote
1 answer
69 views

Using Tooling API Lookup To Update Picklist Choices

I'm trying to using a scheduled Tooling API Apex class to lookup Users with a specific Role and update the picklist choices with those results. As it is now, I'm not getting any results. In the debug ...
Zoom_v's user avatar
  • 3,894
0 votes
1 answer
59 views

Checking if picklist value is blank to start a flow

I'm trying to create a flow that will look to see if a picklist value field is blank. If it isn't blank then it should not update the field but if the field is blank then it is ok to the write the ...
SFPatti10's user avatar
1 vote
1 answer
37 views

Is it possible to know that a picklist field is sorted alphabetically?

For a picklist field it is possible to order the items alphabetically. For this to apply navigate to the picklist field in Object Manager and choose Reorder, like shown in the next image. Than select ...
PieterJacob's user avatar
0 votes
1 answer
44 views

Lookup (Picklist dependency)

Our system has a Case object which has a Service field and Unit field. The Unit field is a lookup (picklist dependency) of the Service (picklist) field. At present our agents have to use the search ...
Leona Longden's user avatar
0 votes
1 answer
41 views

How can I mass activate inactive picklist values?

How can I mass activate inactive picklist values? I have over 30 inactive picklist values which I would like to activate. Currently I can't retrieve them using Metadata API or other means. I tried to ...
Patlatus's user avatar
  • 17.3k
5 votes
1 answer
81 views

Different country and state picklists in paid orgs vs scratch orgs

Why the list of country and state picklists are different in different organization? When we retrieve values from sandbox or production org we have values like Chinese Taipei instead of Taiwan on ...
Patlatus's user avatar
  • 17.3k
0 votes
1 answer
58 views

Opportunity stage closed with 2 depending picklists - only one shows up

I would like to specify the closed reason for opportunitys (either won or lost). Therefore I created a depending picklist "close reason" for the closed stage. Now I want another picklist ...
Alex M.'s user avatar
  • 55
-1 votes
1 answer
34 views

Validation rule for Multiselect picklist

I have an issue with a Validation rule. A Picklist field abc if equals =Salesforce, then field xyz (multiselect picklist) becomes visible. It can't be left blank. I tried everything isblank with text, ...
Keya Priyambada's user avatar
0 votes
0 answers
32 views

I need the Values of a picklist in a LWC and not the API Name with JS

as with all my posts I hope you are well. I have the following doubt: I am working with lwc and I need to have the description of a picklist when executing the onchange event. This is my code: LWC: &...
Felipe Peña's user avatar
-1 votes
1 answer
88 views

New Picklist Values not showing in Flow Builder

Trying to set up a Flow using Flow Builder but it isn't pulling through the latest picklist for Task>Subject (any task subject added today via Setup isn't showing). I'm able to use the new picklist ...
johnnyboy's user avatar
0 votes
0 answers
129 views

Lightning Input combo-box with new attribute role not working in my org

Trying to implement the new spring release update: b) The lightning-input component receives a new attribute called role, enabling the creation of accessible combo boxes. Check out the below example ...
Virgo27's user avatar
  • 19
1 vote
0 answers
50 views

Picklist Default Values Inconsistency across New Case

We're encountering a perplexing issue in our Production Environment regarding a Picklist named "Workflow Step." Specifically, within a Record Type titled "System Issue," the ...
Somya Tiwari's user avatar
0 votes
0 answers
63 views

Join two different picklists on value

I want to join two picklists on Value (Country) to have a result like below because I noticed that for some Markets one of the picklist values is missing either IsoCode2 (Aruba) or IsoCode3 (Bonaire). ...
surfmuggle's user avatar
0 votes
1 answer
60 views

SOQL - Relationship extract json from child object and join picklist label

This soql SELECT Id, Name, (SELECT CountryISOCode__c, Name, Role__c FROM Person__r) FROM Market__c returns a row that looks like this: Id NAME Person__r a081.. C1 [{"A":"foo", &...
surfmuggle's user avatar
0 votes
1 answer
304 views

How to select the default picklist value for lightning-combobox in lwc?

For a picklist field, it is possible within Object Manager, to select one picklist value as the default value, so that for new records this field is automatically selected in the dropdown. I want to ...
PieterJacob's user avatar
0 votes
1 answer
129 views

How can I create a Field Dependency between a Picklist and a Text field; Text field is dependent on the value selected in the Picklist?

How can I create a field dependency, where if the user selects the 'Other' option from the picklist field, a corresponding text field named 'Other' should dynamically appear for them to input ...
Sham Hiruthik's user avatar
0 votes
2 answers
36 views

Create a validation rule that checks that Warranty picklist field is not blank, when status = Containment Acheived / Root Cause / Corrective Action

AND (ISPICKVAL (Status, "Containment Achieved / Root Cause / Corrective Action / Preventative Action / Closed"), OR (ISBLANK( Warrantyy__c ) ) )
Vrinda Gohil's user avatar
1 vote
0 answers
69 views

Picklist values aren't matching in row level formula

In a lead report, I have a row level formula called 'Industry Grouping'. The formula for this field is: IF(TEXT(INDUSTRY) == "Candy and other Confection", "Candy", "Other"...
Jeff Purcell's user avatar
0 votes
1 answer
260 views

Default Value in Picklist

on salesforce, I have a picklist type field which contains three values: (1, 2, 3) But the value - None - disturbs all users. I set the value 1 as default when creating but I still have the value -...
laila19's user avatar
  • 21
0 votes
1 answer
33 views

Record type specific default picklist value is not populating in VF Page

My vf page(custom controller vf page) has picklist field in it and I am showing it with apex:inputField tag, as per the salesforce documentation, apex:inputField should show record type specific ...
Jagadeesh's user avatar
0 votes
1 answer
324 views

Formula Field Case Statement that is dependent on a picklist value

I am trying to edit a formula field and make the Case Statement dependent on the value of a picklist, namely an account TYPE. I know an IF statement takes 3 arguments, but the following is the gist of ...
Bill Beatty's user avatar
-1 votes
1 answer
125 views

deleting inactive picklist values

I want to delete inactive picklist values and while deleting I want to replace them with the new value. Does it cause any data inconsistency ? For ex I have inactive (NEWJERSEY) value that is also in ...
user avatar
1 vote
1 answer
34 views

Collection Filter formula unable to use TEXT() to convert Picklist value to Text value

Receiving unexpected error when debugging a subflow that uses a Collection Filter with formula referencing a picklist using TEXT(). Oddly enough, this validates successfully inside the subflow, but ...
Rebekah Oakes's user avatar
0 votes
1 answer
307 views

Fetching mulitiselect picklist values for <lightning-checkbox-group>

I'm using getPicklistValues to fetch the multiselect picklist values in LWC and using it for <lightning-checkbox-group>. But it is not showing anything. And if I use same code for <lightning-...
Ruturaj Chothe's user avatar
0 votes
1 answer
43 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 ...
Hasan Zubairi's user avatar
1 vote
0 answers
161 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 ...
NickJ's user avatar
  • 680
0 votes
0 answers
205 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 ...
Tzinm's user avatar
  • 21
-1 votes
2 answers
175 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 ...
Aswini B's user avatar
0 votes
1 answer
48 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 ...
Ângelo Rigo's user avatar
0 votes
0 answers
65 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-...
vctqs1's user avatar
  • 95
-1 votes
1 answer
201 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 ...
vctqs1's user avatar
  • 95
1 vote
0 answers
113 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 ...
Eduard's user avatar
  • 5,181
0 votes
1 answer
154 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 ...
Shyamala Varadharajan's user avatar
-1 votes
2 answers
121 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 ...
Rebecca Green's user avatar
-1 votes
1 answer
19 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 ...
Laurie Abbott's user avatar
0 votes
0 answers
47 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 ...
Pam's user avatar
  • 1
-2 votes
2 answers
67 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 ...
nrw2631's user avatar
0 votes
0 answers
99 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 ...
Lakis Juzwa's user avatar
-1 votes
1 answer
117 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, ...
Scott R's user avatar

1
2 3 4 5
23