Sequential Keys marcia hon  2018-01-18 11:54
Status: Closed
 
Hello,

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.

Thanks,
Marcia
 
 
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.

Regards,

Jon