Changing a Number Prefix for New Records

[ASB1]

Hi all, 

I am starting my work as a Solution Architect to integrate solutions with ServiceNow. 

Reviewing the current solution/code I have found one custom table (task type) auto-numbered with the prefix  'ACT' (set like this in the table definition)

This table is fulfilled from a record producer, but depend on the value of a field in the producer, the prefix will change.

So in this table will exist records numbered

EGE000001

EGE000002

DIA000003

EGE000004

DIA000005

........

HPC000111

EGE000112

I found that implementation a bit unweird. So I would like to ask in the architecture forum (or any other appropriate that you consider) if you foresee future issues in this solution.

Thank you in advance.

Ana (ASB)

[AnubhavRitolia]

Hi @ASB1 

To achieve this, you can create your Custom Field 'Number' and hide OOTB 'Number' field from your form. 

Now using Record Producer, you can update the new 'Number' field value based on requirement. Now use this 'Number' field only everywhere for your table.

[ASB1]

HI @AnubhavRitolia

We have already implemented that. It is in place since a couple of months. 

My question was about if anyone foresee problems in the future.

Might be it is an usual practice, but this is the first time I have found it. Same table with different prefix.

Thank you.

Ana

[AnubhavRitolia]

As you mentioned, it is Custom Table, I don't think it would have any impact in future. 

Just make sure no Functionality is working on Task table based on the 'number' field prefix. 

Regression testing may be required here.