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

    Can I submit a list of unique submissions?

    Asked by mahindrausa on August 18, 2016 at 05:33 PM

    I am auditing the websites of our clients. There are over 500 of them, so I do not want to be working by myself. I created a form for grading consistency. I would like to add a drop down list of all 500 of the clients. Yes this can be done, BUT what I want to happen is for every audit that is performed for a client, the client disappears off the list. So if I have clients A, B and C, and Lucy grades client C, and I start a submission, client C no longer appears in the drop-down of all the client names. 


    It would be even more awesome if the same spreadsheet I used to populate the client name list could be used to autofill some of the data in the rest of the form for that client. 


    Let me know!

    Thank you, 


  • Profile Image
    JotForm Support

    Answered by Welvin on August 18, 2016 at 09:09 PM

    Unfortunately, the dropdown cannot do it. You can set a unique question limit in the form, but that won't remove the selected option from the dropdown. It will show you the warning instead when submitting the form.

    Reference: https://www.jotform.com/help/223-How-to-set-Form-Limits-Based-on-a-Unique-Question.

    A workaround, maybe, would be to use a textbox in the form for you and your team to fill the client name. You can use a spreadsheet file as the reference of the entire list of clients. On the other column of the spreadsheet is a section where you and your team can add a note if the client has been audited already. Outline below:

    I hope that helps.