I am attempting to build a Course request form the has a lookup into a Course list.
I created a "Courses" field in a Course Request list. I set it to be a multiselect and is a lookup into a Course List .
From the course request list form, if I select one course, i can successfully display the course's related fields such as description and cost. (I pulled onto the form a calculated field for the description and one for cost and applied the lookup() function. eg. lookup("Course List", "ID", Courses,"Description") )
If I select more than 1 course on the form however, I only ever see the first course's information.
Question: How would I set up the form so it can show values to more than 1 course at a time. For example, If I pick 3 courses, I want to see all 3's cost and descriptions.
Thank you in advance!
unfrotunatelly lookup() function doesn't accept multivalue inputs.
an option might to add a repeating section on the form and select single course and lookup for respective details on each row.