How to populate data from the external list.

  • Profile Image
    eppingpaully
    Asked on October 15, 2017 at 09:14 PM

    I have a massive list of fibre ready buildings across Australia, is there a way I can get a pair up with an address field to interact with this list and be like ok 123 smith st can get the following 

    fibre a

    fibre c 


    and then based on that I can deliver pricing, I just need to do the initial list pull thing, I can do the rest :)

  • Profile Image
    ashwin_d
    Answered on October 16, 2017 at 12:35 AM

    Do you mean to say that you want to dynamically get the data from the list you have based on the address selection of user? Unfortunately it is currently not possible to populate data in form from any external sources.

    You can add condition in your form to check the address input and based on that you can insert the data in another form fields. Please note that you will need to add a condition for each address. You may like to take a look at the following guide on how to add condition to insert values in form fields:  https://www.jotform.com/help/268-Conditional-Logic-Inserts-Text-Calculation-Into-A-Field 

    Hope this helps.

    Do get back to us if you have any questions.

  • Profile Image
    ashwin_d
    Answered on October 16, 2017 at 12:37 AM

    You may also like to take a look at our "Spreadsheet to form" widget and see if that fits into your requirement. This widget allows you to upload your spreadsheet to your form and use the values you have on the spreadsheet to pre-populate your form.

    Do try it out and get back to us if you have any questions.