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

Question

Question

how to insert process instance id into sql table on 1st form i.e. process starts

asked on June 12, 2020

Hi Team,

Hope doing well !

 

is it possible to insert the process instance id into the sql table on 1st form.

Please revert asap.

 

Thanks

Shubham Jain

0 0

Replies

replied on June 12, 2020 Show version history

Hi Jain,

Yes.
Through workflow, make sure that you enable "Started by laserfiche Forms" in workflow properties.

And use "Input Parameters" as token value.

 

 

2 0
replied on June 12, 2020

Thanks Mahesh !

1 0
replied on June 12, 2020

Hi Mahesh,

I have done with your suggestion but when i am trying to submit the task WF gives the error.

In this error i also check with data type of nvarchar and varchar.

Screenshot attached.

InstanceID field data type error.png
0 0
replied on June 14, 2020

If you are inserting a date field, please make sure that you apply the correct formatting.

Thanks.

0 0
replied on June 15, 2020

Hi Mahesh,

Hope doing well !

 

i have tried with these three formatting i.e.:

(1) YYYY/MM/DD

(2) DD/MM/YYYY

(3) MM/DD/YYYY

but still issue remain same.

Any solution on this ?

 

Thanks

Shubham Jain

 

 

0 0
replied on June 15, 2020

OK, please send a screenshot of the workflow.
I assume that the screenshot above is a Save to Repo task.

Thanks.

0 0
replied on July 14, 2020

Hi Mahesh,

Hope doing well !

Support required:

I have a single form process where initiator fill the information and submit the task.

Here i want to initiate the auto sequencing on this form.

eg: when initiator start the process, a field called as DMS ID should be 001 in read only mode and when user creates a new task than DMS ID should be 002.

 

Thanks

 

 

 

 

0 0
replied on July 14, 2020

Hi Shubham,

 

There's is an good example in the Laserfiche Admin Guide that will help you to achieve the sequential number. Please consider link for more info. (Example: auto-incrementing number)

Thanks.

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

Sign in to reply to this post.