I've a custom auto case-number field for one of my case record type (Quality Report). Every time a new case is created, the auto case number is generated (ex: QR-1287). However, the auto number field is generated even when a case is created in other record types (QR-1288, QR-1289....) . How do I avoid it? I want the auto case number field to update only on a single case record type, the case number should QR-1288 only if the record-type is of Quality Report. Please help.
Autonumber field in SF is the same auto number field you get in the Traditional Database (Oracle,MySQL etc) . That being said as its handled by the Internal Database and not the SF implementation there is no way one can change this behavior.
You can do a workaround,
- Make the name field as Text instead of autonumber
- Create a new Autonumber field you want
- Create a workflow rule, on created that checks the record type and then updates the name of the record using the autonumber field present on the record.