Re: How to assign a seq number to each table record

Home Forum Working with Tables How to assign a seq number to each table record Re: How to assign a seq number to each table record

#5894

Each instance has a unique sequential number – the instance number. After the form is published the first time, the first instance starts at instance #1. You can simply use the instance #, or use a formula to build on it.

Remember that an instance # is not created until the instance has been submitted the first time. You may need to create a behavior on when form opens that sets a field (call it hidden instance # helper)with Special – Instance Number. Then use a simple branch to look at at that field. If the field value is less than 1 – submit and re-open the same instance. If it is = or greater than 1 go to an Exit behavior object.

Workflow software, Process software, Procedure software