You need to sign in to do that
Don't have an account?
Jeff@TargetX-chg
VLOOKUP Function for data exchange
I am trying to figure out a way to create a lookup that will return a 4 letter code for a description field.
For example, we have a bunch of Majors in a picklist (History, Biology, Chemistry) that have corresponding codes (HIST, BIOL, CHEM). What I would like to do is take the value of the picklist and translate it to the corresponding 4 letter code so we can use the code to do the data exchange. The Salesforce user needs to choose from a picklist of "human readable" descriptions, but the data needs to be manipulated to the 4 letter code before data exchange.
If anyone has any ideas of examples, I would greatly appreciate it.
Thanks,
Jeff
Can you set up another Formula field as a picklist and say:
(Say the picklist field is called Department and you created a custom Formula field called Dept_four_letter:)
Dept_four_letter=
If Ispickval(Department_c,"History"),"HIST",if(ispickval(Department_c,"Chemistry"),"CHEM",etc..
Then when you do the data exchange, you just transfer the Dept_four_letter field
Or... you could say
Dept_four_letter = Left(Departement_c,4)
Then the new field would always = the left 4 letters of the Department field
I don't know if I fully understood if this is what you were trying to accomplish or not....
The only thing I can think of is this:
Have two fields:
1) Field 1= LongDesc
2) Field 2= ShortDesc
You show the user in Salesforce the LongDec and have it as a picklist. Then you set up a workflow rule that updates the ShortDesc anytime the LongDesc field is edited or created. Then when you transfer data to the DB, you transfer the ShortDesc. Then if the data is coming back into Salesforce, the ShortDesc would be coming back correct? So you would then do the same thing and set up a workflow rule that updates the LongDesc everytime the ShortDesc changes.
Therefore, both Field 1 and Field 2 are picklists, but you set up a workflow rule field update that when one is created, so is the other and when one is edited so is the other. The formula exists in the workflow rule, not in the Fields itself.
Would this work?