Changing the number field format with BR

[Singularity]

Hi,

There is a "number" field on every table which is a generated ID like INC00001.

There has been a requirement to change it to different formats based on the type of the record, e.g. if type is A then A-INC00001, if type is B then B-INC00001 and so on...

Do you think it is safe to update the number field to the desired format with a simple before insert BR? Could it lead to any problems?

Are there any other better/cleaner ways to achieve this?

[Tony Chatfield1]

Hi, I suspect your biggest issue could be user reporting\searching as the Incident table numbering is no longer consistent across all records, and I would not recommend this as a best practice solution.
Can you clarify the business requirement\use case?

[SanjivMeher]

I don't think, thats a good idea. 

I would suggest extending the Incident Table instead of using scripts to name them.

You can extend the table into types of incidents and have different prefix. That way you dont have clash between the different types of incident. In the long run you will also have option to add different Business Logic for each type of incidents if thats the plan.