Can I create a unique ID per record?

  • Profile Image
    markashton
    Asked on April 27, 2010 at 03:33 AM

    Hi,

     

    A client has requested the following for an enquiry form I am developing them:

     

    Is it possible that we could give each enquiry a unique reference number and which gets allocated to their enquiry when they press “submit”?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

     

    Can you advise me on this as my short investigation suggested that unique IDs are not by default shown for submissions.

     

    Thanks Mark

  • Profile Image
    aytekin
    Answered on April 27, 2010 at 05:26 AM
    This is currently not possible. However we are planning to implement it within next month.

    Exactly what kind of number would you like? Would it need to start from a number you choose or just start from 1, 2, 3 etc.? Or should it be completely random number such as 12966412986?

  • Profile Image
    markashton
    Answered on April 27, 2010 at 05:47 AM
    I could see a use for all of these options:
    1) Starting from scratch has its uses of course
    2) Starting from a specific number means you can append to an existing db sensibly...

    The client has a need for unique ref number as per the statement string.

    Thanks for letting me know status


  • Profile Image
    seyhuns
    Answered on April 27, 2010 at 06:41 AM
    This feature is completed.

    You can edit your Email Alert to use this feature. Open "Email Alerts" go to "Compose Email" window.
    From right side click on "Unique ID". This will put "{id}" tag in to your form. This id is the unique submission id.

    Thank you.
  • Profile Image
    markashton
    Answered on April 27, 2010 at 08:31 AM


    Thanks for this. Can I ask whether one can implement it into the excel/csv file for download. I think this is what they are after - to map it to the unique ID in their DB

    Thanks for your help - appreciate it

  • Profile Image
    stubbs
    Answered on May 10, 2010 at 04:51 PM
    I noticed this in the email response options but when I tested it, the unique id was a very long string of numbers. Is it possible to have only a four or five digit number?
  • Profile Image
    seyhuns
    Answered on May 11, 2010 at 12:26 AM
    stubbs,
    We are sorry, unique id's cannot be four digits.

    markashton,
    We will add unique id's to the report in the following weeks.

    Thank you.

  • Profile Image
    AndyFA
    Answered on May 26, 2010 at 09:55 AM
    Hello,
    It would be really useful for us to add our own ID in this area. We want to start getting our users to submit Design Briefs to us using this form.

    With our current system (done by paper) we are allocating a Job Number to each brief and are currently at something like Job 6198. It would be really useful if when we start using JotForm we could automatically start from our latest job number and seamlessly integrate it into our system.

    Many thanks, JotForm is an excellent product.
    Andy
  • Profile Image
    oryx
    Answered on December 26, 2010 at 04:56 AM

    Adding our own ID would be a wonderful option,  I also am looking for similar thing, it would be really helpful.

  • Profile Image
    otabo
    Answered on February 23, 2011 at 09:43 PM

    Agreed. I need to have a sequence with predefined combinations.

    For example: Customer ID + Order #

    Really love what you guys have done here. Best in class.

    Chris

  • Profile Image
    tecladigital
    Answered on March 21, 2011 at 07:05 PM

    I subscribe this function. It would be very nice.

  • Profile Image
    allanftd
    Answered on March 22, 2011 at 02:40 AM

    Thanks to all who shared their thoughts about this feature. Currently, JotForm has this feature although the ID # being generated is more than 5 digits. We're still determining how to come up with a shorter ID # that would fit most, if not, all of JotForm members' requirements.

    For now, please feel free to use the ID # feature as described by Seyhuns above. Again, thank you very much  for using JotForm!

    JOTFORM SUPPORT

  • Profile Image
    Heeschen
    Answered on March 23, 2011 at 02:53 AM

    I would also be very much interested in adding our own id starting from e.g. number XY, which i could input in my form development page. The jotform id is too long to reference for our staff and for the customer. Thank you! Marc

  • Profile Image
    allanftd
    Answered on March 23, 2011 at 11:02 AM

    Hi Marc,

    We hear you, thanks for the input! We'll keep your suggestion in mind.

    JOTFORM SUPPORT

  • Profile Image
    serkan
    Answered on April 01, 2011 at 10:16 AM

    We now have a better options for this. Try our new feature.

    http://www.jotform.com/help/79-Adding-a-Custom-Unique-ID-To-Your-Form