I have a form that I'm using as a class register to record who has attended a particular class session. I have added a script to pull a list of students based on a selection of the type of session. The list of students appears in a multi select field and then you just deselect the students who weren't in attendance.

What I want to do is add a script so that when the form saves it adds a row in a report per person in the multiselect field along with the other single fields in the form. I then need to build a pivot to show who's attended what session during the year.

Any ideas if it can be done and how I script this? I've got 5 days left of my free trial and this will be the deal breaker as to whether we use Creator going forward or not.

My fields are:

Row ID (Auto No)

Form Completed by (Name Field)

Date of Class (Date Field)

Session (Drop Down Field)

Deslect Absent Students (Multi Choice Student) -  This filed displays the list of students depending on what is selected from the Session field.