# Concatenated strings as primary keys \[Apr 08\]

**URL:** <https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:54am UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352 "2022-11-03T08:54:51Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:54am UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352/1 "2022-11-03T08:54:51Z")

</div>

> 🙋‍♂️ **Marian** _asked_

## Hi, it is not possible to use concatenated strings as primary keys?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:54am UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352/2 "2022-11-03T08:54:53Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### what do you mean by concatenated strings? like two columns with string type? like composite PK ?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:54am UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352/3 "2022-11-03T08:54:54Z")

</div>

> 🙋‍♂️ **Marian** _replied_

#### Like using a formula column and using concat with 4 columns and make it a PK so i can reference search it

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:54am UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352/4 "2022-11-03T08:54:55Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### oh. in this case you cannot, as formula column is a virtual column.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:54am UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352/5 "2022-11-03T08:54:57Z")

</div>

> 🙋‍♂️ **Marian** _replied_

#### So my best option is to make it via the API and use that column as PK?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:54am UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352/6 "2022-11-03T08:54:58Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/960357597846839352)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [December 7, 2022, 2:07pm UTC](https://community.nocodb.com/t/concatenated-strings-as-primary-keys-apr-08/352/7 "2022-12-07T14:07:11Z")

</div>

Airtable supports formula column as primary value. Do you expect to include this powerful feature in nocodb in the future?