Using Nintex Forms 2013 on-premise, I created a form and set a SQL Request Control to display customer’s ID from SQL database table.
Upon ID selection (field: customerID), I need to pull back 3 other fields. customerFirstName, customerLastName and customerEmail. All fields reside in same table.
SQL Request control works fine returning a single value such as:
Display field: customerID
Returning: customerLastName
But it doesn’t work at all when I try to return multiple values such as:
Display field: customerID
Returning: customerLastName, customerFirstName, customerEmail
I used SQL query with Concat() option and tried selecting fields using Alias name (to be used in Value field). All failed.
Can it be done?
How can I resolve this issue?
Thanks
Eric