Probably quite an easy one. I’ve got a boolean below our audio sessions to track which users are listening to which audio. If a user listens to a session I would like their email added to a new sheet with a boolean for which sessions they have listened to. I’ve created a relation for the booleans but I cant work out how to pull through their email.
So the flow is:
Someone listens to a session
Switches the ‘has listened’ boolean to true
They are added with their email to a new sheet with the sessions they listened to in columns.
Thanks in advance!