"When creating a form I need the person filling out the form to see the order number I have followed your sequence formula but it does not create a number with each form so the customer doesn't have a reference number. the form stays on PO10000"

Question

&quot;When creating a form I need the person filling out the form to see the order number I have followed your sequence formula but it does not create a number with each form so the customer doesn't have a reference number. the form stays on PO10000&quot;

Vipin · Accepted Answer

Hi Jenny, if you are using the sequence() function to generate a unique number, please note that the number will be generated only after the user enters the answer for at least one of the fields in the form. When the user clicks on the link, it will show PO10000 and after they enter answer for name and supplier field in your form, it will show the generated number (ex PO10012).

Guesswork

When creating a form I need the person filling out the form to see the order number I have followed your sequence formula but it does not create a number with each form so the customer doesn't have a reference number. the form stays on PO10000

Comments (1)

Add your comment

When creating a form I need the person filling out the form to see the order number I have followed your sequence formula but it does not create a number with each form so the customer doesn't have a reference number. the form stays on PO10000

Comments (1)

Add your comment

Related questions