You need to sign in to do that
Don't have an account?
ChrisMcL
Do i use Ischanged?
multiple formulas on one field
Just wondering if anyone has a technique to split up formulas and make them exclusive (one does not overwrite the outcome of the other.
formula: if picklist is a certain value, lookup a number and multiply it by another number field. In real life, the case statement is hundreds of items long. How could I split up this statement into two for example?
I would like to make the multiplication dependent on whether the case statement found a match.
Code:
case(field, "type1", 30, "type2", 50, amountfield) * field2
Do i use Ischanged?
Message Edited by ChrisMcL on 12-14-2007 06:58 PM
That specific solution would require you to add a record to the object when you added values to the picklist. A cleaner solution would be to simply populate the picklist from the object, which is pretty simple to do with Visualforce. Visualforce is only available in Developer Edition at this time.
Hope this helps.
As a partner with Salesforce, we will not be using Apex code until it can be released inside managed packages. But thanks for the idea.
James