If you want an automatically incrementing ID number for your records, use the id() function in a formula like this:

You can alter the formula to customize the ID, for instance:

  • For an ID that starts at 101, use: 100 + id()
  • For an ID that formatted with text, try something like: "order-" + id()
Did this answer your question?