How to restrict registrations?

  • juan_Juan_juan470
    Fecha de consulta 5 de octubre de 2024, 16:00

    Puedo hacer restricciones en inscripciones en jotform. Por ejemplo si pido el DNI y hay una inscripción con ese DNI, no dejar que se inscriba. Quedó a la espera de su contestación.

  • Mary Jotform Support
    Fecha de respuesta 6 de octubre de 2024, 1:01

    Hi Juan,

    Our Spanish Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, it might take a while until they're available again.

    Now, coming back to your question, I will need more time to look into this, I will get back to you with an update.

    In the meantime, let us know if you have any other questions.


  • Mary Jotform Support
    Fecha de respuesta 6 de octubre de 2024, 8:21

    Hi Juan,

    Let me show you how to use the Spreadsheet to Form widget:

    1. Create a spreadsheet with your data structured like you see below. Make sure that the column names in the spreadsheet match the field names on the form:

    How to restrict registrations? Image 1 Screenshot 70

    2. In Form Builder, click on the Add Form Element menu on the left side of the page.

    3. Click on the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

    4. In the menu on the right side of the page, upload your data file. (You can simply drag & drop your Excel file to the Upload File area.) 

    How to restrict registrations? Image 2 Screenshot 81

    5. Then, click on the Downward Arrow icon in the Access Code Column option and select the first ID field.

    6. You can also customize texts used in the widget. After you complete everything, click on the Update Widget button at the bottom right of the menu.

    How to restrict registrations? Image 3 Screenshot 92

    Now, when people fill out your form and enter the ID from the spreadsheet, the corresponding fields will automatically populate the other ID field: 

     How to restrict registrations? Image 4 Screenshot 103

    You can then create a condition where if the ID is filled, hide the submit button:

    How to restrict registrations? Image 5 Screenshot 114

    Here is the result:

    How to restrict registrations? Image 6 Screenshot 125

    Give it a try and let us know if you need any help.