Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Generate sequential number (web)

Posted on 2004-10-20
2
Medium Priority
?
253 Views
Last Modified: 2013-12-18
Hi friends,

I have problem here and would appreciate help. I have this Problem Request Call form(for the helpdesk) that should have  a field which auto generates a sequential number in the form of "ABC00001" upon opening the form.
ABC is just a constant string. But I would like to know how to generate the sequential numbers behind it. This number should start from one and increment by 1 with every new document saved. If the form is opened but not saved, the number should not increment.
Thanks in advance for any help!

IT Student
0
Comment
Question by:SadCase
2 Comments
 
LVL 19

Assisted Solution

by:madheeswar
madheeswar earned 80 total points
ID: 12356451
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 120 total points
ID: 12358322
Create a view of teh documents, sorted REVERSE on the field name you are using.  Have a computed field with the following formula:

view := "name of that view";
current := nameOfThisField;
all := @DbColumn("" : "NoCache"; ""; view; 1);
last := @Subset(all;1);
noABC := @Right(lasy; "ABC");
numeric := @TextToNumber(noABC);
newNumber := @If(@IsError(numeric; 1; numeric + 1);
newKey := "ABC" + @Right("0000" + @Text(NewNumber); 5);
@If(@IsNewDoc & @IsDocBeingSaved; newKey; current)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question