I appreciate your help!
I have one main table of English learners who register for classes - name, contact info, etc. Let's call is the Main Student table.
There are two other tables that get data related to each student. (One table gets data from Stripe if the student is able to pay anything. Another table shows teacher comments about the student from the prior year.)
In the past, we set up links between the tables. Then, for each student, we manually linked the individual records and had "lookup" fields for the fee & comments in the main Student table. But we had 750 learners register with us last year!
How can we automate this? I'm thinking that an automation would need to:
1. Find matches between the Main Student table and the other tables (based on one or more of name / email / phone)
2. Update the record on the Main Student table with the data for that student in the other tables.
I have searched for examples (found one relevant one but from 2019) and tried some combinations of "find records" and "update record", but I'm lost. I have never used scripts ...
Thank you!!