What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Unique ID Tool: Unique ID increments for "incomplete payment" submissions

    Asked by ASRA on February 28, 2013 at 02:57 AM

    I have a form for membership of a sports association, where prospective members have to pay a membership fee. I'm trying to allocate them a unique membership number by using the "Unique ID" field.

    I assumed the Unique ID would only increment when the form was completely submitted and the user's details recorded in the Submissions and associated reports. However it appears that the number is incremented prior to the payment, and therefore all those users who never pay, and thus never join, get a unique ID. That's roughly one-third of people who hit the "Submit" button.

    This means there's a lot of gaps in the membership numbers, and the next number gallops way ahead of the actual number of members. It looks wrong and doesn't make much sense.

    Can this be changed so that the Unique ID only increments once the submission is complete?

    Page URL:
    http://www.internationaldownhillfederation.org/page/idf-membership-1

    unique id Submissions unique
  • Profile Image
    JotForm Support

    Answered by EltonCris on February 28, 2013 at 05:57 AM

    Hi,

    Incomplete payments are still considered as "Submissions", so this must be the reason why it is still counted on the Unique ID counter. Unfortunately I couldn't think any possible workaround. However, I have forwarded the problem to our higher ups so they can consider to fixed this in the future, if it's possible. You will get updates once it has been worked on.

    Thanks!

  • Profile Image
    Chief Technology Officer

    Answered by eee on May 10, 2013 at 11:25 AM

    Hi,

    Unique ID's working process has been changed to cover your needs,

    It's available right now,

    Kindest Regards,

    Ertuğrul.

  • Profile Image

    Answered by ASRA on May 10, 2013 at 03:11 PM

    Thanks, thats excellent news.

  • Profile Image

    Answered by ASRA on May 12, 2013 at 08:13 AM

    Hi,

    I'm concerned that this fix might have introduced a new issue.

    When my users submit a membership form they receive an email notification that includes their membership number - the unique ID. This has worked reliably until now. 

    However in some cases now the unique ID changes after the email notification has been sent. Based on the email notification the user believes their membership number is x, but the jotform submission shows it to be x-1.

    It's causing a lot of confusion (and angry members).

  • Profile Image
    JotForm Support

    Answered by jonathan on May 12, 2013 at 04:31 PM

    @ASRA

    Hi, 

    Thank you for this information. I was able to reproduce the issue on the inconsistency of unique id# field on email notification versus the submission data.

    The unique id# increments by 1 when seen in the email. 

    May I request though that you create a new post about it here  http://www.jotform.com/contact since the original issued ticket was already resolved, and this is a new one.

    We will respond to your new post at once.

    Thanks.

  • Profile Image
    Chief Technology Officer

    Answered by eee on May 13, 2013 at 10:59 AM

    Hi,

    Problem has been solved,

    Kindest Regards,

    Ertugrul.