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 Use Data Saved in Form1 in a Dropdown List In Form2?

    Asked by gemai on October 04, 2015 at 07:42 PM

    Hi there

    I  have a form for registering new clients (Form1). The data is saved in a spreadsheet in Google Docs.

    Now, I am creating a second form (Form2) with the purpose of tracking activities with the different clients registered in Form1. The first field of Form2 is the client name and I want a dropdown list against the existing clients in Form1. How can I do that?

    Thanks for your help

       Gema 

    dropdown list saved in use
  • Profile Image
    JotForm Support

    Answered by mert on October 05, 2015 at 04:30 AM

    Hi Gema,

    If you want to import the data to an another form as a dropdown option list, unfortunately, it is not possible. The imported data can only use and list on submissions.

    However, you can import the data from spradsheet with using the link http://import.jotform.io/. Specific field's data can match with the new field in another form, but as I mentioned earlier, those data will be stored in submission.

    From the link below, you can see the steps in detail to complete this operation.

    http://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm

     

    If you need further assistance, please let us know.

    Thanks.

  • Profile Image

    Answered by gemai on October 06, 2015 at 08:17 PM

    Thanks Mert. I just want to make sure that in Form2 I'm tracking activities for clients who are already registered in Form1. But it seems that it's not possible... Any workaround for that? Basically, from my second form I want to search clients already registered in my Google spreadsheet of clients via my first form.

  • Profile Image
    JotForm Support

    Answered by mert on October 07, 2015 at 03:44 AM

    Hi again,

    This suggestion doesn't cover your request completely, but you can try to link form1's and form2's submissions into a one Google spreadsheet file. With that way, you can search data from form1 on the same spreadsheet.

     

    To do that, use Zapier to connect multiple forms to a single spreadsheet: https://zapier.com/zapbook/jotform/google-docs/3379/add-jotform-submission-to-google-docs-row/.

     

    I hope this one satisfy your needs. If you need extra help, please let us know.

    Thanks.