I have a field in Salesforce called RX # Now This RX # can be any length of #.s and or Letters. Right now when the Field is populated It will only show what the user has inputed. So it will look like this.
RX# 5553421
Now their are times that this field is not used.
What I would like to do is to say
If the RX field is populated a - is automaticlly added to the front of the # with a space So it will look like this.
RX# - 5553421
If it is not populated Add nothing and leave blank.
4 risposte
Depending on which edition of SFDC your org is on, and what your requirements are you could do this a few ways. If you are on EE or UE you could create a Workflow Rule with a Field Update. If you're not on EE or UE you could create a custom Formula Field.
If you go the Formula Field route (and that's what it looks like you want from your post). You could create a Text field for the user to enter the "RX number". Then create a Formula(Text) field and use a formula like:
IF(NOT(ISBLANK( RX_Number__c )), "RX# - " + RX_Number__c , NULL)
