You need to sign in to do that
Don't have an account?
David Ovella
How can I automatically save a value depending of the user.name?
I have a picklist call "branch" with 8 values in it and is use for 8 users.
And I want to know:
For example, if I am user: "Maker Villa Morra" I want my picklist save the value automatically "Maker vm", or
if I am user: "Maker Centro" my picklist save "Maker vm"
depending of the user name... how can I do that?
And I want to know:
For example, if I am user: "Maker Villa Morra" I want my picklist save the value automatically "Maker vm", or
if I am user: "Maker Centro" my picklist save "Maker vm"
depending of the user name... how can I do that?
You can use a formula field to return as a text. Then, you can use the case function and expression as $User.Firstname or $User.LastName values are the first or last names and the results are your "Maker vm" or "Maker Cm" depending on the user.
Formula :
CASE( $User.FirstName , FirstName1, Result1, FirstName2, Result2,else_result).
The else_result can be anything as you will not be entering that part of the formula (considering all the first or last names you give are correct and in the org).
Thanks.
All Answers
you can use a text field instead of the picklist, or? So you are able to update the textfield by using a workflow.
Regards
Robert
(mindforce: http://www.mind-force.de)
You can use a formula field to return as a text. Then, you can use the case function and expression as $User.Firstname or $User.LastName values are the first or last names and the results are your "Maker vm" or "Maker Cm" depending on the user.
Formula :
CASE( $User.FirstName , FirstName1, Result1, FirstName2, Result2,else_result).
The else_result can be anything as you will not be entering that part of the formula (considering all the first or last names you give are correct and in the org).
Thanks.