How to generate unique no while adding new records

Ah! My apologies for misunderstanding your initial question.

I think @Robert_Petitto has created a video to address your issue exactly:

Custom & unique user codes

3 Likes