How can I populate the options of a field form the results of another form or from a Google Sheet?

  • Profile Image
    dfriess
    Asked 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?

  • Profile Image
    Jan
    Answered 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
    dfriess
    Answered 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.
    ...