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개
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)
