# Data validation \[Apr 09\]

**URL:** <https://community.nocodb.com/t/data-validation-apr-09/357>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:55am UTC](https://community.nocodb.com/t/data-validation-apr-09/357 "2022-11-03T08:55:29Z")\
**Posts on this page:** 5\
**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:55am UTC](https://community.nocodb.com/t/data-validation-apr-09/357/1 "2022-11-03T08:55:29Z")

</div>

> 🙋‍♂️ **yallouche** _asked_

## Hello,

#### I’m wondering what’s the easiest way to do some sort of data validation.

#### By linking another record from another table I can choose more than record which is an issue.

#### Worst, those columns don’t seem to appear in the database. I’m guessing it’s some kind of metadata.

#### 

#### Adding a foreign key in postgresql, does give me an error if I add a wrong value in nocodb but no UI around helping picking one.

#### 

#### Any suggestions ?

#### 

#### In general, I’m wondering what the main goal of nocodb? Matching the properties and relationships of the underlying database and exposing them to no-code methods or focusing on the web UI/APIs?

---

<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:55am UTC](https://community.nocodb.com/t/data-validation-apr-09/357/2 "2022-11-03T08:55:30Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### \<@884788718894981192\> Data validations currently rely on underlying datatype supported by database. Any specific validation that you are looking at?

#### 

#### Link to another record - Yes. Information is maintained in NocoDB metadata.

#### 

#### For PG error, please help us with more details. You can raise an issue here ([Sign in to GitHub · GitHub](https://github.com/nocodb/nocodb/issues/new/choose))

#### 

#### About NocoDB- currently we are working to provide power & flexibility of database features in the hands of naive spreadsheet users & to make working with database/ api’s seamless for anyone on Internet, even without programming knowledge

#

---

<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:55am UTC](https://community.nocodb.com/t/data-validation-apr-09/357/3 "2022-11-03T08:55:32Z")

</div>

> 🙋‍♂️ **yallouche** _replied_

#### very interesting I see, I’ve encountered quite a few PG errors, I’ll note them down and write an issue

#

---

<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:55am UTC](https://community.nocodb.com/t/data-validation-apr-09/357/4 "2022-11-03T08:55:33Z")

</div>

> 🙋‍♂️ **yallouche** _replied_

#### ideally we’d like something similar to the single/multi-select button but instead of defining it within nocodb it would be based on another table

#### 

#### So in the case of typical client/order set of table, the user would be able to pick a client from the client table when adding an order. Except that it should show up in SQL query

#

---

<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:55am UTC](https://community.nocodb.com/t/data-validation-apr-09/357/5 "2022-11-03T08:55:34Z")

</div>

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

* * *

#### 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/)