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

    I want to only allow unique submissions on a particular field.

    Asked by VilPietersen on March 06, 2011 at 07:04 PM

    Hi this might be a little to specific but I want to allow someone to choose a username i.e. it has to be unique.

    How would I only allow a field to have a unique submission allowed i.e. jotform checks the database for matched before allowing the form to submit.

    Do you allow for this functionality?

     

    Thanks in advance for your help!!

  • Profile Image

    Answered by DanielGriffin on March 08, 2011 at 07:47 AM

    Hi there,

    Unfortunately not.  Jotform forms are submitted in one go.  The functionality you are describing would require a partial submission via ajax to some other site so that you could validate the username, and then submit the form via Jotform.  The best solution I can offer you is to split the submission process into two seperate forms.  The first form can be directed to your own custom thank-you page, which would query your own database to check for unique usernames.  That thank-you page could then conditionally display the second form if the username is unique. 

    Custom Thank-you pages can be created in the form builder by clicking the Thank You button.

     

    HTTP POST can be set up by clicking the preferences button, and selecting Advanced Settings:

     

    Thanks,

    Daniel