Hello, I have a field which I need to generate a unique number into.
I haven't got a clue how to start that formula. So I am trying to base my calls of ticket numbers. and I am not sure if there is a formula that will generate unique numbers, that wont duplicate them.
The best unique number is the [Record ID#]! If for some reason want to start at a certain value, for example sometimes people want to have say a 4 digit number, then the best way is to import a bunch of dummy records using Excel and then delete the records. But don't run past your Target records start # as there is no rolling back of the number.