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 populate the options of a field form the results of another form or from a Google Sheet?

    Asked by dfriess on May 19, 2017 at 03:31 PM

    Am I abel to have a dynamic list of options that populates form the results of another form or from a Google Sheet?

    Page URL:
    https://form.jotform.us/71355245747158

  • Profile Image
    JotForm Support

    Answered by Jan on May 19, 2017 at 04:19 PM

    My understanding is that you want to popupate the dropdown options from another form or from an external source.

    Unfortunately, it is not possible to extract data from an external file and dynamically insert it in the dropdown options. However, you can pass fields values from one form to another. Here's a guide: How-to-Automatically-Pass-Form-Data-to-Another-Form.

    You may also prepopulate the form through the URL using the Field Prepopulator App. Here's the link: http://prepopulate.jotform.io/. If you want to do it manually, please check this guide: Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters.

    Lastly, if you want to populate the values inside the form, please check the Update/Calculate Field condition. Here's a guide: Conditional-Logic-Inserts-Text-Calculation-Into-A-Field.

    Hope that helps. Thank you.

  • Profile Image

    Answered by dfriess on May 19, 2017 at 04:43 PM
    Thanks.
    Derek
    Derek Friess, Technology Coordinator
    Pike-Delta-York Local School District
    419-822-3391 (Office)
    419-822-4478 (Fax)
    [cid:image001.gif@01D2D0BC.4FD4C960] Pike-Delta-York Quality Profile
    CONFIDENTIALITY NOTICE: This message may contain student personally identifiable information that is confidential. Such information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, printing, distribution, or the taking of any action in reliance on the contents of the information contained herein is strictly prohibited. If you receive this e-mail message in error, please immediately notify me by telephone at 419-822-3391 to arrange for the return of the original document to me. Please also delete the message from your computer. Thank you.
    ...