Automate updating dropdown field options

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

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.

What do you mean you have to redo everything?
Sent from my iPhone
...

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.

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

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.