Salesforce: How to reference a picklist field value and not their API name
Вставка
- Опубліковано 7 вер 2024
- Today's video shows you how to reference a picklist value instead of their API name when creating reference formulas on other objects.
1. Example of how the TEXT formula works
2. Example of how to use the CASE formula
The Problem with this is of course the scaleability. But I think the reason why it is not possible dynamically is because you have to take into account, that picklist value sets can be translated, so the formula would need to show a different value based on the user who accesses its data if this feature would be added to Salesforce. Thanks for the video
Exactly right! For scalability you would likely use a flow to populate the picklist value on another object.
Hey really thanks it helped me☺️ i also subscribed ur channel keep Posting lots of stuff regarding Salesforce
Thanks!
Will picklist value translations also reflect in the formula field correctly by this approach? Can you please show how to get translated picklist values in flow?
This really help me dear ty so much
Great!
Hi, Error: Field Reservation does not exist. Check spelling. Unable to see the availability field for referring the same in other object. Unable to solve this, kindly help. Thanks in advance.
Is there no way to do this dynamically?
I get the feeling this doesn't scale well when picklist are expanded upon and end up having 20+ values (or more).
Sorry, it's just a quick workaround, the only other way would be a flow.
Nice, I got 1500 Picklist values, what to do Julie Demaree?
I would use a flow instead. A formula field would likely hit a character limit and not be worth your time. However, I would question why you have 1500 picklist values for one picklist. That is a lot for any users to sort through to even select.
@@juliedemaree we have a backend systems, so the integration will set this field(Profession) in salesforce, no user need to do anything with this field (only view) . The backend system rules this field, i cannot do anything about it
@@juliedemaree Can a Flow even pass translated picklist values?
I am creating a cab management application in salesforce and there is a requirement is to use formula field for calculating cost per km so how could we add distance to calculate it.Can you suggest something related to it.
Sorry, I would need to understand what fields you are referencing in order to provide a response.
Need help can u....?