Hello, everyone. I'm trying to figure out how to populate text (or integer, or date, or whatever) fields on a form with data from a choice list table based upon a user's selection from a select_one (or maybe select_multiple) type question.
For example (though, not my actual survey), if I had an "Employees" choice list that looked like this:
Name | Label | Initials | Birthday | Years
BobTurner | Bob Turner | BT | 05/15 | 12
SallyJones | Sally Jones | SJ | 01/28 | 3
AlanSmith | Alan Smith | AS | 10/31 | 6
etc.
and had a ${EmployeeChoice} as a select_one field.
Can you code a ${EmployeeInitials} text field, a ${YearsWithCo} integer field, and/or a ${Birthday} date field based upon a user's selection in the ${EmployeeChoice} question?
I've tried the selected(${EmployeeChoice},Initials) code in the calculation and choice filter columns but it doesn't seem to work.
I suspect that this is a really basic question, but I just haven't had luck finding a solution, so I'd appreciate anyone's help.
Also, while I'm at it, is there a way to record the jr:choice-name of a select_one/_multiple question straight away or do I have to create a separate text field that has that jr:choice-name function mapped to it? It works fine with the latter, I just was wondering if there were a simpler option that I wasn't aware of.
Thank you everyone!
Mason
