Tagged Questions

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.

learn more… | top users | synonyms

1
vote
1answer
12 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 ...
1
vote
1answer
23 views

Validation Rule for Changed Value

I'm working on a validation rule that looks at a certain field to see if the Prior Value of that field contains ".com". The requirement is that users should not be able to change a picklist value if ...
4
votes
1answer
57 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 ...
3
votes
2answers
115 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 ...
1
vote
0answers
11 views

How to use Data Category Visibility in a data category picklist that generated from code

Problem description: I have a picklist for data categories which I am generating dynamically from apex code, currently because I'm doing it from code using Schema.describeDataCategoryGroups and ...
1
vote
0answers
15 views

Picklist refresh taking long time for European Users

Kinda weird issue :) We have three picklists in Case object (Queue/Type/Area). Queue drives Type...Type drives Area. This picklist refresh for Type and Area is quite fast (1-2 secs for users in ...
2
votes
2answers
34 views

Validation Rule Lead Category required based on Lead Source selection

I have Lead Source as a picklist with these options (Distribution Partner, Personal Referral, Event/Trade Show, TBP Event, Website, Other) I have created a custom text field called Lead Category. I ...
0
votes
1answer
24 views

How to match a value in a child record with a parent record field value?

I am trying to create a workflow that allows 2 cross object, custom, picklists to match each other. However, when I create a workflow, there is nowhere for me to add a formula. Not sure if there is a ...
2
votes
1answer
40 views

Set value of a dynamic picklist on VF page load

I have overridden the new Opportunity page with a Visualforce page, which means there are 3 main routes for the Opportunity to be created: From an Account page From a Contact page From an ...
0
votes
1answer
23 views

Set default value for a picklist filter in skuid page

Question I've got a table of search results for a skuid page I'm building and have added a filter for a "type" picklist field. Everything is working just fine, but I'd like to be able to default the ...
0
votes
2answers
23 views

Check if there is any common string in Two List<String>, or in Picklists

I have two multiselect picklists Assume - First__c and Second__c I want to check if there is any common string between them e.g. First__c = 'First,Second,Third'; ...
2
votes
1answer
58 views

Metadata API : How to get the translated values of picklists of my object

Wanna get the translated values of picklists of my object? How can I get them in Apex. I tried using Metadata APi but invain. Can anyone suggest me?
2
votes
3answers
114 views

How can I convert formula to APEX trigger?

I have already exceeded my 5000 compilation code, now I want to create trigger for following formula from custom object. Formula 1 (Custom Field = Package Fee) IF(ISPICKVAL(Package_Option__c,"One ...
1
vote
1answer
90 views

Picklist field in Salesforce 1

I´m building a simple visual force page that is showed only if user get access to Salesforce with Salesforce1 mobile Application. I´m having problems with the picklist: <apex:inputField ...
1
vote
1answer
45 views

How to Populate text field values onto a lookup/picklist?

Subscribe system object has a text field "legacy ID". 1 account can have many unique legacy ID. I have a new object Sub Details wherer I want to populate a picklist/lookup containing all legacy ID ...
0
votes
1answer
53 views

Creating a formula using a picklist and two checkboxes?

I'm looking to create a formula that returns different values depending on whether or not two boxes are checked, but only when a certain picklist value is selected. Meaning if a different picklist ...
3
votes
2answers
84 views

Picklist with different value and name

Is it possible to create a custom picklist field with different value and name. Eg on the page layout Orange,Banana value saved in db 0,1. Thanks
2
votes
0answers
62 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 ...
0
votes
3answers
63 views

Can a trigger be created to take the chosen multi-select picklist values and display them with a number field to add time spent on each choice?

I have a multi-select picklist on a Task record that has about 22 choices for the reps to choose from. They now want to assign time spent on each of the selected choices from the picklist. I don't ...
2
votes
2answers
62 views

Boolean Field v. Yes/No Picklist

Consider two fields with the following types: checkbox/boolean picklist with "yes" and "no" as valid values along with validation that forces one of the two values to be picked, effectively making ...
2
votes
1answer
34 views

How do I deactivate a picklist option in Professional Edition?

I have a picklist on Opportunities called "Demo Set By", which lets us recognize the Sales Development Executive who set up a demo (not the same as the owner of the opportunity, which is the Account ...
0
votes
2answers
54 views

Uploading values into Country,state picklist

Can we upload values into country state picklist under Data Management? If i'm not wrong i think we can enforce the values using workbench.
2
votes
1answer
59 views

problem creating a dependent picklist

I want a user to be able to firstly select a value from a picklist and then to be able to select values in a lookup. For example, if the user selects the value "campaign" from the lead source ...
2
votes
1answer
87 views

Language Translation for picklist values in VF Page

There are 2 picklist fields in my VF page. I successfully translated the whole VF page using custom labels (into Spanish), but the picklist values are not translated. How to translate them? Here's ...
0
votes
1answer
46 views

How we change dependent picklist drop down value to input field value?

i have one controlling picklist Type and value is Hourly and Fixed. If i choose hourly then it show value Rate, Hours per week and Duration. And if i choose fixed then it show Prize and Duration As a ...
1
vote
2answers
169 views

Change field visibility based on Opportunity picklist value

When i select stage picklist value as "Closed Lost" in Opportunity, then i want show text fields. By-default these text fields will be hide. I tried so many ways but i didn't get. tried using ...
2
votes
0answers
63 views

Visual Workflow: Cannot get choices to display properly

I am very new with VWF's and do not have any coding knowledge. I am trying to create a flow where my users can lookup a contact, view the existing information, and then update any changed information ...
0
votes
3answers
102 views

Creating Picklist based on a other text field value

I have a list of questions (150+). Each question has a particular type of answer and some of the answers can be picklists. Now I want to create the response picklists based on the question, how can I ...
4
votes
2answers
67 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.
3
votes
1answer
411 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 ...
2
votes
1answer
46 views

How to remove a picklist from a record type?

I have 10 Picklists Available for Editing for Record Type 1. So how do I remove Picklist X from Record Type 1. I have added a screenshot. I can't find the option to remove a picklist from a record ...
2
votes
1answer
60 views

Prepopulating multiselect picklists in a flow

I have a multiselect picklist on a record. I want to display its current values in a multiselect picklist in a visual flow. But when I tried setting the value of the picklist to a variable and setting ...
1
vote
1answer
34 views

Help with a junction object

I created a rollup summary on opportunity object to count on object 1. If count > 0 then field1= abc else xyz. I tried the following... created roll up count on object 1 created a formula text on ...
0
votes
1answer
42 views

Insufficient Privileges error when changing value of picklist

I have picklist of values Lead and Opportunity, By default value of picklist is Lead When I change it to Opportunity and, if change it back to Lead, it gives error of Insufficient Privileges.
0
votes
1answer
116 views

help with Validation Rule on Multi picklist

I have two multi picklist fields(A,C) and 1 pick list field(B- yes/no). A has 5 values (1,2,3,4,5) and B has 3 values(7,8,9). If user selects value 1 in A and B pick list value is Yes, user should be ...
3
votes
2answers
92 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-- ...
0
votes
1answer
47 views

User profile dependant picklist values

Can I hide/show picklist values in dropdowns dependant on the user profile?
2
votes
1answer
107 views

My Formula is not working in the Reports generation

We have a requirement that need to display the date&time when user select as 'Completed' from a Status picklist filed.I used below formula to achieve this.It is working exactly perfect in the ...
1
vote
4answers
283 views

Trigger to validate selection of Pick-list values

I got an object called 'Category' which has a master detail relationship with 'Scheme' object, 'category' has a pick list field called 'Type' & it has different values Ex:Cost,Time etc. I need ...
0
votes
0answers
20 views

Controlling Field link broken

It seems that the Controlling Field link is broken / disappeared on one of our custom fields I detected this when I wanted to add a new picklist value to a dependent field, and found that 4 of the ...
-2
votes
1answer
106 views

How can I auto populate text on multi select pick list based on the text field in the same object

I have text field (value:abc)on custom object,based on this value "abc" I want to auto populate value on multi select pick list. Thanks Sona
3
votes
2answers
48 views

Possible to use a “list” custom setting on a standard layout picklist field?

I've searched it and found a few things where people have put it as an idea to be voted for a few years ago, but I haven't seen any response from Salesforce on any I've seen, so what I want to know is ...
0
votes
1answer
87 views

Action Predefined value: use picklist value

I am trying to create a publisher action which receives some predefined values. With this action I am creating a new custom object from account. The newly created object has to receive some values ...
1
vote
1answer
95 views

User-defined field dependent on values in picklists, formula needed

I am looking for a solution how to express a formula for an user-defined field with the following description: the formula should show the corresponding letter salutation dependent on the picklist ...
1
vote
1answer
37 views

Detect changes in picklist values

I have an external system which keeps synchronized with Salesforce. I have triggers in every object that send the inserted/updated/deleted records to my webservice, and every minute I send the ...
3
votes
1answer
231 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. ...
0
votes
1answer
86 views

Synchronizing (Add/Remove Items) Pick list with some External source by using Metadata API

By using Salesforce Metadata API, we can retrieve/read the pick list value. We have a pick list, which contains few values which needs to be synchronized with some external items. One solution is ...
0
votes
4answers
65 views

Validation Rule giving me a huge headache

Basically I need a validation rule to say IF field “HasOptedOutOfEmail” is unchecked, and mailing country = Canada, then field Canada_Email_Consent__c needs to be Updated. However the record ...
2
votes
1answer
93 views

Basic Validation rule which has baffled me

Yet again this has simple validation has me baffled Aim – If mailing country = Canada, then Canada_Email_Consent__c needs to be captured, if mailing country not equal to Canada then ...
1
vote
2answers
46 views

Need to create a picklist formula …but the results needs to write to another field

I'm trying to create a formula using a pick list that will render the output of a revenue field based on the method of calculation(Method_of_Revenue_Calculation__c). Here is what I have. I keep ...