You need to sign in to do that
Don't have an account?
sparky
formula based on Record Type?
Can a formula take Record Type into consideration? (for
Opportunities, for example). It seems like a pretty basic thing,
but I don't see how to do it either in the formular builder UI or in
the documentation I've been able to find so far.
Thanks!
Thanks!
Steve Bower
I don't see Record Type in the field selector, and the formula builder doesn't recognize {!Record_Type}.
I don't see any programmatic way of doing it using a built-in "{!...} string, but perhaps (and I stress "perhaps" because it's even later in the evening than it was when I first responded :-) ) you can do it with a backdoor somehow.
I haven't tried this completely, but could you create a read-only picklist field for Opportunity which you will use as a proxy for Record type by selecting a different default value for the picklist selection for each type?
Then you could query the value of that picklist field with the {!xxx} construct as a proxy for the record type?
Just a thought. Now it's time to go to sleep. Good luck, sorry for my "{!Type} digression.
Steve.
What I don't know is: can I get that picklist field to populate even if it's not on the layout used to enter the Opps?
(I can of course test this, but if anyone wants to save me the trouble...)
In any case, I actually don't want the users to be able to do that. The record types in this case will be different enough from each other that I won't want them morphing from one to the other.
So you agree that there's no way to reference record type directly in a formula?
Thanks!
The change to record type works like the change to the owner ... via a link on the display (not edit) page. This presumes, of course, that you've put the record type field on the page layout.
I don't see any way to reference the record type directly in a formula.
The previously suggested custom picklist ... with a different default (and only) value for each record type .. seems the best alternative, particularly if you won't be changing record types.
I did verify that a picklist set to default based on Record Type will be populated even if the picklist field isn't on the layout used by a particular record type.
Also, as a further workaround if I want to display the record type but not allow my users to change it: I can create a formula field set equal to my picklist field and display that in lieu of Record Type.