Help with Invoice number formula

Well, you have a couple of options: you can either utilise the Public Id field (which is unique and increments each time an entity is created) or you can make an automation rule to write a number field each time an entity is created, and then use ToText on that number when necessary.

Note: due to the way Public Id works, it is not guaranteed to be exactly one higher than the current highest value. See here

1 Like