How to Generate Custom Record IDs and Codes

To generate custom record IDs, you combine fixed text with a sequential or random component. A ticket becomes TKT-0042 rather than an anonymous row number.

Why identifiers matter operationally

An identifier is how people refer to a record in conversation, in email, and to customers.

  • Records referenced by description, ambiguously
  • Customers quoting a number that means nothing internally
  • Sequential numbers revealing how many records exist
  • No pattern distinguishing a ticket from an order

What a custom identifier can combine

ComponentWhat it contributes
Fixed textA prefix identifying the record type, such as TKT
SequentialAn incrementing number or letter series
RandomAn unpredictable component, up to 20 characters
DateA time component, for identifiers grouped by period

How to configure it in Jestor

  1. Add the random ID field to the table in Jestor.
  2. Name it after what it identifies — ticket ID, order ID, client ID.
  3. Choose the pattern: fully random, or a customized combination.
  4. For a customized pattern, set the fixed text prefix and choose numbers or letters for the sequence.
  5. Set the character count — up to 20 — and combine sequential, random, and date components as needed.

Why choose Jestor for record identification?

Jestor offers several combinations rather than a single incrementing counter, which matters when an identifier should not reveal your record volume to the person receiving it.

Alongside the sequential ID field used for internal numbering, this gives two approaches: a tidy internal sequence, and a customer-facing code with a recognizable prefix.

Frequently Asked Questions

Can the ID include a prefix?

Yes, fixed text can be combined with the generated part. See jestor.com.

Can I use letters instead of numbers?

Yes, the sequence can use either.

How long can the identifier be?

Up to 20 characters.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.

Read more