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

    Is there a way to embed a table into the form to validate an account number is active?

    Asked by connellye on December 27, 2016 at 10:13 AM

    Hi!

     

    I am working to streamline some activities within my community.  Is there a way to have a list of account numbers in the background of the form to validate that a Last Name and Account Number is correct?

     

    Thanks!

    Erin

    Page URL:
    https://form.jotform.com/63613743256154

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 27, 2016 at 10:39 AM

    Hello Erin,

    Please note that it is currently not possible to validate input data with any external source or previous submission data.

    One way to achieve your requirement is by taking advantage of our "Conditions" feature. You can add condition in your form to check the input data of last name and validate it with the account number. 

    Hope this helps.

    Do try out and get back to us if you have any questions. Please share some account number and resident name, we will create a demo form for you.

    Thank you!

  • Profile Image

    Answered by connellye on December 27, 2016 at 01:19 PM

    Thanks!  I was able to put 2 hidden fields with rules that were able to work around this.

    Specifically, I did a formula that combined the last name and account number, then had a hidden drop down field with all possible last names and accounts.  Then did a condition to make them match, populate a text field with "Valid Account Information".  If there isn't a match, the field stays blank and populates that field with "Call Guard Shack".

    Thanks again!

    Erin

     

  • Profile Image
    JotForm Support

    Answered by Jan on December 27, 2016 at 02:06 PM

    That is a great solution. Glad to hear that your issue is now resolved. Let us know if you need any help. Thank you for updating us.