You are viewing limited content. For full access, please sign in.

Question

Question

Monthly Reset of Incremental

Forms Workflow
Updated April 11, 2022
asked on March 20, 2022 • Show version history

I have a Business process form that has a Reference# field, this identifier is a mix of some Department, the date, and 4 digits that increment for each new item. The tricky part is that the last 4 digits should reset monthly.

As an example, let's say we have Reference# "ITD-2021-10-0005", the last 4 digits "0005" will increment up until the last day of October, and then the first item created in November should have "ITD-2021-11-0001". Also if the year changes must Reset the last 4 digits.

Any thoughts?

Hope someone can help,

 

Thanks in advance smiley

 

 

0 0

Replies

replied on March 22, 2022

You can create a stored procedure in database to archive the logical of the incremental and use lookup rules to get the value from the database.  https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/Lookup-Rules.htm has an example for using stored procedure with lookup rule.

0 0
replied on March 22, 2022

Hi Xiuhong Xiang 

Thanks for your reply. I am done creating the stored procedure what I want is How should I reset the sequence every month.

As an example, let's say we have Reference# "ITD-2021-10-0005", the last 4 digits "0005" will increment up until the last day of October, and then the first item created in November should have "ITD-2021-11-0001". Also if the year changes must Reset the last 4 digits.

 

Hoping for your kind help.

 

Regards,

0 0
replied on April 11, 2022

Hi Community :)

 

Any Updates on this?

Hoping someone can help.

 

 

Thanks in advance.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...