Hey there fellow Coda makers,
I have sections assigned to team members which contain tables of contacts who they are trying to get to an event. Within those tables is data the team member will input that is associated with those contacts (i.e. # of registrations from that specific contact, etc).
Now, problem #1- After an event passes, I refresh all my data (such as the # of registrations associated with the contacts, etc). Problem #2- If a contact is reassigned to Team Member B for the next event, their attendance for the first event is changed as being caused by Team Member B instead of Team Member A.
So, I’m needing a way to store static data from these formulated Team Assignments and also the team stats in order to keep records and stats for my team members over time.
Maybe someone has an example doc they’ve seen that would point me in the right direction for team stat-keeping or something similar? Maybe I’m missing some simple formulas that are used for this?