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.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |