Search code examples
lotus-noteslotuslotus-domino

How to create an auto incrementing field in lotus domino?


I have an application in lotus domino with a field

UNIDID-number(computed)...

I want that every time a new entry is created, this field to increment by 1 and the new value should be stored in new record document..

I have a @dbcolumn formula which will get me the last entry in the UNIDID field-

mFind:=@DbColumn("" : "NoCache" ; @DbName ; "lkpEmpMasterbyOnlyUnidCode";1);

How do I increment mFind and submit it in form of 'UNIDXXXX'?


Solution

  • Employ document locking to assure number uniqueness in sequential document numbering solution