FIELD casenum := casenum; x := @DbColumn(Class : "NoCache" ; "" : "" ; "Number" ; 1); y := @If(@Trim(x)="" ; "0" ; @Subset(x;-1)); z := @TextToNumber(y) + 1; a :=@Right("00000" + @Text(z);5); @SetField("casenum";a)Thanks in advance.
There are many pitfalls in this approach! This topic was treated in depth in this article on LDD that I commend to you as a good guide in this area.
Dig Deeper on Lotus Notes Domino Formula Language
Related Q&A from Maureen Leland
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.