Issues with auto-Incremental Id

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

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

1 Like