# Create a unique name attached to a record/field

**URL:** <https://forums.knack.com/t/create-a-unique-name-attached-to-a-record-field/7116>\
**Category:** Get Answers\
**Created:** [April 19, 2018, 5:12pm UTC](https://forums.knack.com/t/create-a-unique-name-attached-to-a-record-field/7116 "2018-04-19T17:12:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikeSidnam84156](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@MikeSidnam84156](https://forums.knack.com/u/MikeSidnam84156)\
**Post date:** [April 19, 2018, 5:12pm UTC](https://forums.knack.com/t/create-a-unique-name-attached-to-a-record-field/7116/1 "2018-04-19T17:12:59Z")

</div>

Hi,

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.

---

<div class="post-metadata">

**Author:** ![MikeSidnam84156](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@MikeSidnam84156](https://forums.knack.com/u/MikeSidnam84156)\
**Post date:** [April 20, 2018, 7:33pm UTC](https://forums.knack.com/t/create-a-unique-name-attached-to-a-record-field/7116/2 "2018-04-20T19:33:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![TingLing03337](https://avatars.discourse-cdn.com/v4/letter/t/9e8a1a/32.png) [@TingLing03337](https://forums.knack.com/u/TingLing03337)\
**Post date:** [April 20, 2018, 1:44pm UTC](https://forums.knack.com/t/create-a-unique-name-attached-to-a-record-field/7116/3 "2018-04-20T13:44:06Z")

</div>

Hi,

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..