Is there a way to call a SQL command (SP) by using a Javascript (On button click), and return the values or result on same Nintex form, while keeping the form opened/ not submitted.
in a way like below, needs the get details/ call a SQL SP or web service and return the results on the below fields.
Is this possible with Nintex forms? without depending on Nintex workflow.
Hi,
assuming you are using IE this should give you start: How to connect to SQL Server database from JavaScript in the browser? - Stack Overflow
BUT as mentioned on StackOverflow: Sending SQL queries directly from JavaScript is a security issue and therefore I recommend some other approach.
I haven't used Nintex Forms in a while but isn't there a "SQL Query" control?
Regards
Philipp
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.