Can I link a Form field (it's a dropdown) to pull choices from another Table?

  • Profile Image
    darliechloe2
    Asked on January 06, 2022 at 08:04 PM
    • I have a table called "List of Products".
    • I have a Customer Info Form where I'll fill out when I get a new customer.


    Is it possible to set my Customer Info Form, to have a field called "which product" (a dropdown), and instead of manually typing out the list of products in the Dropdown Properties - Is there a way to directly pull from my "List of Products" table?

    Because obviously my "List of Products" will be linked to a few more other tables and keeps changing as well - I don't want to have to come inside "Dropdown properties" to make changes every single time...


    Thanks a lot!

    Chloe



  • Profile Image
    Sonnyfer
    Answered on January 07, 2022 at 12:23 AM

    Hello Chloe - Thanks for reaching out.

    I'm afraid having another table as a dynamic Data Source of a Dropdown isn't possible at the moment.

    If you want, we can forward the idea to our developers as a Feature Request. Could you confirm if the table you want use as Data Source is created in Jotform or a 3rd party table like Google Sheets?

  • Profile Image
    darliechloe2
    Answered on January 14, 2022 at 02:53 AM

    Hi Sonnyfer,

    Both tables are within Jotform now. If this is not possible yet, it's okay. I just want to know.

    Of course, it will be very powerful I guess if this is possible. ;-)

    Best,

    Chloe

  • Profile Image
    Christian_A
    Answered on January 14, 2022 at 06:17 AM

    Hi there,

    Thank you for understanding. I am raising this to our developers as a feature request. We are unable to provide a time frame as to this feature's availability but you will be notified through this thread as soon as this feature is implemented.

    Should you have additional queries, please let us know. Thank you!

    Regards,