Question about class sign up

  • Profile Image
    Hillary
    Asked on April 29, 2019 at 01:33 PM

    Hi,

    I'm inquiring about whether there's a way to "restrict' the completion of a sign-up form to only certain email addresses. For example, we are a boxing collective that wants to use jotform to create a class calendar sign up form. So that our participants can choose to participate in class and we can be made aware of who will be attending.

    However, we want to restrict this sign-up to only those who have already "registered" as members with us. By this we mean, have already filled out a separate jotform that includes their signing our code of conduct, and signing our gym waiver. 

    We need to be sure that in order to "sign up for class" they've already completed this documentation. 

    Is there a streamlined way to do this? Thanks so much for your help!

    Hillary

    Screenshot
  • Profile Image
    Mike_G
    Answered on April 29, 2019 at 04:00 PM

    I'm afraid it is not possible to prevent submissions in a form based on another form's submission data.

    However, there is a workaround that you can do on your form to meet your requirements.

    First, you need to collect all the email address of those who registered in your other (initial) form. To easily do that, you can download the submissions made to your form in an Excel file. Then, from the Excel file, you can copy the email addresses. How-to-Partially-Download-Form-Submissions-as-Excel-CSV-PDF

    Once you do, add those email addresses as options of an additional Single Choice field in your new (class calendar) sign-up form.

    1556566442t15_30_42.png

    After that, create a condition that will fill the Single Choice field with the email address entered in the Email field of your new (class calendar) sign-up form if the Email field is filled.

    1556566788t15_35_22.png

    Now, once the email address entered in the Email field of your new (class calendar) sign-up form exists as one of the options, the Single Choice field will be filled. Then, to make sure that the form is not submitted when the entered email address doesn't exist, you will create another condition that will hide the Submit button in your form if the Single Choice field is empty.

    1556567215t15_45_39.png

    Here's a Sample Form — https://form.jotform.com/91186436319967


    Note: The Single Choice field should be hidden on the form, but is only shown in my Sample Form above for testing purposes — How-to-Hide-Form-Fields

    Please test the Sample Form by typing one of the options in the Single Choice field into the Email field. Notice that the email address you typed (if it exists in the Single Choice field) will be selected and the Submit button will be shown. Otherwise, the Single Choice field will remain empty and the submit button hidden.

    I hope this helps. If you have other questions or concerns, please feel free to let us know.