Local Data Sourcing - spreadsheet to form widget

  • Profile Image
    sgrove140
    Asked on March 22, 2021 at 05:54 AM

    Good morning! I'm looking at using Job Form to help power my business. I want to be able to select a name from a drop-down list, and then have the form auto populate the corresponding address information associated with that name. Am I able to do that sourcing the address information from an Excel document from my computer? Or do I need to store that information on the Jot form site? For example, I choose Amazon LAS1 as the location. Can I choose Amazon LAS1 as my location, and then on the next field for Amazon LAS1's address will auto populate the correct address for LAS1 so I don't have to enter it every time?

  • Profile Image
    Vick_W
    Answered on March 22, 2021 at 07:58 AM

    Hi there,

    We have a widget that is specifically made for this requirement. Please check the guide below to understand how you can use it in your form.

    https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    Let us know if you have any questions.

    Thanks