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

Question

Question

Count for number of forms submitted

asked on January 29, 2016

Is there a way to add a field on the form to keep a running total of form submissions? I would like to have the first submission to show the number "1", the second submission to show "2" and so on.  

 

Thanks in advance,

Dane

0 0

Replies

replied on January 29, 2016

Hi there,

Can you tell me more about your business process? And are you try to count how many instances started during a time period? How you want to the result to be displayed?

0 0
replied on January 29, 2016

Thank you for your reply.  The form I would like to do this on is for Purchase Orders.  Users fill out the form and then it undergoes an approval process.  I need a way to reference back to each form with a unique ID Number that only applies to 1 Purchase Order form.  Our purchase order numbers are in sequential order, so ideally I would like to have that number on the form itself.  

I need to count the total instances of when a purchase order is submitted.  Perhaps when the user hits the "submit" button on the form, a number field on the form is populated with  a number + 1, so that number only applies to that purchase order form.  

0 0
replied on January 29, 2016

Hi there,

You can generate and assign the number after the form submitted using Workflow Service Task in Forms 10.

0 0
replied on January 31, 2016

A couple of ideas:

Use the form instance number in a field or on the form when you save it to the repository; this is a unique number.

or

Add a sequential number to the form during processing.  From the from run a workflow that generates this number in SQL.  You could do a lookup after this workflow to bring the number back to the form (version 9) or use the Workflow input / output fields in Version 10.  An SQL sequential number generator is outlined in: https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-US/administration/#../Subsystems/Forms/Content/Lookup-Rules.htm?Highlight=increment   

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

Sign in to reply to this post.