# Issues with auto-Incremental Id

**URL:** <https://community.tulip.co/t/issues-with-auto-incremental-id/14785>\
**Category:** General\
**Tags:** tables, query, aggregation\
**Created:** [May 20, 2025, 2:25pm UTC](https://community.tulip.co/t/issues-with-auto-incremental-id/14785 "2025-05-20T14:25:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MarvinGarcia96](https://avatars.discourse-cdn.com/v4/letter/m/97f17d/32.png) [@MarvinGarcia96](https://community.tulip.co/u/MarvinGarcia96)\
**Post date:** [May 20, 2025, 2:25pm UTC](https://community.tulip.co/t/issues-with-auto-incremental-id/14785/1 "2025-05-20T14:25:21Z")

</div>

I’m doing some testing apps on tulip right now I’m developing an app where a table record is created but the Id is an auto-incremental value, looking into Tulip’s community I found that I could use a table query, an aggregation and an expression to achieve it, but on my app after I create the second record, I got stuck in “2” making tulip to throw me a “There is already a record with ID 2” error message

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

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

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

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

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

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

---

<div class="post-metadata">

**Author:** ![MarvinGarcia96](https://avatars.discourse-cdn.com/v4/letter/m/97f17d/32.png) [@MarvinGarcia96](https://community.tulip.co/u/MarvinGarcia96)\
**Post date:** [May 20, 2025, 5:12pm UTC](https://community.tulip.co/t/issues-with-auto-incremental-id/14785/2 "2025-05-20T17:12:36Z")

</div>

I solved it, the problem was on my signing table, at first I changed ID field to Work Order, but as many records with the same WO number will be on the table, I added a WO field, and turned back to “Id” the ID field so what I did was to re-do the table structure without editing ID field, applied the same query and aggregations and now it works just fine