I am tasked with displaying courses that were chosen from another list in my form.
1. The user selects the record from a dropdown.
2. I used a calculated value to get the multi selected courses for the selected record.
3. I used a calculated value to get the values from the multiselect returned in the first calculated value.
The problem is that only the first id values are returned. I am using if statements in the second calculated value but I think that is not the correct option.
If(contains(calculatedCourses,'[4;') || contains(calculatedCourses,',4;'),"Course:"+lookup("Training Types","ID","4","Display Name")+" Hours:"+lookup("Training Types","ID","4","Hours")+" Student/Teacher Ratio:"+lookup("Training Types","ID","4","StudentTeacherRatio"), If(contains(calculatedCourses,'[17;') || contains(calculatedCourses,',17;'),"Course:"+lookup("Training Types","ID","17","Display Name")+" Hours:"+lookup("Training Types","ID","17","Hours")+" Student/Teacher Ratio:"+lookup("Training Types","ID","17","StudentTeacherRatio"),"")) |
Does anyone know what I should be doing to get the values from each id in the multiselect field returned?
Â