Hello I need some help with the Rollup,
I have two tables: Points Tracker and Members
In the Points Tracker table, there are 3 columns: Member Email, Event Name, Points.
Whenever someone joins an event, we get their email and the name of the event that they joined and based on the event name they got different points. Same people can join multiple events and collect points from each event such as:
first @gmail.com - Event1 - 15 Points
second @gmail.com - Event1 - 15 Points
first @gmail.com - Event 2 - 10 Points
The Members table has two columns: Member Email and Points
What I’m trying to do is to feed the Members table back with the sum of the Points a member got looking at the Points Tracker table:
email@example.com - 25 Points
I used Roll Up in the Members table but I need to manually select the related records anytime there is a new record in the Points Tracker table. For example, in order to deduct 25 points for the first member, I manually selected firstname.lastname@example.org - Event1 - 15 Points and email@example.com - Event 2 - 10 Points.
Is there a way to automate this (with or without scripts) so that whenever there is a new record in Points Tracker with the email of the first member it automatically updates the total points the first member got in the Members table?