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
5
votes
2answers
341 views

Picklist value with “Like”

I have to select a value from a pick list having values starting with 'PR' I have tried ISPICKVAL(Order_Type__c, 'PR%') But I am not able to use expression Like or wildcards here.
5
votes
3answers
3k views

Why do some picklists (dropdowns) have an empty --None— value, and others do not?

I'm looking at a form on Salesforce that uses a custom object. The object has picklist (drop down) values that are showing an optional --None-- selection. Most of the drop downs have the --None-- ...
5
votes
1answer
2k views

How do I compare a formula field with a picklist in a Validation Rule?

I have a custom object with a formula text field on it pulling from the master object. I have a picklist field and upon saving want to check that the picklist value chosen matches the formula text ...
5
votes
2answers
1k views

Replacing the Picklist old values into new values?

We have a requirement to updated the picklist values to new values. We are doing it via "Replace". Whenever we do this, will the updated record fire Apex Triggers, Workflow Rules, etc.?
5
votes
1answer
1k views

Are State and Country Picklist values enforced for data inserted through the API?

We are going to be turning on State/Country picklists soon for Leads and Accounts. There is currently a process for us in place that inserts new Leads using the SForce SOAP Api). Data that is ...
5
votes
1answer
3k views

How can I add list custom settings into an existing picklist data type in visualforce?

I created a list custom settings, and I need to add this into an existing picklist in my visualforce page. I know how to display this list custom setting as a drop down in visualforce page, but I don'...
5
votes
1answer
2k views

Get picklist values in apex in the order they were entered

I want to get the picklist values of a picklist field in Apex. I use the someFieldResult.getPicklistValues(); function and that works fine. This gives me all the picklist values, in alphabetic order (...
5
votes
1answer
5k views

How do I write a formula using a picklist and a date field?

I have a picklist field for "Interview Applicable" with the choices being "Yes" or "No". I also have a date field for "Scheduled Interview". I have a third field that is a text field. I'm trying to ...
5
votes
3answers
6k views

Get Picklist Values based on Record Type

Am designing a JQuery AutoComplete search box in visualforce page and getting the data source from controller class from two picklist fields(Controlling and dependent). The autocomplete search box ...
5
votes
1answer
2k views

How to populate picklist values in Lightning Componets according to the metadata definition?

In Visualforce, we didn't thought much about picklist-values (=options) on simple CRUD UIs - they where simply there using an <apex:inputField ... /> Now in Lightning I found this documentation ...
5
votes
1answer
2k views

Describe not returning Inactive picklist values via API

I'm using Partner API to describe salesforce schema. For some reason, in picklist fields I only see the active values (although there's a field "getActive()") Is this a limitation or am I doing ...
5
votes
2answers
61 views

Codes and Values

We have clients that use a lot of codes in their day to day activity. Eg: Take a look at the UK Government Common Basic Dataset: https://www.gov.uk/government/publications/common-basic-data-set-cbds-...
5
votes
1answer
295 views

Replacing values in standard fields

Is it possible to have only 4 values in type picklist field of account. I am trying to replace this values but not sure how to do it. Similar is the case for Industry picklist on account object
5
votes
5answers
2k views

Auto populate picklist when creating a opportunity

We have a country and district text field on the User object. We have country and district pick list field on the opportunity object. When a user creates a new opportunity, the very first time, we ...
5
votes
3answers
4k views

Creating record in visual work flow for each selected value from a multi select picklist

I have a Screen in my visual work flow containing multi-select picklist with dynamic options (records of another custom object CustomObj1). And CustomObj2 looks up to CustomObj1 in the data model. ...
5
votes
3answers
518 views

picklistsForRecordType in REST API

Version 29.0 of the REST API includes an attribute for picklistsForRecordType in the response to /sobjects/<object>/describe/layouts, but it appears to always be an empty array. Is there a way ...
5
votes
1answer
497 views

How can a single item picklist for a lead be mapped to a multi-select account picklist

It is a long story as to why (related to our sales process and marketing automation system), but I need to figure out a way to map a single select picklist in a lead to a multi-select picklist in an ...
5
votes
1answer
1k views

Describe/use picklist values in specific language, not the User's language

This Salesforce org includes English and Italian versions of field labels and picklist value labels. This works find within the UI, and for most purposes. However, we have a custom CSV upload page ...
5
votes
1answer
76 views

sObject describe metadata showing duplicate picklist value entries

I'm doing some code generation based on the standard org sObject metadata. As part of that process I'm using the DescribeSObjectResult.fields.picklistValues PicklistEntry records to determine which ...
5
votes
1answer
925 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 ...
4
votes
1answer
15k views

How can we make ui:inputselect in lightning to dynamically get values from an object's picklist options?

I have a requirement to create a Lightning component that contains a ui:inputselect tag which will automatically fetch out its options from a custom pick list of an Object. How can this be achieved?
4
votes
2answers
6k views

Check for a picklist value using SOQL

I have the following SOQL and I only need values from Risk__Actions__r WHERE Risk__Status__c(Picklist) equals to 'Open'. But current way i'm doing displays an error. no viable alternative at ...
4
votes
1answer
889 views

How to Enable State and Country Picklists?

How to Enable State and Country Picklists? The documentation says: Your Name | Setup | Data Management | State and Country Picklists. However, I can't see it under Data Management. Type: ...
4
votes
2answers
8k views

How to populate lightning:select with picklist field values?

Everything I have read online so far suggests that one must manually declare picklist (option) values when creating a lightning:select component in an Lightning application. For us, this is less than ...
4
votes
4answers
5k views

Adding/defaulting a null value to a selectlist on a Visualforce page

I am creating a VF page that basically has different "pages" that each have different questions on them. Each "page" is a different outputpanel that is rendered depending on clicking a Continue or ...
4
votes
2answers
4k views

How to update picklist using REST API

Would anyone have an example on how to update a picklist? I have a System Custom Field that I want to append add new items to as it comes up. The details of the field are the following: Field Label:...
4
votes
2answers
7k views

Salesforce picklist hide none value

I'am creating a standard picklist field with values "None" and "Yes" but when I see on the detail page while creating a record I see two none values in the picklist , one defined by me and other ...
4
votes
1answer
7k views

REST API: How to insert values for picklist and lookup field types?

Introduction Hello, I'm working on synchronising data from a MySQL database into Salesforce using the REST API. I've got as far as inserting basic text values, but for complex field types such as ...
4
votes
3answers
7k views

Dynamically display picklist values based on Record type in vf page

I am having two record type "Record Type 1" and "Record Type 2" on case object. In this two record type we are a having a picklist field call state__c. In Record Type 1 State__c values are "A,B,D" In ...
4
votes
1answer
4k views

Salesforce: Validation using two Picklist Fields

I'm trying to create a validation rule formula in Salesforce, that uses two picklist fields. If the first is picked as New Account, and the Second is Not Selected, then a validation rule appears: ...
4
votes
1answer
2k views

How can I have a dynamic picklist that gets updated when the new value is absent?

I need to create a picklist field, that will have an option to add values that are NOT in the original list. The values are coming from a SF form. If you add the new data today, it is inserted, and ...
4
votes
1answer
7k views

How to display Picklist Label, instead of Picklist API in a Formula Field

I think the title says it all, we are using picklist values having different Label and API Name. How can I display the Picklist label instead of API in when using a formula field. I know I can use IF ...
4
votes
1answer
2k views

soql picklist toLabel apex

I want to get label of picklist from soql and use it in my apex code to do some logic. For example following code gives me error Compile failure on line 7, column 18: Invalid field labelType for ...
4
votes
1answer
4k views

How to use IF Statement in Formula field for checkbox

I want to copy data from one field in another if checkbox is true, I know I can do it by trigger but I want to do it in formula field, I don't know how to check the checkbox field my code is like this ...
4
votes
2answers
2k views

Multivalue picklist default to multiple selections

Is this possible? I see the ability to select a single value as the default, but can I select say 3/5 values as the default?
4
votes
1answer
3k views

Lightning Datatable Picklist and Lookup Work Around [duplicate]

I am aware that lightning:datatable does not support picklists. The approved attributes are: action boolean button button-icon currency date date-local email location number percent phone ...
4
votes
1answer
898 views

How can I “close” a Task from the REST API/Apex

Since all picklist values for the Status field on Tasks are configurable I don't think I can simply set the Status to "Completed" as that picklist value could have been deleted/renamed. I tried ...
4
votes
2answers
5k views

Picklist values for Master record type

Our Salesforce org is largely vanilla, out of the box design. We use the Standard Object Contact with no modifications. Now we have an app that is going to use Contact in a slightly different way ...
4
votes
2answers
601 views

Will trigger fire if global picklist value is updated?

I have a global picklist that I use for a reference object. When a record is created it queries this reference table and populates a different object that functions as a warehouse with the value from ...
4
votes
1answer
9k views

Error: “Picklist value in picklist not found” while deploying using ANT

on my account object, I created a picklist field - testPicklist1__c. The picklist field has various values in it. One picklist value is "abc t" & its API name is "abc". I retrieved the Account ...
4
votes
1answer
4k views

Deactivate vs Delete picklist values

I am quite confused over a question. I know, basic difference between the "Deactivate" and "Delete" i.e. if I deactivate, then I will be able to activate again and my old records also not impacted, ...
4
votes
1answer
1k views

Why do some leads have a 'lead source' value which is not in the picklist?

I just inherited a salesforce account from a previous owner, which is integrated with a number of custom forms and services. I'm not clear on all of the details to be honest, but I think this is a ...
4
votes
1answer
767 views

Is there a good way to “untranslate” picklists in Apex?

The project I am working on supports many languages and Case record types. There is also a large amount of dependency between the Case record type and the Case type field (but it isn't one-to-one and ...
4
votes
1answer
4k views

How to Populate values to textboxes dynamically on Picklist Selection Change in Standard page layout

Is it possible to populate values in textboxes(fields of object) dynamically on Pick list selection change in Standard page layout's edit screen. Something like that if Picklist's value = "AB" then ...
4
votes
4answers
236 views

How to translate “Closed” in Opportunity?

How do I change the textual value of 'Closed' to "I like cheese" in English, and 「チーズが好き」 in Japanese? "Closed" isn't an actual stage, so it's not in the "Stage" picklist translations: And I've ...
4
votes
2answers
10k views

onchange event listener for ui:inputSelect not working

I am trying to implement a picklist using the Aura component <ui:inputSelect> with a change event listner. But I see that the change event listener (JavaScript function) is not getting ...
4
votes
1answer
1k views

What to consider in converting picklist to look-up relationships?

A client currently has a number of Task Record Types that have picklists. The picklists are typically related to accounts of a given RecordType. In some cases, they're lists of child accounts that ...
4
votes
1answer
317 views

How to stop a picklist from being controlled by record type?

So we have been working with one master record type for a long time, where adding values to a picklist at Object level simply made the values appear automatically where that picklist was used. ...
4
votes
2answers
784 views

Adding new values to Custom Picklist (PHP Toolkit)

I'm using the PHP Toolkit for integrating a web application with my Salesforce account. I have this custom object: Individual__Choice__c that contains this custom Picklist: Primary_Option__c This ...
4
votes
1answer
1k views

AggregateResult for a multi-select picklist

I am doing an AggregateResult SOQl query on different picklists on a Contact. List<AggregateResult> results = [select LeadSource, COUNT(id)cnt from Contact where LeadSource != null group by ...

1
2
3 4 5
19