You need to sign in to do that
Don't have an account?
PandaX
Formular Field including auto number
I want to create a Field with the following output format:
X-TTTT-NNNN
X will be just the X character.
TTTT should be the value I take from another Field of the same object (until now thats super easy)
NNNN should be a number that is unique for the TTTT value (for example this TTTT could be a Store or Location)
The number as awhole schould be unique in the entire system, without any reppetitions.
How would I implement the NNNN part?
I would say store all of these information in three different fields.
1) First X is a field named Field__1__c
2) Second one looks like you got it already and store it inside the Field__2__c
3) Now, for the Field__3__c I would say create a Auto Number field with for the four digits.
Once, done create a formula field named Final_Field__c = Field__1__c + "-" + Field__2__c + "-" + Field__3__c
Hope this helps!
That in fact does not solve my problem. But I was not really clear about it:
The NNNN part of the number should start at 1 for every TTTT Example:
BR01-0001
BR01-0002
BR01-0003
BR02-0001
BR01-0004
the TTTT part could be taken from a field like you suggested. But how can I reference that for the NNNN part, so it will start again for a new TTTT identifier?