You need to sign in to do that
Don't have an account?
Daniel B Probert
=CODE equivalent in Salesforce
Hey,
I currently have an excel formula that generates a random code based on the salesforce id.
i'm keen to move this into salesforce but can't find what formula would do the same.
this is the formula - imagine that A2 is the salesforce id.
=CODE(MID(A2,11,1))&"."&CODE(MID(A2,12,1))&"."&CODE(MID(A2,13,1))&"."&CODE(MID(A2,14,1))&"."&CODE(RIGHT(A3))
The mid bit works fine I just can't find what formula I can use for the CODE.
Any help welcomed.
dan
I don't think SF have equivalent function for this.
You can write such, but it will require apex code.