Hi all,
Let say that I have these document class and properties.
Class | Work Order |
Properties |
Work Order No (text) Product No (text) Running No (Automatic Value, integer, increase by 1) |
For running no properties, I configured it as automatic value, integer and increase by 1. However, I wanted the running no to increment if we add new document with same product no. If we add new document with different product no, the running no should start from 0.
For instance.
Document 1
Product No: 111222
Running No: 1
Document 2
Product No: 111222
Running No: 2
Document 3
Product No: 333444
Running No: 1
As you can see on the example above, the running no properties will only be incremented if we use the same product no. If we entered new product no, it will count a new running no for that product no. Does this require some scripting ? Or any ideas without scripting ?