Maintenance Notice: labkey.org will be offline at 10:00 AM Pacific Time on Sunday, July 14th 2024 for maintenance. The estimated downtime should be no more than one hour. Please save your work before this time. We apologize for any inconvenience.
Sequential Keys marcia hon  2018-01-18 11:54
Status: Closed

We would like for there to be columns that autoincrement given a seed value.

For example, in table A, we would like the key to start at 10000. Each time something is uploaded the key changes by adding 1.

And another table B, starting at 20000. Each time uploaded, key changes by adding 1.

Please let us know how this is possible.

Jon (LabKey DevOps) responded:  2018-01-24 14:52
Hi Marcia,

You could develop your own custom module with your own Java code that could enforce this specific logic, before committing the rows to the system, but this isn't possible with LabKey out of the box.