I am trying to store a unique 5 digit identifier to each new Supplier that is added to our database. I have tried a couple of ideas to no avail…
Tried building 2 custom workflows that generate random numbers that loop into each other until a unique number that has been checked against the database is provided. However, this creates a bubble system error which makes sense, as this could eventually become recursive.
Setup a simple when condition is true workflow (suggested by @emmanuel in this thread here) - set to every time - that searches the database for any duplicates and spits out a new number using Calculate RandomString each time… problem is the conditional is running 1 time then stops…
Any ideas or possible better solutions for what I’m trying to accomplish?
P.S. I am testing with just 1 digit so I can find duplicates within 10 attempts or less