tcwaters

Struggling with a Value List

Discussion created by tcwaters on Apr 21, 2017
Latest reply on Apr 21, 2017 by tcwaters

I've been struggling with a value list and would like some feedback about solutions to this issue.

 

I have a value list called "CourseOutcomeChoices.  It pulls related data, and it works, in that it shows the correct data, but the value list is wrongly ordered.

 

The data looks like this (field is Outcome Name)

PittPharmacy Outcome 1: Learner

PittPharmacy Outcome 2: Patient Assessor

PittPharmacy Outcome 3: Caregiver

(there are 11 possible outcomes.

 

In the Value List, if I have it show the name, it shows them in this order:

PittPharmacy Outcome 1: Learner

PittPharmacy Outcome 11: Life-long Learner and Innovator

PittPharmacy Outcome 2: Patient Assessor

PittPharmacy Outcome 3: Caregiver

 

If I have it also show a second field (id), it now displays in the correct order, but it looks like this:

 

PittPharmacy Outcome 1: Learner 1

PittPharmacy Outcome 2: Patient Assessor 2

PittPharmacy Outcome 3: Caregiver 3

...

PittPharmacy Outcome 11: Life-long Learner and Innovator 11

 

I can't find a way to show only the name, but have it sort them in the correct order (by id). If I choose "show only second field" I lose the ability to sort by the first field.

 

THX

Outcomes