Create a unique name attached to a record/field


I'm creating a database that will potentially have the same names in a record (bob, jane, tom, etc). Is their a way to create a unique combination of characters that will be associated with that name?

For example Bob (AFG-2678934)

I saw the article on how to create a random ID but I dont know how to add a prefix to it or how to show it with a name.

thank you. i will give it a try. i wasn't sure if it would let me put in multiple data.


I'm not an expert - so take my reply with more than a grain of salt..

But maybe try a text formula like

{Name} random(6)

.. I know it's a simple reply heh.. but hope it helps..