I am wondering if anyone knows a good way to set up a quickform node where a user selects a value from a list and the value assigned to a workflow variable is from a different column in the data table?
I have a Database Reader that generates a table such as this:
Then I want a user to select a name from a list, I used a Value Selection QuickForm that displays the ClientName.
What I'm wondering is if there is a way to assign the ClientID to the workflow variable instead of the ClientName? That way, if a user picks "Kevin" I'll get 543 that I could use in a SQL WHERE clause.
Thanks for any help!