A jotform widget that 1. connects to Azure SQL or MSSQL database
2. Reads a View on database
3a. Changes a jotform dropdown field's options.
3b. Changes default value of a jotform text field.
In widget settings I will provide the SQL database credentials, view name, column name.
Widget will read that view, get values, update a jotform dropdown options with these values
Similar to this widget
https://www.jotform.com/widgets/spreadsheet-to-form
The differences I want is
1. Read from SQL database
2. Change a jotform dropdown options (not value)
Similar to
https://www.jotform.com/widgets/dynamic-dropdowns