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

Question

Posted to Laserfiche Lounge

Question

Laserfiche Lounge

Adding Numbers to Forms Automatcally

Forms Workflow

Updated November 14, 2019

asked on November 13, 2019

HI Everyone,

Is there away to set up a form to automatically create a number for the form that is being submitted in forms or the workflow? Like I submit a form and it will be listed as number 1 and when i submit another form it will automatically insert the next number "2" for that specific form type being submitted.

0 0

Replies

replied on November 14, 2019

Nicki,

I do not know of a way to automatically index submitted forms starting with single digits. I use a reference to an external SQL table on most of the HR forms that we use that utilizes a view that returned the last record index of the tracking table adding 1 integer knowing that the insert statement will give that record the presented index.

SELECT  MAX([cf_index])+1 as NewIndex  FROM [dbo].[hr_changeFormTracking]

I have also used the form Instance ID which is a unique number within the entire forms system for that individual process and is available as a default value. On a couple of occasions where I needed referenceable form numbers with no corresponding data table.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked November 13, 2019
Updated November 14, 2019
82 views