Auto generated value problem
We have a field that automatically generates a value when a new record is created(this new record is created by an automatic script). We have restricted the value as 4characters followed by numerals. This is a unique key. But the issue is sometimes the value created turns out to be some special character or some value like 'gen' or some 'q', or ` all. because of this lot of issues are occuring since this is one of the most imp value. Please help us how to avert this.
Creating an Id in this manner for a relationship key id is not recommend. You don't give enough information how the script or id is used and you also need to post a copy of the script.
A auto-enter serial number calculation can create a serial number with letters and numbers. You can also use Get(UUID) to create unique id numbers.