I would like to know if is possible to create unique documentnumbers based on input in coloumns. Or more important the opposite, prevent that a number is used twice.
Projectnumber will always be the same, drawingtype 1 will/might be different, drawingtype 2 will/might be different, area code will/might be different and so on. Within the different combinations of metadata I want to make sure that the serial number is not equal to serial numbers used before.
E.g.: Many 3D drawings will be generated through the project, many HP drawings will be generated through the project with same area code, same system, same originator. The only way to separate them from each other is the serial number.
Is it possible to generate unique numbers taking the above into account?
Help Article Resources
Check out the Formula Handbook template!