Splitting Enumlist into seperate row of data

Hey guys,

I have a column to record the students attendance to a class. 

I have this as Enumlist so the teacher can dropdown and tick all the students name who were present.
Example of the table after the form is saved:
Date            Students present
03/03/22     Tom, Tim, Pat, Bob 

 

Now, when the form is saved, I would like to split the Enumlist into individual row of data. Like this:
Date              Students present
03/03/22                  Tom
03/03/22                  Tim
03/03/22                  Pat 
03/03/22                  Bob

So that I can track the attendance of individual student easily.

Could someone please help me with this?
I have seen a Template App that does a similar thing through Actions - I cannot locate the app unfortunately. 

 

Any help will be appreciated. Many thanks.

1 14 513
14 REPLIES 14
Top Labels in this Space