cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
harryr
Nintex Newbie

Retrieve search value from SQL database

Hi all

My question is what's the easiest way to retrieve data from an sql database and populate a field in a form?

Example: 

User types project code "12345"

User clicks "Find" button

Form retrieves and writes the result into the project name field on the form: "12345 - Project A"

I can see an SQL request control but not sure if this can all be done by configuring that or if it's more complicated.

version: Enterprise 2013 (2.10.2.0)

Thanks

Labels: (1)
0 Kudos
Reply
1 Reply
Automation Master
Automation Master

Re: Retrieve search value from SQL database

yes, that should be proper control for your.

you even need not to make users click on a button, the control allows you to build a query that automatically follows value in other control(s)

see the doc - http://help.nintex.com/en-US/nintex2013/help/#Forms/RootCategory/Controls/Nintex.Forms.Controls.SQLR... 

or this blog - https://community.nintex.com/community/tech-blog/blog/2015/07/22/nintex-forms-enterprise-sql-request... 

0 Kudos
Reply