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

    How can I check to see if a user already has a username?

    Asked by brandonppr on July 25, 2017 at 07:53 PM

    Basically I want a form user to be able to enter a username when they check out.

    the names are stored in a google spreadsheet.

    If they do not  enter a user name that is in the spreadsheet I don't want them to be able to continue without signing up on another form which will put them in that google spreadsheet and then they can enter that username to continue.

    is this possible without manually adding the names in conditions each time a new user signs up.



  • Profile Image
    JotForm Support

    Answered by Kiran on July 26, 2017 at 01:11 AM

    Unfortunately, it is not possible to read the data from external sources based on an input field. The only possible way to validate the data manually by setting up the conditions. 

    It may be possible by embedding the form using full source code and adding additional programming code to lookup the username from the spreadsheet. You may hire a programmer from Upwork or Freelancer to achieve your requirement.