Timeline for Formula: BlankValue function with CASE function
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 15, 2013 at 22:34 | comment | added | Andrew Fawcett | I bet a page to format formulas like jsonlint.com would go down well in the community? Better still a browser plugin... ;-) | |
| Nov 15, 2013 at 21:24 | comment | added | TamaraU | Thanks! I think I got the case function, but it only seems to work with the first expression of the BLANKVALUE. The purpose of using the BLANKVALUE is because I'm comparing values from a picklist (Nombre_de_la_Entidad__r.Type) and its depending picklist (Nombre_de_la_Entidad_r.Subtipo_c) | |
| Nov 15, 2013 at 21:09 | comment | added | Scott Pelak | hmmm, i'm not sure if my code makes business sense. the basic jist of getting it to work is in my answer though | |
| Nov 15, 2013 at 21:07 | comment | added | Scott Pelak | yup, edited. i missed the end of the first CASE and had to lookup BLANKVALUE to make sure the parameters were correct. | |
| Nov 15, 2013 at 21:06 | comment | added | Mike Chale |
@amatorVitae: I think there's one other thing here: The first case shouldn't have the -; shouldn't its default value be the second CASE? If Subtipo_c is blank, it returns -, and then Blankvalue returns -.
|
|
| Nov 15, 2013 at 21:04 | comment | added | Scott Pelak |
I can't believe it took em til Winter '13 (?) to get a monospace font for formulas
|
|
| Nov 15, 2013 at 21:03 | comment | added | Andrew Fawcett | Ah I do wish Salesforce would have a "pretty print my formula" button! :) +1 | |
| Nov 15, 2013 at 21:02 | history | answered | Scott Pelak | CC BY-SA 3.0 |