I want to create a field (say Type__c) where I can have an auto-generated picklist depending upon another custom field (say Book__c). This picklist will have a list of values (say A, B, C and D). My requirement is if in a record, Book__c has F, Type__c should have no data, but if Book__c has A, B C or D, Type__c should be updated with the value. Is it achievable from object and field level. Field type of this new field can be changed. Its not specific to picklist.

  • Create two picklist book__c and type__c and make create a Field dependencies on it. – Rohit Mourya Apr 13 '17 at 9:25

You could use a Field Dependency for this. This would mean upon Change of the first picklist, your chosen value will filter the possible values for the second picklist. If you have both picklists created on the object, within the Custom Fields & Relationships choose Field Dependencies and create something similar to the following.

enter image description here

On the record, if you change the value of the PickList2, PickList1 options will be filtered.

enter image description here

You could also consider designing a Workflow to do this if you wish.

  • Thanks for the suggestion. But the Book__c is a text field. I cannot change the field type of Book__c – Salesforce Learner Apr 14 '17 at 5:20
  • Oh, your question states field type can be changed. A Workflow should do the trick for you then. – TSmith Apr 14 '17 at 16:02
  • Thanks for the suggestion. If I create a workflow, how will I call this workflow in angular. we are using angular for front-end and have written a query where I need to call this newly created field/workflow in WHERE clause. – Salesforce Learner Apr 15 '17 at 19:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.