Is there a way to lookup data and dynamically autofill it in the dropdown field?

  • Profile Image
    samuthana
    Asked on February 21, 2021 at 09:11 AM

    I want to know how to get the drop down options from a connected table (data from, say form A) for a field in a form B and then auto populate some other fields in form B based on the data in the connected table (data from, say form A), before manually filling the other fields in form B. I need this feature for a mobile form application.

    Please let me know the solution or a workaround.

  • Profile Image
    roneet
    Answered on February 21, 2021 at 01:03 PM

    You may use a Spreadsheet to Form widget to populate the data from the attached Excel sheet to the form:

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

    Let us know if this would work for you.

    Thanks.


  • Profile Image
    samuthana
    Answered on February 21, 2021 at 01:22 PM
    I checked that. The problem is that the lookup data in this case is static. I want it to be dynamic, based on the new updating of this file.
    Warm Regards,
    Dinakar
    https://dinakarmurthy.com/
    Sent from Outlook Mobile
    ________________________________
    ...
  • Profile Image
    Welvin
    Answered on February 21, 2021 at 06:51 PM

    Yes, the widget requires a static source. Unfortunately, there is no option to dynamically fill the source of the dropdown field. We do not have that feature yet in the form builder.

    I'm sorry to say, but we do not have a workaround for this. You can utilize the spreadsheet to form widget and just change the source manually when new data comes in.

    Thanks

  • Profile Image
    samuthana
    Answered on February 21, 2021 at 08:22 PM
    Thanks a lot.
    Warm Regards,
    Dinakar
    https://dinakarmurthy.com/
    Sent from Outlook Mobile
    ________________________________
    ...