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

Question

Question

automation of number sequencing with some prefix

Workflow Forms Search and Retrieval How To Business Processes

Updated April 20, 2020

asked on April 17, 2020

Hi Team,

I have a simple text box named "Requisition number" in this box i want to generate sequential numbers automatically and format is-

[Project Code/Month/Year/Serial no.]

Please suggest on this.

How can i do this ?

Please find below mentioned screenshot for example:

0 0

Replies

replied on April 17, 2020

Can you can connect to a SQL database and use a sequence?

https://www.sqlservertutorial.net/sql-server-basics/sql-server-sequence/

1 0

replied on April 18, 2020

Hi Rich,

My scenario is differ from your solution.

Thanks

0 0

replied on April 20, 2020

Hi,

Can you use the instance ID to achieve this.

Concatenate the values in a text field.

Thanks.

1 0

replied on April 20, 2020

That's a good idea. For me, I hear "sequential" and I probably want control of that number, and I probably over think it most of the time

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked April 17, 2020
Updated April 20, 2020
211 views