Sunday, August 5, 2012

Create a customize auto numbering from SharePoint.

Original post from Autonumber Custom List Field
here are the flow:
1. Create a list name "Running Serial" with 2 columns named LastNo and NextNo.
2. Add the list column which hold the auto running number. CIN or RefNo or CustomerNo.
1. Create a workflow variable named "mNumber" or any name preferred.
2. Create a Set workflow variable action with set NextNo from "Running Serial" as a data source. Set Title from "Running Serial" as desire column name (CIN, RefNo or CustomerNo).
3. Create another action with Set field in current item. Choose the auto running number field (CIN or RefNo or CustomerNo). Set value to workflow variable, mNumber.
4. Create a last aciton with Update list item. 
5. Update "Running Serial" LastNo field with mNumber variable.
6. Set Find the list item with "Title" field, set value as "CIN" or "RefNo" or "CustomerNo".
7. Save and publish it.