Question

Sequential number

Search and Retrieval

Updated December 21, 2020

asked on December 7, 2020

Our group recently created a Personnel Requisition form (PRF) which allows our managers to submit new positions for approval. We would like our form to auto-generate a PRF number that is unique to each completed form submitted.

I understand that there's a way to upload a SQL script to enable this feature. The downside is, none of our group members know how to write an SQL script. Do you have any recommendations on how we can get a sequential number generated in Laserfiche without an SQL script?

Thanks.

0 0

Replies

replied on December 20, 2020

Hi Kathleen,

You may want to use workflow to generate the sequential number.

First, on your Form do a lookup to display the number. When the user submit the form, set workflow (custom query) to select the number from the table (select SeqNumber from MyTable).
Use Token calculator to increment the number and finally Update the number with token calculator using Update Data in workflow.

Thanks.

1 0

replied on December 21, 2020

This path can produce duplicate numbers. The reasons why and a different approach is discussed here and in the Forms help file mentioned below.

0 0

replied on December 21, 2020

See the example in the help file. It also points you in the direction of more documentation on how to write a sequence.

0 0

replied on December 21, 2020

Thanks Mahesh and Miruna for your responses!! Much appreciated!

0 0

You are not allowed to follow up in this post.

Question

Question

Sequential number

Replies

Sign in to reply to this post.