Is there any way to pull in values on a field (i.e dropdown, radio, etc.) from an external database?

  • Profile Image
    luntiands
    Asked on August 12, 2019 at 04:00 AM

    Is there any way to pull in values on a field (i.e dropdown, radio, etc.) from an external database or cloud-based data like google sheets?

  • Profile Image
    gerardw
    Answered on August 12, 2019 at 07:04 AM

    Sorry, but currently it is not possible to prepopulate the form fields from an external database. Also, you can't dynamically change the options within a dropdown field from an external Google Spreadsheet. The closest widget we have that does something similar is the Spreadsheet to Form widget.

    This thread explains how you can populate data in a dropdown field using this widget: https://www.jotform.com/answers/1688941.

    You can also refer to this guide to understand how to set up the widget: How-to-Use-the-Spreadsheet-to-Form-Widget.

    Hope this answers your query.