Automate updating dropdown field options

  • Profile Image
    tomhoffman
    Asked on August 03, 2018 at 02:23 PM

    Hello Jotform,

    Is it possible to create an action that would allow me to autoupdate a dropdown menu's options? We have a form with dozens of dropdown menu's and each menu has 50-100 options contained in it. The options could change daily so they will need to be updated nightly. Is it possible to do this through your API or through connection and scripts with a MYSQL database?


    Thank you

    Tom


  • Profile Image
    Richie_P
    Answered on August 03, 2018 at 03:35 PM

    In order to achieve this you need to get the form's source code and make some modification using PHP and Sql or MySQL.

    Do note that the downside in this is  when using custom script, you have to re-do everything if you want to go back to the form builder.

    Hope this information helps.

    If you need further assistance, please let us know.

    Thank you.

  • Profile Image
    tomhoffman
    Answered on August 03, 2018 at 04:43 PM
    What do you mean you have to redo everything?
    Sent from my iPhone
    ...
  • Profile Image
    Richie_P
    Answered on August 03, 2018 at 04:46 PM

    If ever you need to edit your form in the form builder again,such edits may or may not affect the over all functions of some of your scripts.

    Thank you.


  • Profile Image
    tomhoffman
    Answered on August 06, 2018 at 08:18 AM

    So, I assume we would need to host the form on our own servers as well? You mentioned getting the form's full source code, this is what we would use to embed into our own web page and connect to MYSQL.

    Is this correct?


    Thanks!


    Tom


  • Profile Image
    Richie_P
    Answered on August 06, 2018 at 09:49 AM

    When using the full source code, you can edit the elements of your form. You need to host the form in your own server and add it your web page.

    These articles may help in connecting your form to your MYSQL database.

    https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    https://www.jotform.com/blog/send-instant-submission-notifications-with-webhooks/


    Hope this information helps.

    If you need further assistance,please let us know.

    Thank you.