I am hoping someone can help.
I need to get the first 3 chracters from each of the below fields to create a Identifier for the record, is this something that someone can help with ?
Site__c (Picklist Field) & Client__C (Picklist Field) & Name (Auto Number Field)
10 Antworten
You can use Upper function like this:
UPPER(
LEFT(TEXT(Site__c),3)&
LEFT(TEXT(Client__c),3)&
)
LEFT(Name,3)
