# Check table id and shown messgae

**URL:** <https://community.tulip.co/t/check-table-id-and-shown-messgae/6319>\
**Category:** Support, Troubleshooting, & Help\
**Tags:** apps\
**Created:** [September 7, 2022, 5:14pm UTC](https://community.tulip.co/t/check-table-id-and-shown-messgae/6319 "2022-09-07T17:14:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ganesha](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Ganesha](https://community.tulip.co/u/Ganesha)\
**Post date:** [September 7, 2022, 5:14pm UTC](https://community.tulip.co/t/check-table-id-and-shown-messgae/6319/1 "2022-09-07T17:14:21Z")

</div>

Please help me in creating this logic check the id in tulip table show the message that id is repeated

whenever there is repeated ID user clicks the submit it shows error saying that id has entered in the table.

---

<div class="post-metadata">

**Author:** ![Pete\_Hartnett](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/pete_hartnett/32/3678_2.png) [@Pete\_Hartnett](https://community.tulip.co/u/Pete_Hartnett)\
**Post date:** [September 7, 2022, 8:45pm UTC](https://community.tulip.co/t/check-table-id-and-shown-messgae/6319/2 "2022-09-07T20:45:29Z")

</div>

Hey @Ganesha -

Duplicate IDs cannot be added to the same table. The ID column is a _special_ column that identifies a single record. If ID’s could be duplicated, there would be no way to identify the record you want to load/edit.

The way people often get around this is by using random strings for the ID, and storing the duplicated data in any other table field.

Pete

---

<div class="post-metadata">

**Author:** ![Ganesha](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Ganesha](https://community.tulip.co/u/Ganesha)\
**Post date:** [September 8, 2022, 9:27am UTC](https://community.tulip.co/t/check-table-id-and-shown-messgae/6319/3 "2022-09-08T09:27:29Z")

</div>

I have noticed that if the ID is the same it’s gonna overwrite the existing data which doesn’t give any notice to team members that the ID is being repeated. I would like to add that option with logic. Whenever a team member enters an id that is the same as the existing one in the table, it can show a message. Can you please help me out in building this logic?

---

<div class="post-metadata">

**Author:** ![Pete\_Hartnett](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/pete_hartnett/32/3678_2.png) [@Pete\_Hartnett](https://community.tulip.co/u/Pete_Hartnett)\
**Post date:** [September 8, 2022, 12:12pm UTC](https://community.tulip.co/t/check-table-id-and-shown-messgae/6319/4 "2022-09-08T12:12:24Z")

</div>

Sure-

Here is how I would check this-

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/d/d7dc6c7c1beb62abcde346baac410fe2c2d1abcf.png)

Pete

---

<div class="post-metadata">

**Author:** ![Ganesha](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Ganesha](https://community.tulip.co/u/Ganesha)\
**Post date:** [September 8, 2022, 12:44pm UTC](https://community.tulip.co/t/check-table-id-and-shown-messgae/6319/5 "2022-09-08T12:44:55Z")

</div>

hi Pete,

that has worked. awesome thank you.

Ganesha