Domino Code Fragment

Code Name*
Generates Sequential Project IDs		Date*
04/28/2024		Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.18.222.162.216
Description*
Create a view GetNumber with ProjectID filed sorted largest to smallest. It will take last (largest) number and add 1		Type*
Formula		Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:
@If (@IsNewDoc & @IsDocBeingSaved; @Success;@Return(ProjectId));
Num := @DbColumn("Notes":"NoCashe";"";"GetNumber";1);
Num1 := @If(@Iserror(Num) | Num="";0;@TextToNumber(@Subset(Num;1)));
NewNum := @Text(Num1+1);
@Right("0000" + NewNum;4);



ANOTHER METHOD:
@If(@IsNewDoc & @IsDocBeingSaved; @Subset(@DbColumn("" : "NoCache"; ""
: ""; "RMA Number"; 1); 1) + 1; RMAno)