[tellesmg]

Hello!

Can I to call a Microsoft Sql Server Stored Procedure inside a dropdown?

Please, check the attachment with a printscreen and a sample code..

[ayodelebamgboye]

Here are the general steps to do this:

Create a new dropdown control in your ProcessMaker form.
In the "Data" tab of the dropdown control settings, select "Dynamic" as the data source.
In the "Data Source" field, enter the SQL code to call your stored procedure.
n the "Display Field" and "Value Field" settings, select the appropriate fields from the result set returned by your stored procedure. These fields will determine the dropdown options that are displayed to the user and the corresponding values that are stored in the database.