hi friends! we are an organization that provides online trainings. i have a base with registrations in one table and a unique attendance list in another table. the other table has a list of all the trainings.
so the registrations table is all the registrations we received for each training, so that we can see things like: 100 people registered for training X, 80 were approved to attend (either because they were members or they paid), and 70 actually attended. because people attend multiple trainings, this list contains different registrations for the same person.
the attendance table is a list of each person who ever attended a training with a related record field that contains all the trainings they attended, linked from the list. that way we can see things like: 300 people attended our trainings last year, person X attended 4 trainings, Y organization sent 4 people to trainings last year.
i have an automation set up that after a training happens & we record the attendance, it takes the person from the registrations table, finds them by email on the attendance table, adds them if they're not there, and adds the most recent training to their related records field.
this automation works SOME OF THE TIME. i have been triggering it record by record, to see if i can discern why, and i cannot. for the most recent training, it did 11 people just fine, some of whom already existed in the attendance table, and some didn't, and some of whom had existing related records in that field & some didn't. argh, what am i missing???
thank you friends, for any assistance!